Forum Discussion
gemcityzach
Helper IV
Helper IVUsing percentiles or other aggregated summary statistics to decide on thresholds for SLAs
Hey folks, I need to establish some service level agreements measured in days for processes that currently do not have them. For sake of this example, widgets are created a few times a week with a 's...
Sahir_Maharaj
Super User
Super UserHello gemcityzach,
I would recommend using a histogram or density plot to show the aging data with clear percentile markers (50th, 75th, 90th) and average. This will make it evident where most of the processing times fall and highlight the tail end of longer durations.
gemcityzachHelper IV
Helper IVHow would you recommend I do that? I have hundreds of start / end dates, some with blank end dates and hundreds of aging observations. There isn't a factor like a "name" or "type" that I can aggregate on.
My data is is like this:
| ID | Start Date | Close Date | Aging | |
| 1234 | 12/12/2024 | 12/24/2024 | 12 | |
| 51355 | 10/01/2024 | 10/05/2024 | 4 | |
| 12234 | 09/01/2024 |