Page tree

Versions Compared


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


  • 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

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

percentile(myScores, 25, linear)


Required?Data TypeExample Value
YesString (column reference)precipitationIn


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

Required?Data TypeExample Value