March 1, 2016
Tableau Tip Tuesday: How to Display the Top N and Retain the % of Total
This week’s tip was sparked by a question that Jules Winceslaus of the Data School asked during a project we worked on last week for a customer. He created a bar chart that showed the percent of total, yet when he filtered the dimension, he wanted the original percent of total to remain. That is, the bars shouldn’t be recalculated based on the filter.
In the video and example below, you’ll learn how the rank function can be used to filter the results in the view without impacting the percent of total calculation.