Skip to main content

Hi Team - I’d like to seek your help on how to do the formula for specific months?

Previously I’m using Moving Average, however I realized that it’s better to lock the average to specific months. 

For context this is my current formula → MovingAverage(Actuals,3) - so that it will get the average of the latest 3mos. What I want now is to just get the average of the months of July, Aug, Sep.

In addition, the metric in which I will be using the formula allows manual input override. Once I update the formula of the average, will it override the manual input?

Thank you in advance for your help!

Hi @Suzzy,

To get the average of a specific MetricA for the months of July 24/August 24/September 24, you could do in a MetricB :

MetricAASELECT:Month.Quarter = Quarter.”Q3 24”] / 3

However, if you override a month in MetricB it won’t be included in the average.

In that case, you might want to use in your metricB:

(PREVIOUS(Month,1)+PREVIOUS(Month,2)+PREVIOUS(Month,3))/3

That way the override performed in this metric will be included in your average.

Hope this gives you some axis to solve your problem.

Hi, 

I’ve started to work on this one but Clement went faster 👍 
Still sharing in case it can help.

Indeed, if you want to use manual overrides, you have to use PREVIOUS.

On my screenshot you can see the formula I’ve used.

I’ve considered that you needed your result on the Month of September just like a MOVINGAVERAGE(block, 3) would return.

 

 

Hope this helps.

Thank you both for your answers! Really appreciate it!

Reply


Ask your question here!

Terms & ConditionsCookie settings