Hello everyone,
I've created a PA report to show the percentage of incidents from the last 3 months that are resolved within the SLA, with the breakdown as priority. In my report every value is showing as expected, except for one month out of 3 months - for moderate priority- moderate priority, where the percentage exceeds 100%.
What I discovered
1. I'm using by month AVG as the time series in the widget.
2. This results in the calculation being done as total records divided by days, which leads to the numerator being higher than the denominator.
Configuration done
1. Created 2 indicator source one to get the total incident from last 3 months, another one to get the total not breached incident.
2. for both indicator source, I created an indicator. For these indicators I created a formula indicator with the below formula. (total_not_breached_incident/total_incident)*100.
3. Created a breakdown type widget with this formula indicator and visualization as columns and total. In the time series I used by month avg. (There is by month sum, but I can't map it in this widget).
Analysis
1. In the analytics hub, for each indicator I checked the scores for each day in July month.
- Total incidents: 42 records over 18 days → 42/18 = 2.33
- Not breached: 41 records over 17 days → 41/17 = 2.41
- Using "by month AVG" -> 2.41/2.33*100 = 103%
Is there a better way to configure or calculate this so that the percentage does not exceed 100%? Or any recommendations on how to handle this.
Thanks in advance for your help!
Thanks
Jawahar K
