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.

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