Rank Value

Contents[Hide]

The Rank Value function returns the value found at the specified position, either starting from the highest or the lowest value.

Rank Value
Rank Value

1. Syntax

RANKVAL(d0,s0,s1,s2,Alignments...)

2. Input

The Rank Value function requires the following input:

  • d0 – The set of data values for which the Rank Value is calculated.

3. Parameters

The Rank Value function requires the following parameters:

  • s0 – The rank position in the list of values.
  • s1 – The sorting type. 0 ranks from the highest value to the lowest, while 1 ranks from the lowest to the highest.
  • s2 – Whether duplicate values are considered as multiple values in the ranking. The default value is false.
  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.

4. Output

The Mode function generates the following output:

  • Rank Value - The single value from the data set that corresponding to the indicated rank.

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: 7am-6pm, ET, Mon-Fri