About
Rank is a statistic / function that calculates the rank of a value in a group of values.
The position of an element in a sequence is its rank or index.
This function is used in:
- top-N and bottom-N reporting.
- quantile analysis A quantile function will always rank the data before giving any output.
Rank is a display function.
See also Ordinal Data
Calculation Scope
Rank can be used:
- As an aggregate function (on the whole set)
- As an window function (on a subset of the set)