Syntax
GROUPMEDIAN(<number>)
Description
Returns the medium of all values in a group.
This is an aggregate function.
Example
Given the following data:
| Groups | Participants |
|---|---|
| group1 | 6 |
| group1 | 12 |
| group1 | 5 |
| group1 | 5 |
| group1 | 5 |
| group1 | 7 |
| group1 | 5 |
| group1 | 9 |
| group1 | 8 |
| group2 | 24 |
| group2 | 24 |
| group2 | 24 |
| group2 | 33 |
| group2 | 33 |
| group2 | 29 |
| group2 | 30 |
| group2 | 32 |
| group2 | 35 |
First create a group using GROUPBY(#RawData!Groups)
| Groups |
|---|
| group1 |
| group2 |
Then use the GROUPMEDIAN(#RawData!Participants), and the result is the medium number of the column in relation to the GROUPBY() column.
| Groups | Participants_MEDIAN |
|---|---|
| group1 | 6 |
| group2 | 30 |