Performing a simple aggregation on Query Builder columns

In the Selections pane (the bottom pane on the right) of the Query Builder Editor you can define the column expression for each column selection. You can perform a simple aggregation on a column expression in the Selections pane by right-clicking a column and pointing to Simple Aggregation, then selecting from the following aggregation functions:

• Sum: Adds all the values returned by the column expression.

• Avg: Calculates the average of all the numbers returned by the column expression.

• Min: Returns the smallest value returned by the column expression.

• Max: Returns the largest value returned by the column expression.

• Count: Counts the number of values returned by the column expression.

• Count Distinct: Counts the distinct number of values returned by the column expression.

• None: Clears the outer simple aggregation function of the column expression. Any simple aggregation functions that are calculated inside the outer simple aggregation function are not cleared.