Computes a specified quartile across all row values in a column or group. Input column can be of Integer or Decimal.

Quartiles are computed as follows:

QuartileDescription
0Minimum value
125th percentile
2Median value
375th 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]


ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function
num_quartileYintegerInteger value (0-3) of the quartile to compute
interpolation_methodYenumMethod 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.

Required?Data TypeExample Value
YesString (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.

Required?Data TypeExample Value
YesInteger3

interpolation_method

Method of interpolation between each discrete value. The list of support methods is the following:

Interpolation methodDescription
linearQuartiles are calculated between two discrete values in a linear fashion.
exclusiveExcludes 0 (0th percentile) and 1 (100th percentile) from calculation of quartiles.
inclusiveIncludes 0 (0th percentile) and 1 (100th percentile) from calculation of quartiles.
lowerUse the lower value when the computed value falls between two discrete values.
upperUse the upper value when the computed value falls between two discrete values.
midpointUse the midpoint value when the computed value falls between two discrete values.


Required?Data TypeExample Value
YesEnumlinear

Example - Percentile functions