Aggregating Data
Updated
March 19, 2021
When building a recipe you can aggregate data to combine points that share features into collections. Aggregation will summarise your data points around a variable.
This is especially useful when you have large sets of microdata and need to focus on identifying general trends. Note that aggregation is only possible for some types of analysis.
β
β
Analysis Types Supporting Aggregation
Model
Geospatial
Surveys
Commerce
Google Analytics
Employees
β
You could aggregate individual birth rates from England, Scotland, Northern Ireland and Wales to create an aggregated birth rate for the UK.
β
β
How to Aggregate Your Data?
- Start building a recipe using the project setup wizard.
- Pick a type of analysis.
- Choose an option from the sidebar to further indicate the type of analysis you want to conduct. The title should include 'Aggregate'.
- Inside the recipe wizard belonging to the type of analysis you have chosen, open the 'Aggregation' form.
- Select the dropdown menu inside the 'Aggregation form.
- Choose a variable or variables to aggregate your data.
- To delete a variable from the aggregation list, click the 'x' icon next to the variable name.
- Done ... Your data will be aggregated when you execute the project!
β
Need Something Different?
We know that data isn't always clean and simple.
Have a look through these topics if you can't see what you are looking for.