Aggregate functions

๐Ÿ“˜

These functions work best with aggregated data in a grouped table. For a video explanation of working with functions of this type, see Getting started with functions and groupings in Sigma.

Aggregate functions evaluate multiple rows of data to return a single value. For example, you can use aggregate functions to perform group calculations (like Sum and Avg), retrieve specific values (like Min and Max), assess the data to provide insights (like Count and CountDistinct), or join multiple values (like ArrayAgg and ListAgg).

ArrayAgg

Identifies non-null row values in a column or group and aggregates them into a single array.

ArrayAggDistinct

Identifies distinct non-null row values in a column or group and aggregates them into a single array.

Avg

Calculates the average value of a column or group.

AvgIf

Calculates the average value of a column or group when the specified condition is True.

Corr

Calculates the Pearson correlation coefficient (bivariate correlation) of two columns.

Count

Counts the number of non-null and non-empty values in a column or group.

CountDistinct

Counts the number of unique non-null and non-empty values in a column or group. Does not count duplicate values. (Same as Ndv.)

CountDistinctIf

Counts the number of unique non-null and non-empty values in a column or group when the specified condition is True. Does not count duplicate values.

CountIf

Counts the number of non-null and non-empty values in a column or group when the specified condition isTrue.

GrandTotal

Calculates the grand total for column or group.

ListAgg

Joins the values of a group or column into a single text string.

ListAggDistinct

Joins the unique values of a group or column into a single text string. Does not include duplicate values.

Max

Retrieves the maximum (largest or latest) value in a column or group.

MaxIf

Retrieves the maximum (largest or latest) value in a column or group when the specified condition isTrue.

Median

Determines the median (midpoint) value of a column or group.

Min

Retrieves the minimum (smallest or earliest) value in a column or group.

MinIf

Retrieves the minimum (smallest or earliest) value in a column or group when the specified condition isTrue.

PercentileCont

Calculates the continuous kth percentile of a column or group.

PercentileDisc

Calculates the discrete kth percentile of a column or group.

PercentOfTotal

Calculates the percentage a value contributes to the specified aggregate total.

RegressionIntercept

Calculates the y-intercept of the linear regression line.

RegressionR2

Calculates the coefficient of determination of the linear regression line.

RegressionSlope

Calculates the slope of the linear regression line.

StdDev

Calculates the standard deviation of a column or group.

Subtotal

Calculates the subtotal of a column or group.

Sum

Calculates the sum of a column or group.

SumIf

Calculates the sum of a column or group when the specified condition isTrue.

SumProduct

Calculates the product of row values across specified columns, then calculates the sum of the resulting products for a column or group.

Variance

Estimates the sample variance (spread of distribution) of a column or group.

VariancePop

Calculates the population variance (spread of distribution) of a column or group.