What is the difference between Tableau’s RANK() and RANK_DENSE() table calculation functions?

Question

Tableau — Hard

What is the difference between Tableau’s RANK() and RANK_DENSE() table calculation functions?

Accepted Answer

The RANK() function assigns a unique rank to each value, skipping ranks in case of ties. In contrast, RANK_DENSE() does not skip ranks, ensuring consecutive rank numbers. This distinction affects the ranking outcome. RANK_DENSE() provides a more compact ranking.