Stacked bar chart that compares period over period

jamfmike
jamfmike Member
in Charting

Would love to see a stacked bar chart that compares period over period:

 

e.g. Total Sales, broken out by territory (East/West/Central)., but compared by Q1, Q2, etc.

 

Helps me to see comparatives by time period.

Best Answer

  • ST_Superman
    ST_Superman Domo Employee
    Answer ✓

    The beast modes were in my first picture 

     

    it’s just:

     

    QUARTER(‘date_field’)

     

    and

     

    YEAR(‘date_field’)

     

Answers

  • ST_Superman
    ST_Superman Domo Employee

    You can accomplish this using the new category 2 field.

    1.png

     

     

    Let me know if this is what you were looking for.  Or please provide some kind of sketch or screenshot if you had something else in mind.

  • jamfmike
    jamfmike Member

    Hmmm...i was hoping they would be right next to each other (like Q1 2017 vs Q1 2018, etc.)...Domo Support told me it wasn't available yet.

     

    But that could work for now.

  • ST_Superman
    ST_Superman Domo Employee

    Just swap quarter and year then:2.png

     

  • ST_Superman
    ST_Superman Domo Employee

    oops, I also switched that last chart to a grouped bar and not a stacked bar

  • jamfmike
    jamfmike Member

    This could definitely work. Let me try it...

  • [Deleted User]
    [Deleted User] Member

    I moved this out of ideas exchange to the Card Building board since it may be possible in current functionality and you will be able to give likes to the replies!

  • jamfmike
    jamfmike Member

    Ok, I tried it. I think I need to get a beast mode calculation that gives me the dates to compare - like the "quarter, or invoice year." in your chart.

     

    Right now, all I have is 36,000 opportunities, but they are showing the individual date of each closed opportunity (like 1/1/19, etc.). 

     

    Or is there another way you got the category?

     

     

  • ST_Superman
    ST_Superman Domo Employee
    Answer ✓

    The beast modes were in my first picture 

     

    it’s just:

     

    QUARTER(‘date_field’)

     

    and

     

    YEAR(‘date_field’)

     

  • jamfmike
    jamfmike Member

    Whoa. TIL!

     

    Had no idea you could do that. A newbie just learning my way around. Will try this today.

This discussion has been closed.

Categories