Type: Aggregator
Function: PERCENTILE_CONT
Syntax: PERCENTILE_CONT(number_field, percentile)
Description: Returns the value at a given percentile for a number field. The calculation is continuous, which means that the returned value is interpolated from discrete values. For a discrete percentile, see PERCENTILE
.
Sample usage:
PERCENTILE_CONT(lines_changed, 0.90)
returns the 90th percentile for the number of lines of code changed.PERCENTILE_CONT((closed_at - created_at)/HOUR(), 0.75)
returns the 75th percentile for the cycle time, in hours.