Learn how to use Sigma functions in your data analysis.
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
Use these functions to manage and manipulate arrays.
Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.See all 28 articles
This section describes several financial functions that Sigma supports.See all 11 articles
Geography functionsSee all 14 articles
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
These functions return well-known mathematical constants or implement common arithmetic functions.See all 38 articles
Sigma supports the basic operators used to create calculations. The order the operations are performed in follow the mathematical order of operations.
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
These functions return information about the current state of Sigma.
Text functions analyze or manipulate string data and are useful sanitizing string input.See all 29 articles
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 are special functions where the result is dependent on the order and grouping of rows.See all 34 articles