CountPercentile

Returns the number of items that are above or below the percentile for the specified list.

  • Returned Output: Numeric
  • Library: PQL \ Dynamic \ Grid
  • Version: 2020.02.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

CountPercentile( <Numeric List> , <Numeric> , <Boolean> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The numeric list is a list or array of values.
  • The numeric value is a decimal amount representing the percentile from 0 to 1.
  • The boolean is a true/false (1/0) to count those above (true) or below (false) the threshold.

Examples

The example below uses the following example grid.

This example returns 15 using the first column (sales) above.

CountPercentile(dataSetColumn(0), 0.25, true)