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, minimums, maximums and averages, and even sort the results.

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:

1. Create a new report

• Click "New Report", then select in "Orders" the "Basic Report". Choose the data fields you want to include in your report. For this example, select "Shipping Address: Country" and "Total Price". To keep the report clean, remove any unnecessary columns so that only these two remain.

2. Rename the fields.

• In this case, change “Shipping Address: Country” to “Country” and “Total Price” to “Average Order Value”.

3. Aggregation

• Click on the Tab "Aggregations"
• Activate the “Aggregate” checkbox on the left side of the interface to switch to aggregation mode.
• 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.
• Drag the field you want to calculate into the Metrics section. In our example we are using "Average Order Value".

4. Select the mathematical operation

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

5. Sort by

• 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”

6. Preview, Safe & Run

• Click on the "Preview Button" to check to result of 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.

Updated on: 24/11/2025