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:
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.
https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Flex_Table**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)
(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!**0
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"1
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 182 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 77 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive