Rank calculations in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the RANK() function do in Tableau?

The RANK() function assigns a rank number to each value in a partition, with 1 being the highest or lowest depending on the order specified.

beginner

How do you rank sales from highest to lowest in Tableau?

Use RANK(SUM([Sales]), 'desc') to rank sales from highest (rank 1) to lowest.

intermediate

What is the difference between RANK(), RANK_DENSE(), and RANK_UNIQUE() in Tableau?

RANK() skips ranks after ties, RANK_DENSE() does not skip ranks after ties, and RANK_UNIQUE() assigns unique ranks to each row regardless of ties.

intermediate

Why is partitioning important in rank calculations?

Partitioning defines the group over which ranking is calculated, so ranks reset for each partition group.

intermediate

How can you handle ties in rank calculations in Tableau?

You can choose different rank functions like RANK() or RANK_DENSE() to control how ties are ranked and how ranks are skipped or not.

Which Tableau function assigns rank numbers without skipping ranks after ties?

A RANK()

B RANK_UNIQUE()

C RANK_DENSE()

D INDEX()

RANK_DENSE() assigns ranks without skipping numbers after ties.

What does RANK(SUM([Profit]), 'asc') do?

A Ranks profits from lowest to highest

B Returns the index of each row

C Calculates the sum of profits

D Ranks profits from highest to lowest

The 'asc' argument ranks values from lowest (rank 1) to highest.

In Tableau, what is the role of partitioning in rank calculations?

A It filters data before ranking

B It defines groups where ranking restarts

C It sorts data alphabetically

D It changes the rank function

Partitioning defines groups over which ranks are calculated separately.

Which function would you use to assign the same rank to tied values and skip the next rank(s)?

A INDEX()

B RANK_DENSE()

C RANK_UNIQUE()

D RANK()

RANK() assigns the same rank to ties and skips the next rank(s).

What rank does the highest value get when using RANK() with 'desc' order?

A 1

B 0

C The last rank

D Depends on partition

With 'desc' order, the highest value gets rank 1.

Explain how you would create a rank calculation for sales by region in Tableau.

Think about grouping and ordering your sales data.

Describe the differences between RANK(), RANK_DENSE(), and RANK_UNIQUE() and when you might use each.

Focus on how ties affect the rank numbering.