GROUPCOUNT
Syntax
GROUPCOUNT()
Description
Counts the records in one group. No calculations are performed with this function.
Empty or <null> records of a group are calculated into GROUPCOUNT().
The GROUPCOUNT function results in an error only if the grouping itself contains an error.
This is an aggregate function.
Example
Given the following data:
Customer_ | Name | Item |
|---|---|---|
2535 | Jon | Zamioculcas |
2888 | Mike | Spider Lily |
2535 | Jon | Datura |
2535 | Jon | Dahlia |
8654 |
| Windflower |
5788 | Jon | Snapdragon |
2888 | Mike | Marguerite |
2535 | Jon | Windflower |
2888 | Mike | Elephant's Ear |
2535 | Jon | Chinese Evergreen |
5788 | Jon | Begonia |
5788 | Jon | Starfish Plant |
2535 | Jon | Hare's Foot Fern |
2535 | Jon | Venus Flytrap |
3545 | Monique | Red Flame Ivy |
8654 |
| Starfish Plant |
4587 |
| Begonia |
1234 | <error> | Elephant's Ear |
4321 | <error> | Snapdragon |
First create a group using GROUPBY(#RawData!Name)
Name |
|---|
<error> |
|
Jon |
Mike |
Monique |
Use GROUPCOUNT() to return the amount of times a given argument appears, in relation to the GROUPBY() column.
Name |
|
|---|---|
<error> | <error> |
| 3 |
Jon | 10 |
Mike | 3 |
Monique | 1 |