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 articlesArray 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 28 articlesFinancial functions
This section describes several financial functions that Sigma supports.
See all 11 articlesGeography functions
See all 14 articlesJoin 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 articlesMath functions
These functions return well-known mathematical constants or implement common arithmetic functions.
See all 38 articlesOperators
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 articlesSystem 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 articlesType 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 articlesWindow functions
Window Functions are special functions where the result is dependent on the order and grouping of rows.
See all 34 articles