Sort

Contents[Hide]

The Sort transform allows various sorting rules to be applied to the input columns and copies the results to the output. The sorting applied is only applicable inside the data cube. The sort transform should never be the last transform before the process result as this will just result in unneccessary processing and overhead.

If the data provider of the previous transform supports sorting then an optimized query will be generated and sent to the server.

Transform - Sort
Transform - Sort

1. Input

The Sort 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, a table showing Location and Sales.

Input Data: Location and Sales
Input Data: Location and Sales

2. Configure

Steps to configure the Sort transform:

  1. Select the column(s) you want to be included in the output.

    Sort transform configuration - Step 1
    Sort transform configuration - Step 1

  2. Drag and drop the sorting column(s) from the Sorting Transform Input pane to the Sorting Elements pane.

    Sort transform configuration - Step 2
    Sort transform configuration - Step 2

  3. Click the Sorting Direction to toggle between Ascending (default) and Descending.

    Sort transform configuration - Step 3
    Sort transform configuration - Step 3

3. Output

The figure below illustrates the output from the Sort transform. Output shows data sorted by Sales in descending order, and then by Location in ascending order.

Sort - Warning message
Sort - Warning message

Important - As you can see, the Sort transform node is in red. Normally, a transform node is in red if there's an issue with the configuration. The Sort transform is in red since there's no other transform right after the Sort transform. Sorting the data for no particular purpose will just result in unnecessary processing and overhead. It is highly recommended that you use the Sort transform in conjunction with another transform, e.g. Pivot or Rank.

To illustrate, in the previous output, data is sorted by Sales from highest to lowest. However, if you use the Data Cube in the dashboard, the data is un-sorted as seen in the screenshot below, and you need to apply the necessary sorting rule in the data binding panel. This is the reason why is is unnecesary to use the Sort transform by itself.

Data is un-sorted in the dashboard
Data is un-sorted in the dashboard

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