PERCENTILE

PERCENTILE([Sum(Hours Spent)], 0.3) use this sample

Syntax

PERCENTILE(numerical chart dimension, percentile)

Returns the value at a given percentile of chart numbers. The 50th percentile, that is setting PERCENTILE to 0.5 is equivalent to using MEDIAN with the same data set.

numerical chart dimension: Any numerical chart dimension used for the chart.

percentile: Numerical value from 0 to 1

Use cases

Spent time on tasks

Highlights the value below which 30% of spent hours over features fall using annotation.

Source: Tasks

Time tracking stats for tasks of the building super hero suit

Completed OnTaskHours SpentFeature
03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
12 Feb 2018 09:01 PMAsk Hulk to push in head5Combat Testing
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing

Chart BAR

X: WEEK([Completed On])

Y: SUM([Hours Spent])

Annotation: PERCENTILE([SUM(Hours Spent)], 0.3)

Chart

WEEK(Completed On)SUM(Hours Spent)
1–7 Jan 201819
15–21 Jan 201845
5–11 Feb 201834
12–18 Feb 20185
26 Feb–4 Mar 20185