Rank

Contents[Hide]

The Rank transform allows for a rank number to be assigned to a new element created by the transform. This transform should be used right after a Sort transform, so that the correct ranking will be generated based on the sorting rule.

Transform - Rank
Transform - Rank

1. Input

The Rank transform requires 1 input transform that has at least 1 column. The input could be a SQL Select transform, or the result of another transform. For example, we'll use the unsorted Sales data below:

Input Data: Unsorted data
Input Data: Unsorted data

In order to sort the Sales data and apply the proper Ranking, you first need to add a Sort transform. In this sample, 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

Steps to add the transform:

  1. Select the connector link.

    Adding the Rank transform - Step 1
    Adding the Rank transform - Step 1

  2. Select the transform from the menu.

    Adding the Rank transform - Step 2
    Adding the Rank transform - Step 2

  3. To Edit/Configue the transform, select the newly added transform, and click the Configure menu.

    Adding the Rank transform - Step 3
    Adding the Rank transform - Step 3

3. Configure

  • Name: Name of the transform, optional
  • Description: Description of the transform, optional
  • Rank Element Name: Assign the column name, default = "Rank"
  • Rank Element Description: Assign the column description, default = "Rank of record"
  • Rank Type: Select the type of ranking method. Options are:
    • 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: The sequence of numbers should not skip when consecutive records contain the same value(s) in the rank elements.
  • Rank Transform Input: Select the columns you want to be included in the output.
  • Ranking Elements: Drag and Drop the column(s) you want to include in the sorting key.

4. Testing

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