percentile — aggregate function to return value closest to the specified percentile rank
This function returns the value of the specified column with percentile rank equal to
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.
As of 10.4.4, this function is deprecated but still supported for backward compatibility.
This LiveView aggregate function is based on the percentile aggregate function in the StreamBase expression language.