Change stack order of stacked bar chart

peter
peter Member
in Archive

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

Comments

  • Godiepi
    Godiepi Coach

    Hi @peter

     

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

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Godzilla
    Godzilla Contributor

    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. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.

Categories