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
CountIf
See all 17 articlesDate Functions
Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.
ConvertTimezone
Date Functions Overview
DateAdd
DateDiff
DateFromUnix
DateParse
See all 23 articlesLogical 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.
Between
Choose
Coalesce
If
In
IsNotNull
See all 10 articlesMath Functions
These functions return well-known mathematical constants or implement common arithmetic functions.
Abs
Acos
Asin
Atan
Atan2
BinFixed
See all 37 articlesOperators
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 articlesSystem Functions
These functions return information about the current state of Sigma.
CurrentUserAttributeText
CurrentUserEmail
CurrentUserInTeam
System Functions Overview
Text Functions
Text functions analyze or manipulate string data and are useful sanitizing string input.
Concat
Contains
EndsWith
Find
ILike
Left
See all 27 articlesJoin Functions
Rollup
Lookup
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 articlesWindow Functions
Window Functions are special functions where the result is dependent on the order and grouping of rows.