Expression editor
Use the expression editor to build simple and complex formulas. You can access it for any derived field, derived metric, join condition, or filter. Any expression consists of tokens, separated by special operators.
Operator |
Description |
---|---|
+ |
Addition |
- |
Subtraction |
* |
Multiplication |
/ |
Division |
< |
Less than |
> |
Greater than |
<= |
Less than or equal |
>= |
Greater than or equal |
( ) |
Defines the order of operations to be executed |
A token can be a:
-
Specific value, such as a number, string or date
-
Function
-
Metadata object (record field, metric value, parameter, constant) existing in the expression
-
Direct expression and other objects.
Tokens are shown below as green rectangles.
A token may have subtokens, which define the arguments of the
parent
token. Each subtoken may have child subtokens. When a token
is moved, copied, or deleted, it takes all child subtokens (recursively) with
it.
You can also enter the typed value by selecting the corresponding item from the tree or by direct entry. In case of direct entry, the system prompts you to select an option: String or DateTime.