Rank Function

This applies to: Managed Dashboards, Managed Reports

The Rank function calculates the rank for each value in a set of input values.

Syntax

RANK(d0,s0,s1,s2,Alignment)

Input

The Rank function requires the following input:

• d0 - The set of data values for which the rank is calculated.

Parameters

The Rank function requires the following parameters.

• s0 - Indicates which way the values should be sorted for ranking. 0 for descending, 1 for ascending. The default value is 0.

• s1 - Indicates how ties should be handled. The default value is 0.

  0 - Order of occurrence breaks tie

  1 - Podium

  2 - Lowest possible

  3 - Highest possible

• s2 - If greater than 0, ranks will be scaled so that the highest rank is the value. The default value is 0.

• Alignment (optional) - Hierarchy placeholder to be used as the alignment axis.

Output

The Rank function generates the following output:

• Rank - The Rank result set, consisting of rank values corresponding with each input value.

For more information, see:

• Rank

• Adding Formulas