Subset Data Using the Ranking Dialog Box (Relational Data Only)

Create a New Ranking

To create a new ranking:
  1. Select Datathen selectRanking from the main menu bar.
  2. Select the column that you want to base the ranking on, and then click Edit.
  3. Specify whether you want the greatest values or the least values for the selected column:
    Top
    specifies the greatest values.
    Bottom
    specifies the least values.
  4. In the text field, specify the number of results that you want.
  5. Select Count from the drop-down list.
  6. If you want to include ties (equal values for the last-place ranking) in your results, select Include Ties.
  7. Click OK to return to the first page of the Ranking dialog box.
  8. Click OK to apply your changes and return to the main Visual Data Explorer page.
For example, if you specify Top, 10, Count, and Include ties, only the rows that have the 10 greatest values (including ties) for the selected column are shown in the table.

Edit a Ranking

To edit an existing ranking:
  1. Select Datathen selectRanking from the main menu bar.
  2. Select the column that contains the ranking that you want to edit, and then click Edit.
  3. Change the ranking values, and then OK to return to the first page of the Ranking dialog box.
  4. Click OK to apply your changes and return to the main Visual Data Explorer page.

Remove a Ranking

To remove a ranking:
  1. Select Datathen selectRanking from the main menu bar.
  2. Select the column that contains the ranking that you want to clear, and then click Clear.
  3. Click OK to apply your changes and return to the main Visual Data Explorer page.