Sorting by VALUE and by GROUP/COLOR in a Vertical Bar Chart

Question & Answer
,
1

Hi Friends,
I would like to sort the cost$ as well as the Group which is a week/date range calculated field in Vertical Bar Chart.

(Please refer screenshot attached)
I have already sorted the line_item_unblended_cost in the value section such that the bar charts are shown with highest cost first.

however now I would like to further sort value of cal_week which is a week range in ascending order… i.e. the latest week bar should appear to right.

i.e. the current week 2024-06-23 - 2024-06-29 should appear as the second bar for each product code.

Screenshot 2024-07-01 at 3.20.12 PM
Screenshot 2024-07-01 at 3.20.12 PM2012×906 101 KB

would that be possible?

Thank you
Amit

1 Like
2

Hi @Amit_Raj ,

When you set the sort order to Ascending for the cal_Week field under group/colour field well, what do you see?

Also please note, since the cal_week is string, it will sort considering string values instead of date values.

Thanks,
Prantika

3

Hi @prantika_sinha
Thank you for replying.
I am simply not able to choose Ascending order, by default it is set to Descending.

is this because I have sorted the cost i.e. line_item_unblended_cost as Descending?
can we have two sortings inside the same graph?

cost sorted- working…
but week sorting- not allowing.

Thank you

1 Like
4

In Amazon QuickSight, you can sort multiple columns, but there are some considerations to keep in mind. Here’s how you can sort multiple columns effectively:

Steps to Sort Multiple Columns

  1. Primary and Secondary Sorting:
  • In Amazon QuickSight, you can set a primary sort on one field and a secondary sort on another field. This is useful when you want to sort by one column first and then by another column within that sorted order.
  1. Using Field Wells:
  • When you drag fields into the Field Wells, you can specify the sorting order for each field. The order in which you apply sorting will determine the hierarchy of the sorting.
2 Likes
5

Hi @Amit_Raj, 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!

6

Thank you everyone. yes able to fix it.

1 Like