Rank Function

Contents[Hide]

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

Rank
Rank

1. Syntax

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

2. Input

The Rank function requires the following input:

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

3. 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.

4. Output

The Rank function generates the following output:

  • Rank - The Rank result set.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri