Hello,
I've seen a few posts on the community but haven't found a solution for a new requirement that's come my way. We are looking to calculate a new monthly performance analytic metric, which will show the "median" of how many days it takes to resolve incidents (by Month).
So for example in the Month of September if you have 7 incidents, each incident is resolved within a certain amount of days. See below for array of the 7 incidents. Each number in the array represents the numbers of days it took to resolve each incident:
Scenario #1 (odd number of incidents):
[2,3,3, 5, 8, 8, 9]
In this case the median value should be "5" for September because its directly in the middle of an odd amount of incident tickets.
Scenario #2 (even number of incidents):
[2,3,3, 5, 8, 8, 9, 10]
In this case the media value has to average the two middle numbers since there is an even number of incidents. (8 + 5) / 2 = 6.5
The end goal would be to see a performance analytic line chart , which is broken down monthly and shows the median value (in days) for each month as time goes on. I have doubts this is possible, but hoping someone on the community has a solution out there that doesn't require heavy customization!
Another thing to mention is we want to use the "Actual Elapsed time" when figuring out the "days" which I referred to in the requirement:
