How to add month over month and year over year column to data table

user023295

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:

 

MarkSnodgrass

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

 

GrantSmith

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)

 

jaeW_at_Onyx

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.

https://www.youtube.com/watch?v=CDKNOmKClms