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 |

quartile(myScores, 3, linear) |

**Output:** Computes the value that is at the 3rd quartile across all values in the myScores column.

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.

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
``` |

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` |

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` |