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
CountDistinctIf
See all 21 articlesDate Functions
Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.
Date Functions Overview
ConvertTimezone
DateAdd
DateDiff
DateFormat
DateFromUnix
See all 26 articlesFinancial functions
This section describes several financial functions that Sigma supports.
CAGR
Effect
FV
Nominal
NPer
Pmt
See all 8 articlesJoin Functions
Rollup
Lookup
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.
ArrayContains
ArrayLength
Between
Choose
Coalesce
If
See all 12 articlesMath Functions
These functions return well-known mathematical constants or implement common arithmetic functions.
Abs
Acos
Asin
Atan
Atan2
BinFixed
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.
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.
CurrentTimezone
CurrentUserAttributeText
CurrentUserEmail
CurrentUserInTeam
Text Functions
Text functions analyze or manipulate string data and are useful sanitizing string input.
Concat
Contains
EndsWith
Find
ILike
Left
See all 28 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.
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.