Hi Team,
I'm building a Performance Analytics dashboard to track case resolution times.
I have case data with two fields — case creation date and case resolution date. I need to calculate the difference between these two (resolution time) and then find the P50 and P90 percentiles of that resolution time, so I can display them on my dashboard.
The problem I'm running into is that the standard reporting/aggregation options I have access to (Count, Sum, Avg, Min, Max) don't seem to support percentile calculations like P50/P90.
Could you please help me understand:
How can I achieve this calculation within our instance?
What would be the best way to set this up so it reflects accurately on my dashboard?
