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 17 articles
Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.See all 23 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 37 articles
Sigma supports the basic operators used to create calculations. The order the operations are performed in follow the mathematical order of operations.
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.See all 10 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 27 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 33 articles