In Tableau we can rank members using RANK or INDEX. These are dynamic functions calculated based on what's on displayed on the visualization. It's part of a set of functions called 'Table Calculations'. Because of this, you need to have all 3 dimensions in the visualization and then make sure the calculation uses those 3 to run (compute using) the ranking. In other words (or images):
Index is a calculation that uses the parameters for [Top N] selected by the user:
That does it. I personally think that a pie chart is not the best way to display information, but given there's only 3 pieces in this pie, it may be OK. If you were to have more than that, I'd encourage you to explore a bar chart instead:
With Tableau Prep now part of the Tableau Platform, you could now create the rankings as part of your data set, which would eliminate the need to use Table Calculations. An example regarding how you calculate a rank in Prep can be seen here: Rank and Ranking in Tableau Prep | VizPainter
If you'd like to learn more about Table Calculations and other functions in Tableau, I'd suggest looking at the free training videos available here: Tableau Training: View Training Courses
Hope this helps!
RankPie.twbx 23.3 KB
Hi, Thanks for Looking into this. But I am seeing the wrong values when I marked the labels for SUM of Price on the PIE.
However I was able to fix the issue in very complex route I believe. Soon I post a video to this link. Just to let you know I am just ~4 days old with Tableau.
Once again I really appreciate your help!!
When I applied the custom sort for the sum of price in desc. I am getting PIE like this.
1 of 1 people found this helpful
Here is the video link: