🧮 Calculation Builder: Percentile

Percentile calculations are coming to the Calculation Builder!

Create continuous and discrete percentiles directly in the GUI. Choose from common percentiles (P10, P25, P50, P75, P90, P95, P99) or enter a custom value.

Two types are supported:

• Continuous percentile - interpolates between adjacent values
• Discrete percentile - returns the closest actual value from the data

Example use cases

• P10 customer lifetime value - identify your lowest-value segment to investigate churn risk
• P25 vs P75 salary range - show the interquartile range for compensation benchmarking
• P75 order value - understand where the bulk of revenue sits for pricing decisions
• P90 response time - track performance while filtering out outliers
• P95 session duration - identify power users by top 5% engagement time
• P99 query execution time - catch extreme outliers for capacity planning

Stay tuned - more Calculation Builder capabilities are on the way!