Hi team! Is there a way to sort by aggregated values in bar chart? The result wanted is US as the top bar then US->CA, US->CA->MX, CA->US and US->JP I enabled descending in values, but still the output is not what I wanted.
https://us-east-1.quicksight.aws.amazon.com/sn/analyses/66f1a62d-2cbc-4324-9849-e38fb4e937e9/sheets/8c8c35c0-fc78-44cd-9e12-3fe4d0e3a50f
It looks like you’re also grouping by date.
If you take off the date, does it work?
Thanks Max, but I need to add date a segment. Removing date doesn’t the change the alphabetic order in the chart.
@Jing - When I tried to replicate the issue at my end, I could not as I was able to get the data exactly how I wanted i.e. sorted by value. Can you please share the sample dataset so that I can try to replicate using that? Please see the snapshot below to see how I am getting the graph.