Calculating Beast Mode YoY and MoM Type Calculation

Hi all,

I want to calculate a YoY or MoM calculation for each month in which data is available for such comparisons.  I would then like to possibly create a chart showing the trend of my YoY and MoM % changes.  

 

The Example data looks like this and I would like to calculate a column of YoY and MoM and trend it:

 

DateVisits
Jan-15206
Feb-15609
Mar-15632
Apr-15825
May-15518
Jun-15822
Jul-15345
Aug-15179
Sep-15869
Oct-15119
Nov-15257
Dec-15583
Jan-16520
Feb-16852
Mar-16281
Apr-16584
May-16961
Jun-16894
Jul-16307
Aug-16849
Sep-16911
Oct-16563
Nov-16996
Dec-16157
Jan-17365
Feb-17701
Mar-17412
Apr-17535
May-17340
Jun-17932
Jul-17249
Aug-17910
Sep-17175
Oct-17284
Nov-17457
Dec-17474

  

Thanks for your help!

 

 

 

Tagged:

Comments

  • Is anyone able to help out with this request?

  • Jaketh13
    Jaketh13 Contributor

    Depending on how all of your raw data looks and how you want the chart to look, the simplest solution might be to use the PoP charts offered. If that doesn't work for you, then you will need to create period totals for any agregations that you want to compare in a separate column. For example, if you wanted to compare Jan-15 to Feb-15, you can just create a beast mode to subtract one from the other, but if you wanted to compare all the values for 2015 to the values for 2016, you would need to create a column `Year_Totals` where you would have the total for that year repeated. 

     

    Here's an article that's super helpful for creating these kinds of DataFlows: http://knowledge.domo.com?cid=periodoverperiod


    Thanks,
    Jake
    **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"
  • Thank you guys, I will take a look.  You're right I noticed the YoY (PoP) options in Analyzer. I was I guess looking for the more difficult way, I will explore the DataFlow option to see how dynamic it can be.  

     

    Thanks!!

This discussion has been closed.