Top/Bottom

Contents[Hide]

The Top/Bottom transform filters the records to contain the top or bottom 'N' number of records as ranked by the columns you select.

Transform - Top/Bottom
Transform - Top/Bottom

1. Input

The Top/Bottom transform requires one input transform that has at least one column.

For our example, we'll use the output of the Aggregate transform, as seen below:

Example input data
Example input data

2. Add the transform

Select the connector link between two transforms.

Select a connector link
Select a connector link

In the toolbar, choose Insert Other, then Top/Bottom.

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

Steps to configure the Top/Bottom transform:

Top/Bottom transform configuration dialog
Top/Bottom transform configuration dialog

  1. Enter a Record Count.
  2. Choose a Starting Point to select either the records at the Top or Bottom of the result after sorting.
  3. Uncheck any columns you don't want included in the output.
  4. Drag and drop the columns from the left that you want used to sort the data, and drop them under Sorting Elements. Data will be sorted first by the first element listed, then by the following elements.
  5. Click the arrow icon for each sorting element to determine whether to sort by its values Ascending (up arrow) or Descending (down arrow).

Select Use Record Grouping if you want to return the number of records specified above multiple times for groups of records. A list of Grouping Elements will appear: select elements that should have a separate top/bottom list for each of their values.

4. Output

The figure below illustrates the output from the Top/Bottom transform for the Top 5 records as sorted Descending by OrderQty:

Top/Bottom example output
Top/Bottom example output

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