| Excerpt |
|---|
Computes a specified quartile across all row values in a column or group. Input column can be of Integer or Decimal. |
- If a row contains a missing or null value, it is not factored into the calculation. If the entire column contains no values, the function returns a null value.
- When used in a
pivot transform, the function is computed for each instance of the value specified in the group parameter. See Pivot Transform.
Quartiles are computed as follows:
| Quartile | Description |
|---|
| 0 | Minimum value |
| 1 | 25th percentile |
| 2 | Median value |
| 3 | 75th percentile and higher |
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | pivot value:quartile(myScores, 25, linear) group:postal_code limit:1 |
|---|
|
quartile(myScores, 3, linear) |
Output: Computes the value that is at the 3rd quartile across all values in the myScores column.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | pivot value:quartile(function_col_ref) [group:group_col_ref] [limit:limit_count] |
|---|
|
quartile(function_col_ref,num_quartile,interpolation_method) [group:group_col_ref] [limit:limit_count] |
| Argument | Required? | Data Type | Description |
|---|
| function_col_ref | Y | string | Name of column to which to apply the function |
| num_quartile | Y | integer | Integer value (0-3) of the quartile to compute |
| interpolation_method | Y | enum | Method by which to interpolate values between two row values. See below. |
For more information on the group and limit parameters, see Pivot Transform.
function_col_ref
Name of the column the values of which you want to calculate the quartile. Column must contain Integer or Decimal values.
- 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
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 | 3 |
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
| Include Page |
|---|
| EXAMPLE - Percentile Functions |
|---|
| EXAMPLE - Percentile Functions |
|---|
|
