Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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.


D s
D s
snippetBasic

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:percentile(myScores, 25, linear) group:postal_code limit:1

percentile(myScores, 25, linear)

...

  • 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_percentile

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

...

Integer literal value indicating the percentile that you wish to compute. Input value must be between 1 and 100, inclusive.

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

D s
snippetusage

Required?Data TypeExample Value
YesInteger55

...

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.

D s
snippetusage

Required?Data TypeExample Value
YesEnumlinear

D s
snippetExamples

Example - Percentile functions

...