Configure Aggregation expressions
Functions
AVG
| Syntax | AVG(numeric_expression) |
| Description | Returns the average of the values in the given expression. |
| Example | AVG([UnitPrice]) |
AVGD
| Syntax | AVGD(numeric_expression) |
| Description | Returns the average of the distinct values in the given expression. |
| Example | AVGD([UnitPrice]) |
COUNT
| Syntax | COUNT(numeric_expression) |
| Description | Returns the number of items in the given expression. |
| Example | COUNT([OrderID]) |
COUNTD
| Syntax | COUNTD(numeric_expression) |
| Description | Returns the distinct number of items in the given expression. |
| Example | COUNTD([OrderID]) |
MAX
| Syntax | MAX(numeric_expression) |
| Description | Returns the maximum value in the given expression. |
| Example | MAX([UnitPrice]) |
MIN
| Syntax | MIN(numeric_expression) |
| Description | Returns the minimum value in the given expression. |
| Example | MIN([UnitPrice]) |
STDEV
| Syntax | STDEV(numeric_expression) |
| Description | Returns the standard deviation of values in the given expression. |
| Example | STDEV([OrderID]) |
SUM
| Syntax | SUM(numeric_expression) |
| Description | Returns the sum of values in the given expression. |
| Example | SUM([UnitPrice]) |
SUMD
| Syntax | SUMD(numeric_expression) |
| Description | Returns the sum of the distinct values in the given expression. |
| Example | SUMD([UnitPrice]) |
VAR
| Syntax | VAR(numeric_expression) |
| Description | Returns the variance of values in the given expression. |
| Example | VAR([OrderID]) |
TOTAL
| Syntax | TOTAL(numeric_expression) |
| Description | Returns the total values in the given expression. |
| Example | TOTAL(SUM([UnitPrice])) |
QUANTILEEXACT
| Syntax | QUANTILEEXACT(level, expression) |
| Description | Exactly computes the quantile of a numeric data sequence. Support is only provided for the ClickHouse Connector. |
| Example | QUANTILEEXACT(0.8, [UnitPrice]) |
PERCENTILE_CONT
| Syntax | PERCENTILE_CONT(percentile, numeric_column) |
| Description | Computes exact values at one or more specified percentiles (quantiles) of a numeric dataset using continuous distribution. This is useful for statistical analysis such as finding the median, quartiles, or custom percentiles. Currently supported only with the Postgres Connector. |
| Example | PERCENTILE_CONT(0.8, [UnitPrice]) |
MODE
| Syntax | MODE(expression) |
| Description | Returns the most frequently occurring (modal) value of the given expression. Null values are ignored. |
| Example | MODE([UnitPrice]) |