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 next

...

Quartiles are computed as follows:

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

D s lang vs sql

D s
snippetBasic

...

  • 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

...

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

...