Page tree

Versions Compared

Key

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

...

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

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

...

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
YesInteger553

dec_error_bound

As needed, you can insert an error boundary factor as a parameter into the computation of this approximate value.


  • This value must be a Decimal literal value.
  • This decimal value represents the percentage error factor. By default, this value is 0.5 (0.5%). 

D s
snippetusage

Required?Data TypeExample Value
NoDecimal (literal)0.01

D s
snippetExamples

Example - Percentile functions

...