Reference: Group By Stages
As you complete this stage, consider:
Group By Stage Option | Description |
|---|---|
Choose Grouping Fields | Select 1 or more fields by which to group values together. If you
summarize (aggregate) values in a group that contains different currency
codes, Workday returns NULL values. |
Add Summarization Fields | Define 1 or more summarization types (aggregate functions) that apply
to each grouping field. |
You can select from these summarization types:
Summarization Type | Description |
|---|---|
Average | Average returns the average of all valid numeric
values for the specified grouping field. It sums all values in the specified
field and divides by the number of valid (NOT NULL) rows. You can calculate
the average on any numeric field. |
Count | Count returns the number of rows for the specified
grouping field. |
Max | Max returns the largest (maximum) value from the
specified grouping field. You can calculate the maximum on any numeric or
date field. |
Min | Min returns the smallest (minimum) value from the
specified grouping field. You can calculate the minimum on any numeric or
date field. |
Sum | Sum returns the total of all values from the
specified grouping field. You can calculate the sum on any numeric
field. |