How to Display accurate Weekly Scores using Formula Indicator

Sathish Kumar S
Tera Expert

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:

SathishKumarS_0-1718123920267.png

 

SathishKumarS_1-1718123972008.png

 

SathishKumarS_2-1718124175397.png

 

Manual calculation for Week 12 = 1589 as per below, however the 175812 😐

 

SathishKumarS_3-1718124496995.png

 

#Performance analytics #pa #itsm #platform analytics

0 REPLIES 0