What is Auto Aggregation?
When uploading a unit record level file, you may see an option to apply Auto Aggregation. This feature automatically generates summary metrics from your dataset with no manual setup required.
What happens when you enable Auto Aggregation?
Once selected, the system will create a set of standard aggregations across your data:
1. Dataset-level metric
- Number of records: Total count of rows in your uploaded file
2. Column-level metrics (for all numeric fields)
For every column with a numeric data type, the following are calculated:
- Sum: The sum of all values in teh set
- Lowest: Smallest value in the set
- Highest: Largest value in the set
- Average: The arithmentic Mean value for the set
Why use Auto Aggregation?
- Quick insights: Instantly understand the scale and distribution of your datasets numeric values
- No setup needed: Saves time compared to manually defining aggregations
- Consistency: Ensures standard metrics are always available across datasets