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!

 
 

CaptureMoM&YoY.PNG
Domo analyzer view:
CaptureData.PNG

 

Tagged:

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. 

    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • 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!**
  • 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

    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"