GROUPMEDIAN
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 |