Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (2.5k points)
recategorized by
Could anybody tell me how to rank by category in Tableau?

1 Answer

0 votes
by (7.2k points)

In tableau there are few options for ranking that we are using, like RANK_UNIQUE,

It assigns the same ranking value for the categorical variables that have the same label name. 

For better understanding you need a example:

If you had rows where 2 categories were the same, like "Office Supplies" appeared twice, then with RANK_UNIQUE if you were ranking on the sales function, then you'd get a 2 or 3 (or whatever the rank is) appear for both rows

In your context you can likely get away with the standard RANK function:

RANK(AVG([Sales]))

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 4, 2019 in BI by Vaibhav Ameta (17.6k points)

Browse Categories

...