Aggregate function

When we group a report, we need to give him the corresponding aggregation method.

1. Aggregate selection

1. After the report data is completed, select one of the column names (Y-axis) and click on the aggregate function.

2.After clicking, a modal box will pop up, which can process the data according to your actual needs.

Total: The total number of queries (including the duplicate name of the field)
Total deduplication: Total number of queries (excluding duplicate names of the field)
sum: the sum of the data queried
max: the maximum value of the data that is queried
min value: the minimum value in the data that is queried
Average value: Average value in the queried data