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.
2. Explanation of the aggregation method
- 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