Functions

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

AvgIf

Corr

Count

CountDistinct

See all 24 articles

Array functions

Use these functions to manage and manipulate arrays.

Array functions overview

ArrayContains

ArrayDistinct

ArrayLength

ArraySlice

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 28 articles

Financial functions

This section describes several financial functions that Sigma supports.

Financial function overview

CAGR

Effect

FV

IPmt

Nominal

See all 11 articles

Geography functions

Geography functions overview

Area

Centroid

Distance

Geography

Intersects

See all 14 articles

Join functions

Join functions overview

Lookup

Rollup

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

Passthrough functions

Passthrough 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

AggGeography

AggLogical

AggNumber

AggText

AggVariant

See all 13 articles

System functions

These functions return information about the current state of Sigma.

CurrentTimezone

CurrentUserAttributeText

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 29 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