Beastmode YoY Variance Calc
Hi All,
I am working on a beastmode that I thought would be relatively straight forward, but is giving me some issues. I am trying to do a YoY variance calc starting in 2022.
The problem I am running into is that the 2021 numbers are not being subtracted out of the 2022 numbers. When I look at the previous year info, it's turning those numbers negative, but it can't tell to remove it from the 2022 numbers.
What I am trying to do is calculate the YoY difference by month. I know they're variance bar charts that do this, but I also need to include a target number and those charts only allow for one number from what I can tell. Below is a copy of the formula I am currently using:
IFNULL((CASE when `Order Type` = 'Parts' and `Service Level` = 'On-Demand' and `Original Mold Build Date` > '1/1/2021' and YEAR(`Actual Ship Date`) = 2022 then `Revenue Amount (Global)` end), 0)
-
IFNULL((CASE when `Order Type` = 'Parts' and `Service Level` = 'On-Demand' and `Original Mold Build Date` > '1/1/2021' and YEAR(`Actual Ship Date`) = 2021 then `Revenue Amount (Global)` end), 0)
Any help would be much appreciated!
Answers
-
When comparing by months between 2022 and 2021, there is only one month in 2022 that has occurred, so the rest of the months would be zero causing your math to result in a negative value.
You might consider looking at this post when building period over period analysis.
Hope this helps.
**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 -
I just came across this KB article and this might be useful to you as well.
**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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 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
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive