PERCENTILE
PERCENTILE([Price] + ([Price] * [Tax Rate])/100, 0.3)Syntax
PERCENTILE(numerical expression, percentile)
Returns the value at a given percentile of a dataset. The 50th percentile, that is setting PERCENTILE to 0.5 is equivalent to using MEDIAN with the same data set.
numerical expression: Basic arithmetic calculation created using the math operators +, -, *, /, numerical data fields and constants.
percentile: Numerical value from 0 to 1
Use cases
Spent time on tasks
Compare 30th percentile spent hours for completed tasks per week.
Source: Tasks
Time tracking stats for tasks of the building super hero suit
| Completed On | Task | Hours Spent | Feature |
|---|---|---|---|
| 03 Jan 2018 10:13 AM | Create a steel helmet to protect head | 19 | Protective Suit |
| 20 Jan 2018 04:08 PM | Create a chest protection from steel | 45 | Protective Suit |
| 05 Feb 2018 11:34 AM | Ask agency to create fancy identity for new super hero | 30 | Design |
| 09 Feb 2018 02:11 PM | Install super hero logo on body and helmet | 2 | Protective Suit |
| 09 Feb 2018 02:11 PM | Put on gloves with nice color | 2 | Protective Suit |
| 12 Feb 2018 09:01 PM | Ask Hulk to push in head | 5 | Combat Testing |
| 01 Mar 2018 06:45 PM | Ask Hulk to push in chest | 5 | Combat Testing |
Chart BAR
X: MONTH([Completed On])
Y: PERCENTILE([Hours Spent], 0.3)
| MONTH(Completed On) | PERCENTILE(Hours Spent, 0.3) |
|---|---|
| January, 2018 | 26.8 |
| February, 2018 | 2 |
| March, 2018 | 5 |