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
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive