TIBCO Cloud™ Spotfire® Web Client User Guide

Sorting a table

In a table visualization you can sort the rows by the values in a data column. Depending on the type of data, an alphabetical, numerical, or chronological sorting of the column values is applied. You can also make a subsequent sorting of the rows by the data in another column.

About this task

The order can be ascending or descending. In an ascending order, text values are sorted from A to Z, numerical values from lower to higher, and dates from older to newer, and in the descending order, the values are sorted the other way around.

Procedure

  1. In the table, click the header of the column containing the values you want to sort by.
  2. In the opened menu, beneath Sorting, click to sort from lower to higher values, or click to sort the from higher to lower values.
    The rows are sorted by the column values, and an arrow in the column header indicates in which order.
    Note: You can click None in the menu to return to the default order.
    Tip: You can click the header while pressing Shift to switch between the sorting modes.
  3. If you want to sort by the values in more than one column, click the header of the next column while pressing Shift + Ctrl.
    Within each group of equal values from the first sorting, the rows are sorted by the column values in this second column in an ascending order.
    Tip: You can repeat this step to sort the rows by the values in more columns.
    Note: If you press Shift + Ctrl once again while clicking an already sorted column, the sort order changes to descending.

Example

The table below lists male and female customers of different ages, and located at two different places.
Table
To get a more structured view of the table, the City header below has been clicked, followed by in the opened menu, to gather London and Manchester customers, respectively.
Sorted table
Also, within each city, you may want to list male and female customers separately. Simply click the Gender header while pressing Shift + Ctrl. To list Male first, that is, to get a descending order, press the Gender header one more time while pressing Shift + Ctrl.
Sorted table
If you click the Age header while pressing Shift + Ctrl , the ages will also get sorted within each sorted group.
Sorted table