Aggregation
AVG
Description: Returns the average value of a numeric expression across all rows in the current aggregation context.
Syntax: AVG ( table.column )
Example:
TABLE( "Table"."Country" AS "Country", AVG("Table"."Values") AS "Avg Values" )
COUNT
Description: Counts the number of rows that contain a non-NULL value for the specified expression.
Syntax: COUNT ( table.column )
Example:
TABLE( COUNT("Table"."Column1") AS "Rows with value" )
COUNT_DISTINCT
Description: Counts the number of unique values of an expression within the current aggregation scope.
Syntax: COUNT ( DISTINCT table.column )
Example:
TABLE( COUNT(DISTINCT "Table"."CustomerID") AS "#Customers" )
FIRST
Description:
Returns the first value of an expression according to the event order in the current context.
Syntax: FIRST ( table.input_column [ , ORDER BY table.column [ASC|DESC] ] )
Example:
TABLE( FIRST("Activities"."Activity", ORDER BY "Activities"."Eventtime") AS "First Activity" )
LAST
Description:
Returns the last value of an expression according to the event order in the current context.
Syntax: LAST ( table.input_column [ , ORDER BY table.column [ASC|DESC] ] )
Example:
TABLE( LAST("Activities"."Activity", ORDER BY "Activities"."Eventtime") AS "Last Activity" )
MAX
Description:
Returns the maximum value of an expression within the aggregation scope.
Syntax: MAX ( table.column )
Example:
TABLE( MAX("Items"."Amount") AS "Max Amount" )
MEDIAN
Description:
Computes the median value of a numeric expression across the dataset or group.
Syntax: MEDIAN ( table.column )
Example:
TABLE( MEDIAN("Items"."Amount") AS "Median Amount" )
MIN
Description:
Returns the minimum value of an expression within the aggregation context.
Syntax: MIN ( table.column )
Example:
TABLE( MIN("Items"."Amount") AS "Min Amount" )
STDEV
Description:
Calculates the statistical standard deviation of numeric values in the aggregation scope.
Syntax: STDEV ( table.column )
Example:
TABLE( STDEV("Items"."Amount") AS "StdDev" )
SUM
Description:
Sums all numeric values of an expression in the aggregation context.
Syntax: SUM ( table.column )
Example:
TABLE( SUM("Items"."Amount") AS "Total Amount" )