# 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.