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.