Sorting tables

In Amazon QuickSight, you can sort values in a table by fields in the columns headers of the table or with the Sort visual tool. You can sort up to 10 columns in a single table. QuickSight can also use an off-visual sort You can sort columns in an Ascending or a Descending order. The following image shows the Sort visual icon and pop over.

Single column sort options

QuickSight Authors can access single column sort options from the field wells, the column headers, or from the Sort visual menu. Use the procedure below to use set up a single column sort on a table in QuickSight.

1. Open the QuickSight console.

2. Open the analysis that you want to work in and navigate to the table that you want to sort.

3. Choose the header of the column that you want to sort.

4. For Sort by, choose the arrow icon, and then choose the field that you want to sort by.

You can also set up a single column sort in the Sort visual menu. To access the sort visual menu, choose the Sort visual icon in the on-visual menu. In the Sort visual menu, choose the field that you want to sort by, and then choose if you want the sort in an ascending or descending order. By default, new sorts are sorted in an ascending order. When you are finished, choose APPLY.

Tables that use single column sorting are sorted one column at a time. When a user chooses a new column to sort by, the previous sort order is overridden.

To make changes to a single column sort, open the Sort visual menu annd use the dropdown menus to choose a new field or sort order. When you are finished with your changes, choose APPLY.

To reset a table to its original state, open the Sort visual menu and choose RESET.

Multi column sort options

QuickSight authors can access multi column sort options from the Sort visual menu. Use the procedure below to set up a multi column sort for a table.

1. Open the QuickSight console.

2. Open the analysis that you want to work in and navigate to the table that you want to sort.

3. Choose the Sort visual icon to open the Sort visual menu.

   1. Alternatively, choose a header that you want to sort.

   2. For Sort by, choose the arrow icon, and then choose Multiple fields.

4. In the Sort visual menu that opens, choose a field from the Sort by dropdown, and then choose whether you want the field sorted in an ascending or descending order.

5. To add another sort, choose ADD SORT, and repeat the workflow from Step 4. You can add up to 10 sorts to each table.

6. When you are finished, choose APPLY.

Columns are sorted in the order that they are added to the Sort visual menu. To change the order that columns are sorted by, open the Sort visual menu and use the Sort by dropdowns to reorder the sorts. When you are finished, choose APPLY to apply the new sort order to the table.

To reset a table to its original state, open the Sort visual menu and choose RESET.

Off visual sort options

QuickSight authors can configure an off-visual sort to sort the values in a table by a field and aggregation that is a part of the dataset that the table uses but not in one of the table's field wells. One off-field sort can be configured to a single table at a time.

Use the procedure below to configure an off-visual sort.

To add an off-visual sort to a table

1. Open the QuickSight console.

2. Open the analysis that you want to work in and navigate to the table that you want to sort.

3. Choose the header of any column in the table.

4. For Sort by, choose the arrow icon, and then choose Off-visual field.

5. In the Off-visual field pane that appears, open the Sort by dropdown menu and choose the field that you want to sort. The image below shows the Off-visual field pane.

   

6. For Aggregation open the dropdown menu and choose the aggregation that you want to use.

7. For Sort order, choose if you want the sort to be in an ascending or descending order.

8. When you are finished, choose Apply.

After a off-visual sort is applied to a table, the sort is shown in the Sort visual menu. The sort order of a table that contains an off-visual sort depends on the sort configuration of the table when the off-visual sort is added. If an off-visual sort is added to a table that already has a single or multi column sort configured, the off-visual sort overrides all other sorts. If the off-visual sort is applied before single or multi column sorts, you can add and reorder more sorts to the table.