Keypup

<b>Syntax</b>: <code>PERCENTILE(number_field, percentile)</code>

<b>Description</b>: 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 <code>number_field</code>. It is not extrapolated like the result provided by <code>PERCENTILE_CONT</code> (continuous percentile)

<code>PERCENTILE(lines_changed, 0.90)</code> returns the 90th percentile for the number of lines of code changed.

<code>PERCENTILE((closed_at - created_at)/HOUR(), 0.75)</code> returns the 75th percentile for the cycle time, in hours.

<code>PERCENTILE(additions, 0.50)</code> returns the 50th percentile (median) for the number of lines of code addded. This is equivalent to <code>MEDIAN(additions)</code>.

- <code>PERCENTILE(lines_changed, 0.90)</code> returns the 90th percentile for the number of lines of code changed.
- <code>PERCENTILE((closed_at - created_at)/HOUR(), 0.75)</code> returns the 75th percentile for the cycle time, in hours.
- <code>PERCENTILE(additions, 0.50)</code> returns the 50th percentile (median) for the number of lines of code addded. This is equivalent to <code>MEDIAN(additions)</code>.

PERCENTILE

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you