What is the Rank Function in Tableau?

1.	What is the Rank Function in Tableau?
Answer» Rank function is used to give positions (rank) to any measure in the data set. Tableau can rank measure in the FOLLOWING ways: Rank: The rank function in Tableau accepts two arguments: aggregated measure and ranking order (optional) with a default value of desc. Rank_dense: The rank_dense also accepts the two arguments: aggregated measure and ranking order. This assigns the same rank to the same VALUES but doesn’t stop there and keeps incrementing with the other values. For instance, if you have values 10, 20, 20, 30, then ranks will be 1, 2, 2, 3. Rank_modified: The rank_modified assigns the same rank to SIMILAR values. Rank_unique: The rank_unique assigns a UNIQUE rank to each and every value. For example, If the values are 10, 20, 20, 30 then the ASSIGNED ranks will be 1,2,3,4 respectively.

Answer»

Rank function is used to give positions (rank) to any measure in the data set. Tableau can rank measure in the FOLLOWING ways:

Rank: The rank function in Tableau accepts two arguments: aggregated measure and ranking order (optional) with a default value of desc.
Rank_dense: The rank_dense also accepts the two arguments: aggregated measure and ranking order. This assigns the same rank to the same VALUES but doesn’t stop there and keeps incrementing with the other values. For instance, if you have values 10, 20, 20, 30, then ranks will be 1, 2, 2, 3.
Rank_modified: The rank_modified assigns the same rank to SIMILAR values.
Rank_unique: The rank_unique assigns a UNIQUE rank to each and every value. For example, If the values are 10, 20, 20, 30 then the ASSIGNED ranks will be 1,2,3,4 respectively.

Discussion