Rank

Contents[Hide]

The Rank transform ranks your data and adds the rank number to your input. This transform should be used right after a Sort transform, so that the data will be ranked according to your sorting rule.

Transform - Rank
Transform - Rank

1. Input

The Rank transform requires one input transform that has at least one column.

For our example, we'll use the unsorted data below:

Unsorted example data
Unsorted example data

In order rank the data according to our Sales numbers, we will first need to add a Sort transform. In this example, the sorting rule applied is by Sales (descending order), followed by Location (ascending order).

Sort transform configuration
Sort transform configuration

Sorted data to be used as input for the Rank transform
Sorted data to be used as input for the Rank transform

2. Add the Rank transform

Select the connector link between two transforms.

Select a connector link
Select a connector link

In the toolbar, choose Insert Other, then Rank.

Adding from the toolbar
Adding from the toolbar

To edit/configure the transform, select it and choose Configure in the toolbar.

Configure the transform
Configure the transform

3. Configure

In the Rank transform configuration dialog:

Configuring the Rank transform
Configuring the Rank transform

Optionally set the Name and Description for your reference.

Set Rank Element Name to name the new column that will contain the rank number, and an optional Rank Element Description.

Set Rank Type to one of the following:

  • Standard - Consecutive values are assigned based on the sorting order (e.g., 1, 2, 3, 4).
  • Podium - If the value of consecutive records are the same, then the same rank is given (e.g., 1, 2, 3, 3).

Continue Sequence option
Continue Sequence option

If you chose Podium, a Continue Sequence option appears. If selected, the sequence of numbers will not skip when consecutive records contain the same values in the rank elements. For example, if unchecked, the sequence could be 1, 2, 3, 3, 5.

Under Rank Transform Input, uncheck any columns you don't want to be included in the output.

Drag and drop the input columns to Ranking Elements that you want to include in the sorting key. The input data should already be sorted by these elements.

4. Output

The following is the output for our example with Rank Type set to Standard:

Output using Standard rank type
Output using Standard rank type

With Rank Type set to Podium, with Continue Sequence selected:

Output using Podium rank type and continuing sequence
Output using Podium rank type and continuing sequence

With Continue Sequence unchecked:

Output using Podium rank type without continuing sequence
Output using Podium rank type without continuing sequence

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