Expression editor

Use the expression editor to build simple or 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 such as +, -, *, /, <, >, <=, >=, <>, ), and (.

A token can be a:

  • Specific value, such as a number, text, date, or other

  • Function

  • Variable

  • Metadata object (record field, metric value, parameter, constant) existing in the model. Tokens are shown below as red rectangles.