How to Display accurate Weekly Scores using Formula Indicator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2024 09:50 AM
Hello Guys,
I have a requirement where I need to store weekly average of Incidents created between 1st Jan 2024 and 31st March. Example - I have 13 k records for this period, so if I take a weekly average for this period I get the score as 1k as 13k/13 weeks. Now I will be using this score as a baseline score and will apply a Formula to display the scores in weekly trend.
Example - (Baseline - Weekly Incident created) + Weekly Automation cases. Final scores to be displayed in the weekly trend. However when attempted, I'm not able to display the data in the weekly trend as it is getting displayed as daily scores. When I use Time Series on the Main Widget like By week Avg or By week SUM+ the scores are not accurate.
Anyone knows a workaround or a fix, pls post here!!
Final Widget:
Manual calculation for Week 12 = 1589 as per below, however the 175812 😐
#Performance analytics #pa #itsm #platform analytics
- Labels:
-
Performance Analytics