PERCENTILE_CONT
Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

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.

Did this answer your question?