Measure Names and Measure Values in Tableau

Shared axis charts are simple to create—simply drag another measure to an existing axis. However, various shelves and cards in the Tableau workspace suddenly show lots of changes based on this simple drag-and-drop. You’ll now notice several Measure Names and Measure Values fields appearing in various parts of the workspace. In summary, Measure Names and Measure Values are a way of allowing more than one measure to appear in the same place. 

Measure Names exposes the names of multiple measures. Measure Values exposes the actual values of the measures. The two values are the sum of sales and the sum of profit. You’ll notice that Measure Names is automatically placed on the Filters shelf, even though no data is being filtered from the underlying data source.

 Instead, the Measure Names filter is limiting the measures exposed to just sales and profit—all other measures in the data source will appear in the Measure Names filter, but only sales and profit are checked.

 And, you’ll notice Measure Values is placed on a shelf to place multiple measures on the same shelf, without creating a new row or column for each measure. Furthermore, Measure Names has been placed on Color on the Marks card in the example illustrated to create different colors for sales and profit.

Another helpful use of Measure Names and Measure Values is when you wish to use more than one measure in a text table/crosstab (text tables are discussed earlier in this chapter). 

Although you may drag more than one measure on Text on the Marks card to add multiple measures to a text table, you’ll probably prefer the results when you double-click to add more measures. For example, if you drag desired dimensions to Rows and Columns shelves and then simply double-click a measure, the measure will automatically be placed on Text and will appear at the intersection of the row and column dimensions. 

Instead of dragging a second measure to Text, simply double-click the second measure. Tableau will invoke Measure Names and Measure Values, placing Measure Values on Text to show multiple measures in the same place, and Measure Names on Rows to create a separate row for each measure. Differences between Dimension and Measure

The added benefit of this approach, when compared to dragging individual measures to Text, is that a single set of headers appears containing the names of the measures. No special effort is required (such as a calculated field or manual editing of the text value) to properly label multiple measure rows or columns.

For more info to learn at Tableau Online Training

Started by minati biswal at October 09, 2019 - 11:24 PM