Change stack order of stacked bar chart

peter

Hello,

 

I need to be able to change the stacking order of a stacked bar chart. Although I'm able to sort groups, changing the stacking order continues to elude me. The other, somewhat related topics didn't work for me and any help would be much appreciated.

 

Thanks!

 

Peter

Godiepi

Hi @peter

 

can you add a screenshot of how the card looks now and let us now what is the expected sorting order look ?

Godzilla

the easiest way would be to create a sort order beast mode field. Lets say your stacked bars are North , south, east and west. your beast mode would look something like this

 

Case when `region` = 'north' then 1

when `region` = 'south' then 2

when `region` = 'east' then 3

when `region` = 'west' then 4

else 9

end

 

use this beast mode field in your sort order to control the stacked bars. This will allow you to customize and control the sort order.