Aggregate Functions

Aggregate functions perform operations across columns.

CRM Analytics supports the following aggregate functions.

avg()

Takes the average of row values in a given column.
count()

Returns the number of rows that match a specified condition in a column.
min()

Returns the lowest row value in a numeric column.
max()

Returns the highest row value in a numeric column.
sum()

Returns the sum of all rows values in a numeric column.
stddev_pop()

Returns the population standard deviation of the values in a field. Accepts measure fields as input. This function does not accept expressions.
stddev_samp()

Returns the standard deviation of values in a field. Accepts measure fields as input. This function does not accept expressions.
var_pop()

Returns the population variance of the values in a field. Accepts measure fields as input. This function does not accept expressions.
var_samp()

Returns the sample variance of the values in a field. Accepts measure fields as input. This function does not accept expressions.
regr_intercept()

Returns the y-intercept value of a regression line.
regr_slope()

Returns the slope of a regression line between two numerical fields.
regr_r2()

Returns the R-squared, or goodness-of-fit value for a regression.
percentile_cont

Calculates a percentile based on a continuous distribution of the column value.
percentile_disc

Returns the value corresponding to a given percentile. Accepts measure fields as input.