Is there a way to sort values in filter controls?

Question & Answer
, , ,
1

I have Order Hour as both integer value 0-24 and string (1 AM , 2 AM etc), I’m trying to have then appear sorted in the filter control but it is not working:

image
image332×630 13.4 KB

any idea?

2

Hello @Ali_B , hope this message finds you well!!

If you wish to use the field as it is (without creating another calculated field) but correct the sorting so that the values are displayed correctly (0, 1, 2, 3, …, 10, 11, …), you can adjust the custom order in the filter control. Here’s how you can do it:

  1. Go to the analysis panel in QuickSight.
  2. Select the “Order Hour” field in the filter control.
  3. Click on “Sort” and choose “Custom Order”.
  4. Manually add the values in the correct order:
    • 0 (12 AM)
    • 1 (01 AM)
    • 2 (02 AM)
    • …
    • 23 (11 PM)

This will force QuickSight to display the values in the desired order without the need to create a calculated field. If the list is too long and you prefer an automated solution, you will need to create a calculated field to correct the sorting, as mentioned earlier.

Please, let me know if it helps you!

3

Hi,

There is no such option “Sort” on the filter controls.

4

Hi @Ali_B, you can change item order in your dropdown by adding spaces to the left side of some values.

5

That approach works well for hardcoded values, but I’m unsure how to apply it dynamically to data fetched from the database. This seems like a major oversight by the QuickSight development team.

6

Hello @Ali_B

There is not really a way to sort values in a control in QuickSight. To stop it from jumping from 1 to 10 and skipping your single values you need to add a 0. So “1” would be “01” etc…

This can be hard to do dynamically and typically requires either hardcoding values in a calculated field or using custom SQL when ingesting into QuickSight.

I will mark this as a feature request for the QuickSight team.