Month over Month Comparison on mega table/pivot table

i have some queries hoping if anyone could help. In particularly on Month-over-Month comparison.
So i wanted to create a mega table/pivot table that will show companies
Company |January | Febuary | March | April | Previous Month - Previous Previous Month
A |1 |6 |8 |3|(-5)
B |7 |5 |5 |9|(+4)
C |6 |4 |5 |6|(+1)
D |8 |9 |7 |7|(+0)
For now i would like to make it just previous month comparing with previous previous month. Maybe if possible, i would like to be able to choose the months to compare and make it more dynamic.
So for my question is, i am not sure how to write the calculated field for the beast mode to show this previous month-previous previous month calculation and would like to seek your guidance on this.
Best Answer
-
Hi @Jackie96 ,
I got this question earlier today so I guess it was you! Here's a video for everyone else to see how I approached this problem:
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
2
Answers
-
You can write two beast modes and then join the data back on itself to get previous month and 2 months ago.
You'll need to format you data in a long format instead of a wide format like you have in your example.
Something like:
Company | Month Date | Value A | 2023-01-31 | 1 B | 2023-01-31 | 7
Last Month:
LAST_DAY(`Month Date` - INTERVAL 1 MONTH)
2 Months Ago
LAST_DAY(`Month Date` - INTERVAL 2 MONTH)
After you join it based on Last Month -> Month and 2 Months Ago -> Month you can then calculate the different between the two values and then pivot your data back to your desired wide format.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi @Jackie96 ,
I got this question earlier today so I guess it was you! Here's a video for everyone else to see how I approached this problem:
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
2
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 179 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive