References → Built-in Functions

Overview of built-in functions

Incorta provides the ability to create new formula column in the business schema view or within an insight on a dashboard using a comprehensive library of formula functions.

Aggregation Functions

Summarize the contents of a column of data. Here is a list of supported aggregation functions:

Analytic Functions

Compute values over a group of rows and returns a single result for each row. Here is a list of supported analytic functions:

Arithmetic Functions

Perform math operations on values. Here is a list of supported arithmetic functions:

Boolean Functions

Evaluate one or more expressions and return a boolean value. Here is a list of supported boolean functions:

Conditional Statements

Evaluate and return the results of an expression depending on the result of evaluating a boolean expression. Here is a list of supported conditional statements:

Conversion Functions

Converts values from one type to another. Here is a list of supported conversion functions:

Date Functions

Adjust values of type date or timestamp. Here is a list of supported date functions:

Filter Functions

Filter data to those items before or after a specified date. It is also possible to filter the data in groups. Here are the supported filter functions:

Miscellaneous Functions

Various functions for finding values in table hierarchies, setting schema refresh interval and determining the row number in a query. Here is a list of supported miscellaneous functions:

String Functions

Convert, truncate and search within text strings. Here is a list of supported string functions: