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.