Tracking turnaround times Quartiles month on month
We need to report by month the turnaround time (resolved time - created time) for each Quartile.
The top 25% quartile is time for top 25% of the requests when arranged in ascending order of their turnaround time. Similarly top 50% quartile is the median i.e. 50th percentage mark when requests are arranged in ascending order of the time parameter being measured. Top 75% quartile would be the 75th percentage mark.
The chart type would be a bar chart. We should be able to filter on Quartile since it's possible that top 25 quartile would be too low compared to top 75 quartile and wouldn't show in the bar chart. So a user can filter on top 25% quartile and it would show bar chart for each month for that quartile.
Can you please guide me how to accomplish this?
Thanks in advance!