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.
- Click
, the Dashboards tab.
- Click Dashboard Designer, in the bottom-left corner.
- On the Analyses dialog, click
, the Options button, next to an analysis and select Edit.
- On the analysis page, select a table.
- To sort by a single column:
- Click the header of the column that you want to sort.
- Under Sort by, set the sorting order and select the field that you want to sort by.
- To sort by multiple columns:
- Click
, the Sort visual icon, in the top-right corner of the table.
- 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.
- 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.
- Click Apply.
- Click
- To sort by a field that is not included in the table:
- Click the header of the column that you want to sort.
- Select .
- 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.
