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

See all 24 articles### Array functions

Use these functions to manage and manipulate arrays.

### Date functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.

See all 27 articles### Financial functions

This section describes several financial functions that Sigma supports.

See all 11 articles### Geography functions

See all 14 articles### Join functions

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

See all 10 articles### Math functions

These functions return well-known mathematical constants or implement common arithmetic functions.

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.

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

See all 13 articles### System functions

These functions return information about the current state of Sigma.

### Text functions

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

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.

See all 7 articles### Window functions

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

See all 34 articles