90th Percentile Calculation

Ask the Community
1

I’m trying to create a metric report that shows the 90th percentile value of a number (2 decimal places) field. I’m not sure how to take the calculated index (my assumption is “count of field”*0.9=index") and then display the value of that indexed record.

3 Likes
2

Hi @CDL825,

At this moment, we don’t support calculating percentile natively. For now, you will need to write SQL model to calculate the percentile.

In the meantime, I will add this request to our backlog for future improvement and let you know when there is an update.

Thanks,

3

Has this been updated with all the AQL work? Native percentiles would be super helpful.

4

Hi Garrett,

Thanks for the question. Unfortunately we haven’t implemented this function yet. I wonder if you’ve been able to get this done in SQL yet?

In BigQuery you can write something like this:

SELECT APPROX_QUANTILES(x, 100)[OFFSET(90)] AS percentile_90
FROM UNNEST([1, 2, 3, 4, 5, 6, 7, 8, 9, 10]) AS x;