How do I add a stacked bar chart that shows month-to-date compared to last year?
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.
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
-
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!**0
Answers
-
Awesome thank you. This gives me some things to think about.
0
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有