Can we sort on more than one column say on a string and date column in QuickSight?

Question & Answer
, ,
1

Can we sort on more than one column say on a string and date column in QuickSight?

2

Hi @Samrat, yes, you can sort on more than one column, including a combination of string and date columns.

Here’s how you can do it:

  1. Open Analysis: Open the analysis in QuickSight where you want to sort the data.
  2. Select the Visual: Click on the visual you want to sort.
  3. Sort By Multiple Fields:
  • First Sort Criteria: Click on the field (string or date) you want to use as your first sort criterion. In the field well, click the sort icon (a small down arrow or an options menu) next to the field name. Choose either ascending or descending order.
  • Second Sort Criteria: Click on the next field you want to sort by. Repeat the process by clicking the sort icon next to this second field. QuickSight will sort by this field within the context of the first sort criterion.
  1. Adjust Sort Order: If needed, you can adjust the order of your sorting criteria by clicking on the sort options again and ensuring they are sorted in the desired sequence.
  2. Verify Sorting: Check your visual to make sure it reflects the sorting order you intended. The data should now be sorted first by the primary column (e.g., date), and within each value of the primary column, it will be sorted by the secondary column (e.g., string).

Example

If you want to sort a table by Order Date (date column) and then by Customer Name (string column):

  1. Click on Order Date column, and select sort ascending.
  2. Click on Customer Name column, and select sort ascending.

The table will first be sorted by Order Date, and for each date, it will be sorted by Customer Name.

Notes

  • You can add more than two sorting levels by repeating the sorting steps for additional columns.
  • The order in which you apply the sorting criteria matters. The first column you sort by will be the primary sort, the second will be the secondary sort, and so on.

By following these steps, you can effectively sort your QuickSight visualizations by multiple columns, allowing for a more granular and organized display of your data.

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

3

Hi Xclipse. Thank you for the response.