Waterfall Chart with Variance Analysis
Hi All,
Is it currently possible to build a waterfall chart that refers to three separate beast mode calculations (1 calc for each variance)? I can do this easily in excel but I'm struggling in Domo. What I want to show is (all in $):
July FY21 - Price Variance - Volume Variance - Mix Variance - July FY22
Any help would be appreciated. Thanks in advance!
Answers
-
I should add that I’d like this to be dynamic so that filters can be set up to select individual or multiple business units and months.
0 -
You would need to combine your 3 beast modes into 1 beast mode. Have you tried doing that? For the filters, just add your business units and months into the filters section and turn on quick filters.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hey Mark, that sounds like a good idea. How would I group the 3 beast mode calcs so that all could be shown in the waterfall? Are you able to provide a simple demo so I can get an idea, assuming the calcs are:
calc 1: sum (1+1)
calc 2: sum (2+2)
calc 3: sum (3+3)
Cheers
0 -
Based on your example, if you are adding them all together, you would have a single beast mode that looked like this:
SUM(1+1) + SUM(2+2) + SUM(3+3)
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Unfortunately that wouldn’t work, because I need to show the three variances individually in the waterfall.
0 -
As far as I know, the waterfall chart is not built to show three different variances. You could make a quick filter that would allow users to toggle to each variance. Or, build three different cards. Here's a link to the KB article for the waterfall card if you haven't looked through it already.
https://domohelp.domo.com/hc/en-us/articles/360043429613-Waterfall-Chart
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive