Last Modified Date: 27 Dec 2018
- Tableau Desktop 10.5
- Tableau Server 10.5
Option 1: Replace the top N filter with a RANK() calculationWhen filtering the view with a RANK() calculation on values 1-N, then Tableau will show all ties.
Option 2: Add another metric to determine how ties should be brokenFor example, if several customers have the same exact sales item, then create a calculated field that sums sales and quantity. Create a top N filter on this calculated field rather than on sales.
CauseWhen there are ties, then Tableau Desktop or Tableau Server randomly determines the order. In each version, Tableau is choosing a different order for the tied ranks, and thus a different set of top N are showing.
Additional InformationUsing a top N filter that randomly filters out some items with a tied rank can be deceptive, because the view assumes the filtered out items are less in some way. Showing all ties, or adding a tie breaker are more robust methods.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials