How to add month over month and year over year column to data table
Is it possible to add percentage %change for current vs previous month in a column next to my current table data?
My current data set is set out as shown below.
Any help would be greatly appreciated!
Domo analyzer view:
Comments
-
You might look into using a flex table to visualize this. It does MoM and YoY with colored percent change indicators really nicely. Just change your Date Filter to group by month or year to get the look that you want. Here is a link to the KB article.
**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.1 -
Hi @user023295 ,
Another option is to structure your data a little bit differently to give you more flexibility over the differences / comparison periods. There's an outline previously done here: https://dojo.domo.com/t5/Card-Building/Current-Year-Prior-Year-and-Budget-on-Same-Card/m-p/49142
Once you get it configured and setup you'll have multiple records for each date (Current, Last Month, Last Year). You can then utilize beast modes to calculate the period over period differences. For example YoY %:
(SUM(CASE WHEN `Offset` = 'Current' THEN `amt` ELSE 0 END) - SUM(CASE WHEN `Offset` = 'Last Year' THEN `amt` ELSE 0 END)) / SUM(CASE WHEN `Offset` = 'Last Year' THEN `amt` ELSE 0 END)
MoM %:
(SUM(CASE WHEN `Offset` = 'Current' THEN `amt` ELSE 0 END) - SUM(CASE WHEN `Offset` = 'Last Month' THEN `amt` ELSE 0 END)) / SUM(CASE WHEN `Offset` = 'Last Month' THEN `amt` ELSE 0 END)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
I like @MarkSnodgrass recommendation! Flex Tables don't get enough love.
But also in the consulting work i do, @GrantSmith's recommendation is the data model I use for situations like this.
Built a tutorial video for you.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 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