Here's a quick answer for you that should point you in the right direction. This is using the default Superstore Sales data and a calculated field I called "Rank".
Index is going to simply give us the position in the list of things on the viz.
To start, I added year and customer to my viz and displayed sales as a bar. After dragging rank on as a filter, I right clicked on it to access the Edit Table Calculation option. I used the "advanced" option under "compute using", moved both fields (Year and Customer) to the right side of the dialog and sorted by descending Sales.
Then I OK'd that and came back to my table calculation dialog, asking it to rank by customer and restart every year.
At that point, it's just a matter of filtering to get only the top X (in this case 10). To get the rank into the view, I cntrl+dragged it into labels and also created a discrete version to sort my customers by (right click, convert to 'discrete', drag between customer and year, then uncheck "Show Header" for that pill.
Hope that helps - I've linked to a Tableau Public visualization demonstrating the product below.
thank you. That solved the problem.
Hello everyone ,
How can i make a top 10 devices table that are sending data to my oracle DB if i have 800 devices and a point is that will dynamical change the divaces if in the DB the traffic log change. I must show in my table the top 10 devices and all other devices to be grouped to "Others" ? Has someone some idea?