Aggregations

Aggregations

The Aggregation Function in DataChamp is a versatile feature designed to help you analyze your data effectively. It allows you to group values by rows or columns, calculate sums, minimuns, maximums and averages, and even sort the results. Here’s how to make the most of it.

In this tutorial, we'll walk you through a simple example on how to use the Aggregation Function to generate a report that calculates the Average Order Value per Country:




Create a new report
Click "New Report", then select "Orders"

Select the Requiered Fields
Choose the data fields you want to include in your report. For this example, select "Shipping Address: Country" and "Total Price".

Remove the columns
To keep the report clean, remove any unnecessary columns so that only these two remain.

Rename the Fields
Rename the fields. In this case, change “Shipping Address: Country” to “Country” and “Total Price” to “Average Order Value”.

Open Aggregation overview
activate the “Aggregate” checkbox on the left side of the interface to switch to aggregation mode.

Group Data
Drag and drop the fields into the relevant sections. We have to drop the "Country" field into the "Group by Rows" section to group the data by country.

Add the Metrics
Drag the field you want to calculate into the Metrics section. In our example we are using "Average Order Value".

Select the mathematical operation
Choose how you want the data calculated: Sum, Max, Min or Average. In this case we use "Average".

Sort the Values
Click "Sort by" to organize your results. In this example, sort by "Average Order Value" to display the data in order. To see the highest value at the top, choose “DESC”

Preview the Result
Click on the "Preview Button" to check to result of the report.

Save and Run the Report
If the results are as expected, give the report a clear name, such as “Average Order Value”, save it, and run it to generate the final results.

Need Help?
If you encounter any issues or have questions, don’t hesitate to contact us at hello@datachamp.io

Updated on: 04/03/2025