How by month avg+ time series works in Performance Analytics

Community Alums
Not applicable

Hello , 

asmitasahu_0-1713362150516.png

 

We have a dashboard where we are calculating the data based on by Month Avg+ time series but we are not able to understand how this value is getting is calculated.

Please help and let us know if there is any formula to calculate.

4 REPLIES 4

Vedant
Tera Contributor

Hi Asmita,

If you get any update please let me know

AndersBGS
Tera Patron
Tera Patron

Hi @Community Alums ,

 

Please see the product documentation here: Applying time series aggregations (servicenow.com)

AndersBGS_0-1713385606378.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Community Alums
Not applicable

Hello @AndersBGS ,

Thanks for the reply..

Is there any formula to calculate this , like for average it is clear to me but didn't understand how to calculate AVG+ score. how 420 came.
Please guide.

Hi @Community Alums ,

 

I don't think there is a clear formula. If I understand the product documentation properly, then for instance you have a daily indicator summed by month. this could be for 2024 where data captured could be:

Jan.: 10

Feb.: 10

Mar.: 10

Apr.: 4 (until current moment)

 

According to above, I would believe that the widget would show 34 at current moment up to April even though that the data collection defined to summarized by isn't finished yet. 

 

For your widget, try to summarize according to the condition up till current moment, even through April isn't completed.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/