May
28
Sorting 100% Stacked Bars by Percentage
The 100% Stacked Bar Chart is the one where each segment is a percentage, which adds up to 100%.
Someone asked me recently how to sort the bars according to a segment's percentage. I thought it must be easy: Just google it. Then I tried myself and didn't find a satisfactory reference. So I decided to write one. In the process I did get inspirations from these two sources: Sorting a stacked bar chart using a parameter and a solution by Zhouyi Zhang in the Tableau's community site. Here I am going to present two solutions: using LOD (Level of Details) and Table Calculations.LOD vs Table Calculations
Both are good for implementing most of Tableau designs. One or the other, depends on our choice. The main difference is:
LOD: It's context sensitive.
Someone asked me recently how to sort the bars according to a segment's percentage. I thought it must be easy: Just google it. Then I tried myself and didn't find a satisfactory reference. So I decided to write one. In the process I did get inspirations from these two sources: Sorting a stacked bar chart using a parameter and a solution by Zhouyi Zhang in the Tableau's community site. Here I am going to present two solutions: using LOD (Level of Details) and Table Calculations.LOD vs Table Calculations
Both are good for implementing most of Tableau designs. One or the other, depends on our choice. The main difference is:
LOD: It's context sensitive.