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.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 103 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 41 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive