Hi, I am trying to calculate the MoM change in a metric, I know there is an option of ‘Show Value As’, but that just creates a view on top of the existing numbers and does not perform a calculation on the cells. Is there a way I could do a MoM change using a formula?
Thanks
Hi
Assuming your metric as the Month dimension since you want to perform MoM, you could do the following :
Metric/Metric[SELECT:Month-1] - 1This metric will give you for each month the % Growth vs the Previous Month.
However, if that’s just for reporting, ‘Show Value As’ feature might be preferred especially when you do an aggregation.
Let me know if that helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.