Skip to main content

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


Ask your question here!

Terms & ConditionsCookie settings