How by month avg+ time series works in Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 06:56 AM
Hello ,
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 07:01 AM
Hi Asmita,
If you get any update please let me know
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 01:27 PM
Hi @Community Alums ,
Please see the product documentation here: Applying time series aggregations (servicenow.com)
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2024 02:48 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2024 05:12 AM
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/