Example for YoY and MoM

[ShellyG]

 Hello there,

Can someone please give me examples of formulas for calculating Year over Year and Month over Month comparison, using the above() function? 

I know the theory but I am getting confused with the application of the function so it would be great if someone can give me sample formulas just to catch the way the function works. 

Thanks in advance!

BR,

Shelly 

[Kushal_Chawda]

There are many posts you can find on this forms regarding same but calculations method will be depended on the type of data and requirement. Please provide sample with expected output

[ShellyG]

Hi Kush,

Thank you for your reply!

It is actually pretty simple in my case. I want to create a bar chart, where the dimension has the following expression: 

=IF([~VIEW]='Month', FISCAL_MONTH
,IF([~VIEW]='Week', FISCAL_WEEK
,IF([~VIEW]='Day', Date(DATE_CD,'DD/MMM/YYYY')
)))

And the calculation is the following:

sum(TICKET_VOLUME)

I want to make two bar charts - one showing the YoY and the other one MoM

I have now :

sum(TICKET_VOLUME)-above(sum(TICKET_VOLUME))

It seems to be working but I am not sure what is it showing and I am not sure how to modify the calculation specifically for Month over Month and Year over Year...

Thank you in advance!