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

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    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

     




    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • GrantSmith
    GrantSmith Indiana 🥷

    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!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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 heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"