Tableau Top N Item ranking with Other tutorial
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- In this video, I will be going over how to do a top N ranking of sub-categories with an 'other' rollup of the remaining sub-categories for each category partition using the Sample Superstore Dataset provided by Tableau.
The data can be found when you open up Tableau and instructions to access it are on the Tableau website: help.tableau.c...
Great video. I would suggest that instead of sorting on Sub-Category, create a combined field with Category and Sub-Category, and replace Sub-Category with it. Create the Sub-Category plus other exactly like you did. However, compute all table calculations using the combined field instead. The reason behind this is that in the video, you're sorting not by Sub-Category within Category, but instead by Sub-Category as a total. This would create problems if there is the same Sub-Category value within two or more Categories (which is the case for many of us watching this).
finally found this video to solve my proble problem!thank you
I’m glad this video helped you!
Hi , how do convert it to percentage of total