(v24) Sort Data in a Table

Sort Data in a Table

This applies to: Visual Data Discovery

The data in the table can be sorted by one or more columns of data. After you save the dashboard or visual, the sort settings are retained when you close it. The sort settings are also retained when you export and share the table.

Sort the rows in a table by the data in a single column

• To sort the data in ascending order, select the column heading once.

• To sort the data in descending order, select the column heading two times.

• To return the data to its original sort order, select the column heading three times.

Remember to save the dashboard to retain the sort order.

Sort the data rows in a table by the data in multiple columns

1. Sort the data in ascending or descending order by your first column, as described above.

2. Sort the data in ascending or descending order by your next column as described above. The number 2 appears in the column heading and the data is sorted first by the first column selected, then by the second column selected.

3. Continue adding additional columns to the sort. The numbers in the column headings will continue to increment.

4. Change the order of a multicolumn sort by selecting the column header again.

   • When you select a column that is part of a multicolumn sort again, it becomes the last column of data in sequence for sorting.

   • When you move a column to the end of the sort sequence, Symphony renumbers the other columns to reflect the new sort sequence.

5. To clear sorting, hover over a column label, select the More menu () and select one of the following options:

   • Reset [name] sorting to clear all sorting options for that column.

   • Reset other sorting to clear sorting options for all columns except the one you have selected.

   • Reset all sorting to clear all sorting options for all columns.

6. Save the dashboard or visual to save the sort order.