In this silent video you’ll learn how to show a the dimension member with the highest measure value in Tableau.
Read the full article here: Finding the Dimension Member with the Highest Measure Value - kb.tableau.com/articles/howto...
- - - - - - - - - - - - - -
OPTION 1
1. Drag Regions to Rows.
2. Drag Measure Names to Columns and Measure Values to Text.
3. Create three calculated fields.
4. Name the calculated field "Maximum regional sales (LOD)" and enter the following formula: {FIXED : MAX( { FIXED [Regions] : SUM( [Sales] ) } ) }
5. Add the calculated field to the Rows shelf
6. Right click the calculated field on Rows and convert it as Discrete
7. Right click the calculated field on Rows and select Format... to remove or customize decimals.
8. Name the calculated field "Region with highest sales Filter (LOD)" and enter the following formula: { FIXED [Regions] : SUM([Sales]) } = [Maximum regional sales (LOD)]
9. Add the calculated field to the Rows shelf
10. Name the calculated field "Region with highest sales (LOD)" and enter the following formula:
IF { FIXED [Regions] : SUM( [Sales] ) } = [Maximum regional sales (LOD)]
THEN [Regions]
END
11. Drag [Region with highest sales (LOD)] to the Rows shelf.
OPTION 2
1. Drag Regions to Rows.
2. Drag Measure Names to Columns and Measure Values to Text.
3. Create three calculated fields.
4. Name the calculated field "Maximum Sales (table calc)" and enter the following formula: WINDOW_MAX( SUM( [Sales] ) )
5. Add the calculated field to the Rows shelf
6. Right click the calculated field on Rows and convert it as Discrete
7. Right click the calculated field on Rows and select Format... to remove or customize decimals.
8. Name the calculated field "Region with highest sales (table calc)" and enter the following formula:
IF SUM( [Sales] ) = [Maximum Sales (table calc)]
THEN MIN( [Regions] )
END
9. Add the calculated field to the Rows shelf
Related
Transform Values with Table Calculations - help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm
Overview: Level of Detail Expressions - help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm
- - - - - - - - - - - - - -
Subscribe to the Tableau RU-vid channel here: ru-vid.com_c...
Free Trial of Tableau: www.tableau.com/products/trial
25 авг 2019
