percentile

percentile — aggregate function to return value closest to the specified percentile rank

SYNOPSIS

percentile (T column, double pct)

DESCRIPTION

This function returns the value of the specified column with percentile rank equal to the specified pct value. If there is no value at exactly pct percentile, then the value with the greatest percentile less than pct is returned. The data type of the specified column (and of the corresponding returned value) must be one of the comparable types in the expression language, as listed on the Data Types page.

SEE ALSO

This LiveView aggregate function is based on the percentile aggregate function in the StreamBase expression language.