## Function Index

- Popular Functions
- Aggregate Functions
- Date Functions
- Logical Functions
- Math Functions
- Operators
- Text Functions
- Type Functions
- Window Functions
- CumeDist
- CumulativeAvg
- CumulativeCorr
- CumulativeCount
- CumulativeMax
- CumulativeMin
- CumulativeStdDev
- CumulativeSum
- CumulativeVariance
- FillDown
- First
- Lag
- Last
- Lead
- ListAgg
- MovingAvg
- MovingCorr
- MovingCount
- MovingMax
- MovingMin
- MovingStdDev
- MovingSum
- MovingVariance
- Nth
- Ntile
- Rank
- RankDense
- RankPercentile
- RowNumber

- System

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 guides are meant to be used on an as needed basis, when you need more in-depth knowledge about a specific function. Basic function guidance is built into Sigma. Start typing a function name, and Sigma provides you the context you need to complete the formula.

Start learning about Sigma’s functions by checking out the list of our most popular functions.

When you type in a function, Sigma provides you a description of the function, descriptions of the arguments needed for the function, and a link to the in depth function documentation. You can also click fx on the left hand side of Sigma’s formula bar any time to open this function index page.

Returns the absolute value of a number.

Computes the arccosine of the given angle.

Computes the arcsine of the given angle.

Computes the arctangent of the given angle.

Computes the arctangent of the given coordinates.

Calculate the average of a column of numbers.

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

Rounds the input up to the smallest integer that is of equal or greater value.

Returns the first non-Null value from the arguments provided.

Combine strings together.

Returns true if a string contains a substring.

Converts a UTC date to a different time zone.

Computes the cosine of the given angle.

Computes the cotangent of the given angle.

Count the non-Null values within a column or group.

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

Counts the number of rows in a table or group for which all given conditions are true.

Calculates the numerical average of the column up to and including the current value.

Calculates the correlation coefficient of the column up to and including the current value.

Counts the number of non-null values up and including to the current value.

Calculates the maximum across the values up to and including the current value.

Calculates the minimum across the values up to and including the current value.

Calculates the standard deviation across the values up to and including the current value.

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

Calculates the variance across the values up to and including the current value.

Returns the current user's email address.

Returns True if the current user is a member of any of the given teams.

Convert the value into a date and time. All times are assumed to be UTC.

Adds the specified quantity of time to a date.

Calculates the time difference between two dates.

Convert a Unix-style timestamp (seconds since January 1, 1970) to a Date.

Extract the specified date part, e.g. “month”, from the given date.

Convert the value into a date and time.

Truncate the date to the specified date part, e.g.”month”.

Returns the day of the month of the given date as a number.

Converts an angle in radians to degrees.

Calculates the distance between two points on the globe, in kilometers.

Calculates the distance between two points on the plane.

Returns the integer component of a division operation.

Returns the integer component of a division operation.

Returns true if a string ends with a substring.

Returns the mathematical constant e (2.7183…) raised to the given power.

Replaces a column’s null values with the closest, prior non-null value.

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

Rounds the input down to the largest integer that is of equal or lesser value.

Returns the largest value amongst the inputs.

Returns the hour component of the given date as a number.

Returns the value following the first condition that is met.

Returns True if the argument is Null (does not contain valid data), and False otherwise.

Interpret the column as containing JSON.

Prepends a pattern to or truncates a string to the desired length.

Removes leading spaces from a given string.

Shift a column downward.

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

Shift a column upward.

Returns the smallest value amongst the inputs.

Returns a substring beginning at the start of a given string.

Returns the number of characters in a string, including spaces.

Compute the natural logarithm of a number.

Compute the logarithm of a number, defaulting to base 10.

Convert the value into True or False.

Converts a given string to lowercase.

Utilizes the MD5 algorithm to calculate the hash value of a given string.

Makes a date from the given year, month, and day of the month.

Find the maximum value for a column or group.

Find the median of a column or group.

Returns a substring defined by offset and length.

Find the minimum value for a column or group.

Returns the minute component of the given date as a number.

Returns the month component of the given date as a number.

Calculates the numerical average in a moving window.

Calculates the correlation coefficient in a moving window.

Count values in a moving window. Null values are not counted.

Find the maximum value within a moving window.

Find the minimum value within a moving window.

Calculate the standard deviation within a moving window.

Sum the values in a moving window.

Calculates the statistical variance in a moving window.

Returns the current UTC date and time.

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

Assign the rows of a column to a given number of ranks.

Convert the value into a number.

Calculate the continuous k-th percentile value for a column or group.

Find the discrete k-th percentile value for a column or group.

Returns the mathematical constant π = 3.14159…

Raises a number to the specified power.

Returns the quarter component of the given date, as a number.

Appends a pattern to or truncates a string to the desired length.

Removes trailing spaces from the right side of a given string.

Converts an angle in degrees to radians.