How to find the Dimension Member with the Highest Measure Value in Tableau

1 Просмотры
Издатель
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 —

- - - - - - - - - - - - - -

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 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 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 -

Overview: Level of Detail Expressions -
- - - - - - - - - - - - - -

Subscribe to the Tableau YouTube channel here:

Free Trial of Tableau:
Категория
Кулинарные лайфхаки
Комментариев нет.