Median and 90th Percentile by Grouping
I need to calculate the average, median, and 90th percentile response times for our fire department. As you can see from the attachment, I need to group first by station and then by shift. The average works great and I have verified the times displayed vs. the source data. For the median, it appears to be taking the median of the entire data set and not by station/shift. For 90th percentile, I have no good idea of how to handle. I saw an earlier post about using the Decile advanced function and saving the report off as a view and then using that value as a filter. I'm not really sure how that would help me here - is there a better way to calculate that?