Percentage change in bar chart?
We have various charts comparing the current month to the same month in the prior year and it would be nice to have a percentage over the chart indicating what the difference is between the two periods. I have searched several forums and played around in ETL and beast mode, but something that seems straightforward does not seem achievable in DOMO. I know it would be easy to create a beast mode formula but it doesn't seem like there is an obvious place to drop the calculated field in the chart. Any suggestions on how to achieve this?
Best Answers
-
Domo has some out-of-the-box period-over-period charts that might be useful to you:
However, I don't think they work with the stacked series like you're doing in your chart.
One way to get the YOY variance in the chart would be to drop the beast mode into a tooltip field, then you could display it the data label.
0 -
When I'm doing period over period type analysis I'll restructure the data so that I can reference each period type for each day. Then use Beast Modes to calculate the differences and the % changes. I've done a write up on this in the past:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Domo has some out-of-the-box period-over-period charts that might be useful to you:
However, I don't think they work with the stacked series like you're doing in your chart.
One way to get the YOY variance in the chart would be to drop the beast mode into a tooltip field, then you could display it the data label.
0 -
When I'm doing period over period type analysis I'll restructure the data so that I can reference each period type for each day. Then use Beast Modes to calculate the differences and the % changes. I've done a write up on this in the past:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thank you for the direct reference - I can't believe I didn't come across this article in my searches -_-
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive