...
Quartiles are computed as follows:
| Quartile | Description |
|---|
| 0 | Minimum value |
| 1 | 25th percentile |
| 2 | Median value |
| 3 | 75th percentile and higher |
...
- Literal values are not supported as inputs.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String (column reference) | precipitationIn |
num_quartile
Name of the column the values of which you want to calculate the quartile. Column must contain Integer or Decimal values.
...
Integer literal value indicating the quartile that you wish to compute. Input value must be between 0 and 3, inclusive.
- Column or function references are not supported.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | Integer | 553 |
interpolation_method
Method of interpolation between each discrete value. The list of support methods is the following:
| Interpolation method | Description |
|---|
linear | Quartiles are calculated between two discrete values in a linear fashion. |
exclusive | Excludes 0 (0th percentile) and 1 (100th percentile) from calculation of quartiles. |
inclusive | Includes 0 (0th percentile) and 1 (100th percentile) from calculation of quartiles. |
lower | Use the lower value when the computed value falls between two discrete values. |
upper | Use the upper value when the computed value falls between two discrete values. |
midpoint | Use the midpoint value when the computed value falls between two discrete values. |
| Required? | Data Type | Example Value |
|---|
| Yes | Enum | linear |
Example - Percentile functions
...
