/
GROUPMIN
GROUPMIN
Syntax
GROUPMIN(<number>)
Description
Returns the minimum values in a group. A GROUPBY() function must first be used in order to then find the minimum arguments of another column in relation to it.
This is an aggregate function.
Example
Given the following data:
Name | Number |
---|---|
Ajay | 27087 |
Ajay | 55317 |
Alice | 14489 |
Ajay | 31310 |
Ajay | 57822 |
Ajay | 63855 |
Alice | 47640 |
Alice | 48979 |
First create a group using GROUPBY(#RawData!Name).
Name |
---|
Ajay |
Alice |
Then use GROUPMIN(#RawData!Number) to return the minimum values of the Number column.
Name | Min_Number |
---|---|
Ajay | 27087 |
Alice | 14489 |
, multiple selections available,
Related content
GROUPMIN
GROUPMIN
More like this
GROUPMAX
GROUPMAX
More like this
GROUPTOPN
GROUPTOPN
More like this
GROUPMEDIAN
GROUPMEDIAN
More like this
GROUPBOTTOMN
GROUPBOTTOMN
More like this
GROUPLAST
GROUPLAST
More like this