Type: Aggregator
Function: PERCENTILE
Syntax: PERCENTILE(number_field, percentile)
Description: Returns the value at a given percentile for a number field. The percentile is discrete, which means that the value returned is one of the values returned by the number_field. It is not extrapolated like the result provided by PERCENTILE_CONT (continuous percentile)
Sample usage:
PERCENTILE(lines_changed, 0.90)returns the 90th percentile for the number of lines of code changed.PERCENTILE((closed_at - created_at)/HOUR(), 0.75)returns the 75th percentile for the cycle time, in hours.PERCENTILE(additions, 0.50)returns the 50th percentile (median) for the number of lines of code addded. This is equivalent toMEDIAN(additions).