Skip to main content

Data Grouping and Aggregation

You can group data records by a specific column by selecting it and enabling the Group By setting in the Column Properties panel.

query-builder-column-group-by

After this, you should specify the other selected columns’ aggregation using the Aggregate property.

query-builder-column-aggregate

The Query Builder supports the following aggregate functions: Count, Max, Min, Avg, Sum, CountDistinct, AvgDistinct and SumDistinct. Applying any of these functions to a column discards individual data records from the query result set and includes only the aggregate function’s result.

Note

You can use aggregation and grouping for all the selected columns or none of them.

Applying aggregation to one column automatically applies grouping to the other selected columns. Removing all the aggregation functions resets grouping against other columns.