Popular Functions
Functions are powerful tools that allow you to perform complex analysis, while still having access to your entire database. Learn more about how to use functions.
These functions are the most popular functions in Sigma. Click on the name in the left column to learn more about the function.
If  Returns the value following the first condition that is met. 
CountIf 
Counts the number of rows in a table or group for which all given conditions are true.

SumIf 
Sum the values in a column if all the conditions are true.

Sum 
Sum the values in a column or group.

Avg 
Calculate the average of a column of numbers.

Min 
Find the minimum value for a column or group.

Max 
Find the maximum value for a column or group.

Count 
Count the nonNull values within a column or group.

CountDistinct 
Counts the number of unique values within a column or group.

Concat 
Combine strings together.

Contains 
Returns true if a string contains a substring.

Right 
Returns a substring terminating at the end of a given string.

Choose 
Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.

BinRange 
Computes the bin for a value using the provided lower bounds.

Coalesce 
Returns the first nonNull value from the arguments provided.

DateDiff 
Calculates the time difference between two dates.

Today 
Returns the current UTC date.

MovingAvg 
Calculates the numerical average in a moving window.

CumulativeSum 
Calculates the sum across the values up to and including the current value.

First 
Repeats the first row value of the given column for every row in the output column.

Nth 
Repeat the nth value of the the given column for every row in a column.

Lead  Shift a column upward. 
Rank  Rank the rows in the table using the input column. Begins with 1. Identical values are assigned identical rank. Defaults to sort Ascending. 