Median and 90th Percentile by Grouping

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

Hi Joshua,

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

Thanks,

Eric

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

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.

Thanks for the reply Joshua.

I'll leave this ticket open in the meantime.

Thanks,

Eric

Hi Joshua,

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

Thanks,

Eric

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

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