Quick links:
Aggregate functions calculate totals from a set of records.
Average
Calculates the average value of the records of the specified field.
Format:
Average( fieldName )
Parameters:
fieldName – data source field name
Data type returned:
number
Example:
sales | GroupBy( product, amount ) | Average ( amount ) – returns the average price of sales
Max
Calculates the max value of the records of the specified field.
Format:
Max( fieldName )
Parameters:
fieldName – data source field name
Data type returned:
number
Example:
sales | GroupBy( product, amount ) | Max ( amount ) – returns the max price of sales
Min
Calculates the min value of the records of the specified field.
Format:
Min( fieldName )
Parameters:
fieldName – data source field name
Data type returned:
number
Example:
sales | GroupBy( product, amount ) | Min ( amount ) – returns the min price of sales
Sum
Calculates the total of the records of the specified field.
Format:
Sum ( fieldName )
Parameters:
fieldName – data source field name
Data type returned:
number
Example:
sales | GroupBy( product, amount ) | Sum ( amount ) – returns the total of sales
Count
Calculates the number of records selected.
Format:
Count ( )
Parameters:
no parameters
Data type returned:
number
Example:
sales | GroupBy( product, amount ) | Count ( ) – returns the number of records selected