Calculate average from monthly indicator

adinad · ‎09-05-2017

Hi,

I have some monthly indicators (like Incident Reliability, so a formula indicator) and I want to get the average from all the monthly indicators in a score.

Is it possible to write in the formula indicator something like = SUM (indicatorA) / COUNT (indicatorA) ?

Or do you have any idea how to get this kind of score?

Thanks,

Adina

adinad · ‎09-14-2017

Hi Gaurav,

It is possible to get the average - define a widget of type score, select the indicator and in Time Series select "By year AVG+".

In case the indicator is a formula, first select the checkbox "Apply time series to result", in tab Other of the indicator.

Adina

View solution in original post

gauravchoudhury · ‎09-05-2017

Hi Adina,

Refer to this "Create a formula indicator".

Please Note: You must have Performance Analytics Premium to create new indicators.

adinad · ‎09-05-2017

Hi Gaurav,

I know how to create a formula indicator.

I want to get an average from monthly indicators. So I have some monthly indicators for a year - Indicator_Month1, Indicator_Month2, Indicator_Month3, and I want to get the yearly average = (Indicator_Month1 + Indicator_Month2 + Indicator_Month3) / 3 .

I was thinking to use something like SUM and COUNT in formula indicator.

Adina

adinad · ‎09-08-2017

Any idea?

Thanks,

Adina

gauravchoudhury · ‎09-08-2017

Hi Adina,

I am not quite sure if this is possible.