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.
**Make sure toany 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.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有