I cannot for the life of me get a ranking calculation to work properly. I have spent a couple hours at this point googling and trying various solutions. I'm probably missing something obvious (I haven't used Tableau much in the past year), so any help would be greatly appreciated!
I want to rank players by their total wins. This works easily enough until I add another dimension to color. At this point, RANK and INDEX both return unexpected results, and no amount of fiddling with the table calc settings seems to be able to get it working. Packaged workbook attached.
I attached a packaged workbook that solves this two slightly different ways. Both use RANK_DENSE(), because you are ranking players by their total win count but displaying it with additional dimensions (e.g. tournament). This will cause "ties" and probably not what you want.
When you edit your table calc settings (via right-click -> Edit Table Calculation), you should use the "Specific Dimensions" option and check everything for the Rank pill. For each player's wins, you would:
- Table calc: Uncheck what the ranks should be grouped by (e.g. Player)
- Fixed LOD: Ensure the dimensions listed are the level you're calculating at (e.g. Player)
You will need to repeat the Edit Table Calculation process each time you add a dimension to the sheet. (e.g., if you add Year, for the Rank pill you would need to go back and check Year, assuming you still want it by total wins.)
There's a nice explainer for table calc addressing vs. partitioning here:
https://tableauadventurer.com/2024/05/31/mastering-table-calculations-pt-1-from-basics-to-advanced-settings/Hope this helps!
