Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Calculate average from monthly indicator

adinad
Tera Guru

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

1 ACCEPTED SOLUTION

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

5 REPLIES 5

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