Syntax
GROUPBOTTOMN(<any>;[<integer>])
Description
Selects the bottom N values from a group. If this function is applied on a date column, bottom N means the N least recent dates.
This is a group series 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 GROUPBOTTOMN(#RawData!Participants;3), and the result is the bottom "N" (in this case "3") values of the column in relation to the GROUPBY() column.
| Groups | Smallest_Participants |
|---|---|
| group1 | 5 |
| group1 | 5 |
| group1 | 5 |
| group2 | 24 |
| group2 | 24 |
| group2 | 24 |