EXAMPLE - RANK Functions

This example demonstrates the following two functions:

• RANK - Generates a ranked order of values, ranked within a group. 
  • If there are three tie values in a group, the next ranking is three more than the tie values.
  • See RANK Function.
• DENSERANK - Generates a ranked order of values, ranked within a group.
  • If there are three tie values in a group, the next ranking is one more than the tie values.
  • See DENSERANK Function.

Source:

The following dataset contains lap times for three racers in a four-lap race. Note that for some racers, there are tie values for lap times.

Transform:

You can apply the RANK() function to the Time column, grouped by individual runner:

window value: RANK() group: Runner order: Time

You can use the DENSERANK() function on the same column, grouping by runner:

window value: DENSERANK() group: Runner order: Time

Results:

After renaming the columns, you have the following output: