Data Viz Done Right

May 19, 2020

#TableauTipTuesday - Re-Rank Metrics Based on the Overall Rank

No comments
Here's the scenario:
  1. You want to filter a dimension (e.g., State) by the top 10 overall rank. 
  2. You want to re-rank the remaining dimension members (i.e., top 10 States overall) within other metrics. 

For example, Massachusetts is ranked 10th overall and 21st in sales. Once I filter to the overall top 10, the rank should be recalculated to show where Massachusetts ranks in sale amongst the other States in the top 10 overall.

In this tip, I show you how to re-rank the dimensions filter remaining from the overall rank within other metrics.

No comments

Post a Comment