Versions Compared

Key

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

Syntax

GROUPPERCENTILE(<number>; [<number>])

Description

Return the number which is nth percentile in this distribution as float. The value returned by this function identifies the point where N% of the samples of the distribution are smaller than the Nth percentile. The first argument is the data column, the second argument is N (a value between 0 and 100).

...

Then use the GROUPPERCENTILE(#RawData!Participants;80) function, and the result is float that a float that is the nth percentile (in this case 80th percentile) in relation to the GROUPBY() column. In this example, the function calculates the value at which 80 percent of the values in the data column are below that number and 20 percent of the values in that data column are above. 

...