PERCENTILE_CONT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Computes a continuous percentile, interpolating between adjacent input values if needed.

• <fraction>: A double precision value between 0 and 1 specifying the percentile to compute.
• <sort_expression>: An expression of double precision or interval type.

Returns the same type as the sort expression. Returns NULL if the fraction is NULL.

• This is an ordered-set aggregate function.
• NULL values in the sorted input are ignored.
• Interpolates between adjacent values when the exact percentile falls between two data points.
• Use PERCENTILE_DISC for discrete percentiles without interpolation.

Find the median (50th percentile).

Find the 25th and 75th percentiles.

Calculate percentiles for each group.

• PERCENTILE_DISC
• MODE
• Aggregate Functions