Aggregate
Summarize data by aggregating.
Summarize data by aggregating.
The aggregate operations are: MAX, MIN, COUNT, SUM, AVERAGE, MEDIAN, OR, AND, and STDEV.
You can use the OR and AND functions only with columns that contain Boolean values. The tool returns TRUE if:
OR is used and at least one record is true.
AND is used and all records are true.
Tip
You can use the COUNT operation without selecting an aggregate column.
When to use this tool
Use this tool when you want to:
Perform an aggregate operation on a column.
Arrange data into groups.
Arrange your data into groups AND apply an aggregate operation.
Example
Let's use the aggregate tool to return the total row count for our data set.
Leave the Grouped columns and Aggregate columns fields blank.
Type a name for the new column.
In the Operation field, select COUNT.