reorganize stacks in bar chart

How do i insert a trend line?

Am i able to reorganize the stacks?

Comments

  • Is your trend line already a calculation? If so, I would suggest using a stacked bar + line chart and making the 1st value the trend formula. If you do not have a trend line readily available I would reach out ot DOMO Support.

     

    You can reorganize stacked depending on if your values are independent series. A group+stacked chart works well for this. If your values are not independent you may do a sort, but only if it makes sense in your instance.

  • You can also reorder stacked columns by using beast mode if the field isn't a series (i.e. text field):

     

    Ex:

     

    CASE

    'field'

    WHEN 'value 1' THEN 1

    WHEN 'value 2' THEN 2

    ELSE 3

    END

     

    By doing this you can reorder any text picklist etc.. however you want them to render by sorting the beast mode field ascending or descending.

  • @mrippey, did any of the above replies help answer your question?

This discussion has been closed.