How do I add a stacked bar chart that shows month-to-date compared to last year?

Pierce13
Pierce13 Member
in Charting

I have a stacked bar chart that has each category broken down into available inventory, unavailable inventory, and on floor inventory. Basically I would like this chart to keep its format, but I would like to compare it with last year.

image.png

The period-over-period charts that I have messed with have dramatically changed this format and I would like to keep the chart how it looks if possible. Thanks!

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @Pierce13

    Typically when doing period over period charts I'll use a custom offset dataset along with bar + line type graphs to display prior values. I've done a write up previously on this methodology here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

    In a line + bar graph you can define the number of fields to plot as lines under the general settings and you need to list have them first in your list. You can also create some beast modes to calculate the current year, last year and difference values with something like:

    Last Year Unavailable:

    SUM(CASE WHEN `Period Type` = 'Last Year' and `Inventory` = 'Unavailable' THEN `quantity` END)

    Just then drag the different values depending on how you want it displayed on your line + bar graph.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @Pierce13

    Typically when doing period over period charts I'll use a custom offset dataset along with bar + line type graphs to display prior values. I've done a write up previously on this methodology here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

    In a line + bar graph you can define the number of fields to plot as lines under the general settings and you need to list have them first in your list. You can also create some beast modes to calculate the current year, last year and difference values with something like:

    Last Year Unavailable:

    SUM(CASE WHEN `Period Type` = 'Last Year' and `Inventory` = 'Unavailable' THEN `quantity` END)

    Just then drag the different values depending on how you want it displayed on your line + bar graph.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Pierce13
    Pierce13 Member

    Awesome thank you. This gives me some things to think about.

Categories