1 of 1 people found this helpful
Hello Nick Sherriff,
and with this post Quantile
Rather than starting from scratch, I suggest building on the suggestions and methods used here.
I hope this helps
In addition to what Patrick wrote, there are a couple of other potential solutions:
- WINDOW_PERCENTILE() and/or RANK_PERCENTILE table calculations.
- LOD expressions and the PERCENTILE() aggregation.