Solved

How to Calculate MoM Change Using Formula

  • 5 June 2024
  • 1 reply
  • 46 views

Badge

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

icon

Best answer by CDALMAY 6 June 2024, 15:23

View original

1 reply

Userlevel 3
Badge +6

Hi @Moosa Malick,

Assuming your metric as the Month dimension since you want to perform MoM, you could do the following :

Metric/Metric[SELECT:Month-1] - 1

This 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

Reply