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.

Date Functions Overview

ConvertTimezone

DateAdd

DateDiff

DateFormat

DateFromUnix

See all 26 articles

Financial functions

This section describes several financial functions that Sigma supports.

CAGR

Effect

FV

Nominal

NPer

Pmt

See all 8 articles

Join Functions

Rollup

Lookup

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.

ArrayContains

ArrayLength

Between

Choose

Coalesce

If

See all 12 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.

AggDatetime

AggLogical

AggNumber

AggText

AggVariant

CallDatetime

See all 10 articles

System Functions

These functions return information about the current state of Sigma.

CurrentTimezone

CurrentUserAttributeText

CurrentUserEmail

CurrentUserInTeam

Text Functions

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

Concat

Contains

EndsWith

Find

ILike

Left

See all 28 articles

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

CumeDist

CumulativeAvg

CumulativeCorr

CumulativeCount

CumulativeMax

See all 34 articles