90th Percentile Calculation

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.

2 Likes

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,