Median and 90th Percentile by Grouping

Joshua Baron shared this question 2 months ago
Answered

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?


Thanks!

Comments (8)

photo
1

Hi Joshua,

Thanks for reaching out to support with your issue.

This is an ideal inquiry for our consulting team, as such I've forwarded this request to your account manager, who will be contacting you shortly to arrange the resources to help resolve this. Please let me know how it goes!

Thanks,

Eric

photo
1

Hi Joshua,

Just wanted to check in to make sure you got the assistance you needed with this issue?

Thanks,

Eric

photo
1

Hi Joshua,

I'm going to go ahead and mark this as Answered at this point. Feel welcome to reply here if you have any further related questions.

Thanks,

Eric

photo
1

Hey Eric, sorry for the delay. The short answer is not yet. I have mentioned it to our consulting team and we briefly touched on it but he is on vacation. We hope to get back to it in the next week or two. My fear is that there is no way to do what I want to do since they both need to be done in the pre-processing step - i.e. at the query - but because you have to use the group by in the query, you eliminate the ability to do ad hoc analysis since the group by is set in the query.

photo
1

Thanks for the reply Joshua.

I'll leave this ticket open in the meantime.

Thanks,

Eric

photo
1

Hi Joshua,

Just wanted to check in to see if you were able to talk to the consulting team about this yet?

Thanks,

Eric

photo
1

Hey Eric,


Yes, I spoke with them and I was able to get around the limitation by using a freehand sql report. It's not perfect, but will suffice for now - you can close this. Thanks for the followup!


Josh

photo
1

Thanks for the update Joshua, glad to hear you were able to find a workaround for this. I'll mark this as Answered.

Thanks,

Eric