3

I'm using a stacked graph in AWS quicksight and I need to be able to sort by Cost vertically. The only option I see is to sort by Cost horizontally making the dates appear out of order. By default it's sorted A-Z vertically.

How can I get the larger costs at the bottom and all the tiny costs at the top of the graph?

.

mRyan
  • 332
  • 4
  • 18
  • Did you ever find a solution to this? – Alistair Prestidge Sep 07 '21 at 09:34
  • No sorry I never did. Might be worth an AWS support ticket as this ordering makes all the colours look ugly which is important for management xD Although if you order in this way items would have a different colour per month potentially causing other issues. Not sure on the best solution. – mRyan Sep 07 '21 at 10:33

1 Answers1

0

Have you tried adding a number in front of each "Color" (SQL column names) in the order that you need?. That will sort them accordingly.

enter image description here

electric-lady
  • 13
  • 1
  • 5
  • 1
    Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jan 18 '22 at 18:39