Function Index

Learn how to use Sigma functions in your data analysis.

Aggregate Functions

Aggregate functions are special functions which summarize columns from lower levels. Aggregate functions can be used on on Grouped levels or in a Total column.

Aggregate Functions Overview

Avg

Corr

Count

CountDistinct

CountDistinctIf

See all 21 articles

Date Functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.

ConvertTimezone

Date Functions Overview

DateAdd

DateDiff

DateFormat

DateFromUnix

See all 24 articles

Logical Functions

Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.

Between

Choose

Coalesce

If

In

IsNotNull

See all 10 articles

Math Functions

These functions return well-known mathematical constants or implement common arithmetic functions.

Abs

Acos

Asin

Atan

Atan2

BinFixed

See all 38 articles

Operators

Sigma supports the basic operators used to create calculations. The order the operations are performed in follow the mathematical order of operations.

Operators Overview

Pass-Through Functions

Pass-through functions allow you to send a function name and input directly to your database. This makes it possible to use database specific functions that are otherwise not available through Sigma.