Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0810

D toc

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:

QuartileDescription
0Minimum value
125th percentile
2Median value
375th percentile and higher

D s lang vs sql

D s
snippetBasic

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot 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 s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot 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]


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.

D s lang notes

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.

D s
snippetusage

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.

  • Column or function references are not supported.
  • Multiple columns and wildcards are not supported.

D s
snippetusage

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.


D s
snippetusage

Required?Data TypeExample Value
YesEnumlinear

D s
snippetExamples

Example - Percentile functions

Include Page
EXAMPLE - Percentile Functions
EXAMPLE - Percentile Functions

D s also
labelaggregate