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

CountIf

See all 17 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

DateFromUnix

DateParse

See all 23 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 37 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.

AggDatetime

AggLogical

AggNumber

AggText

AggVariant

CallDatetime

See all 10 articles

System Functions

These functions return information about the current state of Sigma.

CurrentUserEmail

CurrentUserInTeam

System Functions Overview

Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

Concat

Contains

EndsWith

Find

ILike

Left

See all 27 articles

Join Functions

Rollup

Lookup

Type Functions

Type functions are used to convert an input of one type into other types, e.g. from the string “3” to the number 3.

Date

JSON

Logical

Number

Text

Type Functions Overview

See all 7 articles

Window Functions

Window Functions are special functions where the result is dependent on the order and grouping of rows.

ArrayAgg

CAGR

CumeDist

CumulativeAvg

CumulativeCorr

CumulativeCount

See all 33 articles