Aggregations Functions

AVG(x)

This function returns the average value of a numeric column.
COUNT(x)

This function returns the number of rows that matches a specified criteria.
COALESCE(x,y)

This function replaces the NULL values in a column by with a specific value.Example:coalesce("quota_share",0)
MAX(x)

This function returns the largest value of the selected column.Example:Max(coalesce("vehicle_value",0))
MIN(x)

This function returns the smallest value of the selected column.Example:MIN(coalesce("vehicle_value",0))
SUM(x)

This function returns the total sum of a numeric column.Example:Sum(coalesce("vehicle_value",0))