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