Calculating Beast Mode YoY and MoM Type Calculation

user02485 · December 2017

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:

Date	Visits
Jan-15	206
Feb-15	609
Mar-15	632
Apr-15	825
May-15	518
Jun-15	822
Jul-15	345
Aug-15	179
Sep-15	869
Oct-15	119
Nov-15	257
Dec-15	583
Jan-16	520
Feb-16	852
Mar-16	281
Apr-16	584
May-16	961
Jun-16	894
Jul-16	307
Aug-16	849
Sep-16	911
Oct-16	563
Nov-16	996
Dec-16	157
Jan-17	365
Feb-17	701
Mar-17	412
Apr-17	535
May-17	340
Jun-17	932
Jul-17	249
Aug-17	910
Sep-17	175
Oct-17	284
Nov-17	457
Dec-17	474

Thanks for your help!

Chronos · December 2017

Is anyone able to help out with this request?

Jaketh13 · December 2017

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

user02485 · December 2017

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!!

Calculating Beast Mode YoY and MoM Type Calculation

Comments

Categories