Sorting Data in Tables

You can sort the values in a table in ascending or descending order based on one or multiple columns or based on a field that is not included in the table. You can sort up to 10 columns in a single table.
To sort the data in a table:
  1. Click Dashboards tab, the Dashboards tab.
  2. Click Dashboard Designer, in the bottom-left corner.
  3. On the Analyses dialog, click Options button, the Options button, next to an analysis and select Edit.
  4. On the analysis page, select a table.
  5. To sort by a single column:
    1. Click the header of the column that you want to sort.
    2. Under Sort by, set the sorting order and select the field that you want to sort by.
  6. To sort by multiple columns:
    1. Click Sort visual icon, the Sort visual icon, in the top-right corner of the table.
    2. In the Sort visual dialog, select the first field that you want to sort by from the Sort by list and set the sort order.
    3. Click Add sort and select the second field that you want to sort by from the Then by list and set the sort order.
      You can add up to ten sorts to a table.
    4. Click Apply.
  7. To sort by a field that is not included in the table:
    1. Click the header of the column that you want to sort.
    2. Select Sort by ⇒ Off-visual field.
    3. On the Off-visual field panel, select the field that you want to sort by and the aggregation method, set the sort order, and click Apply.
    You can configure only one off-visual sort in a table. If you add an off-visual sort to a table that already has a single or multi-column sort, the off-visual sort overrides all other sorts.
To revert a table to its original state, click Sort visual icon, the Sort visual icon, in the top-right corner of the table, and then click Reset in the Sort visual dialog.
Parent topic: Using Tables