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])
|
Thank you for your feedback and comments.We will rectify this as soon as possible!