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

percentile(myScores, 25, linear)

Output: Computes the value that is at the 25th percentile across all values in the myScores column.

percentile(function_col_ref,num_percentile,interpolation_method) [group:group_col_ref] [limit:limit_count]


ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function
num_percentileYintegerInteger value between 1-100 of the percentile 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 percentile. Column must contain Integer or Decimal values.

Required?Data TypeExample Value
YesString (column reference)precipitationIn

num_percentile

Name of the column the values of which you want to calculate the percentile. Column must contain Integer or Decimal values.

Required?Data TypeExample Value
YesInteger55

interpolation_method

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

Interpolation methodDescription
linearPercentiles are calculated between two discrete values in a linear fashion.
exclusiveExcludes 0 and 1 from calculation of percentiles.
inclusiveIncludes 0 and 1 from calculation of percentiles.
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