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.

A token can be a:

• Specific value, such as a number, string or date

• Function

• Variable

• Metadata object (record field, metric value, parameter, constant) existing in the expression

• Direct expression and other objects.

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.