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.
Here is a list of supported functions when creating a new formula:
| Group | Description |
|---|---|
| Aggregation Functions | Summarize the contents of a column of data |
| Analytic Functions | Compute values over a group of rows and returns a single result for each row |
| Boolean Functions | Evaluate one or more expressions and return a boolean value |
| Conditional Statements | Evaluate and return the results of an expression depending on the result of evaluating a boolean expression |
| Conversion Functions | Converts values from one type to another |
| Filter Functions | These functions are used to filter data to those items before or after a specified date. It is also possible to filter the data in groups |
| Miscellaneous Functions | Various functions for finding values in table hierarchies, setting schema refresh interval and determining the row number in a query |
| Arithmetic Functions | Perform math operations on values |
| Date Functions | Adjust values of type date or timestamp |
| String Functions | Convert, truncate and search within text strings |
How to read built-in function reference entries
Formula Function reference entries contain sections:
- Example(s) : includes a verbal description of a problem followed by how the solution looks in Incorta
- Syntax : the function prototype
- Notes : description of operation, context, details to pay attention to, limitations
Typefaces
The reference entries use typefaces in the following way:
| Format | Meaning | Example |
|---|---|---|
| italic | variable | var or $var |
| bold | constant | true |
| fixed | code phrase | FindMedia(op_count,location) |
Expressions
Formula functions take expressions as well as literals as arguments. For example, a column called x might contain strings which are actually numbers: “45.6”, “77.12”, “45.91”, … To find the average of the values in that column requires the strings be converted to numeric scalars. The formula function double does this. You could then write average(double(x)). In this case, an expression is passed to average.
Reference entries describe expressions using the expr keyword. For example, double expr means “expression evaluating to double”. More generally, <type> expr if more than one Incorta type can be passed as an argument. Square brackets [] indicate an Array of values such as double[] expr.
Incorta Types
Incorta types have the same characteristics as the Java types. They are:
string— series of charactersdate— contains month, day and yeartimestamp— contains month, day, year and timeint— 32 bit signed integer typelong— 64 bit signed integer typedouble— 64 bit floating point type