Create a formula in a Model

You create formulas by combining standard functions and operators, column names, and constant values.

Anyone who can create a Model can add a formula to it. Formulas are not reusable; the formula you create is associated only with the Model it belongs to. A complete list of available formulas and examples of each is available in the Formula function reference.

You can create a formula in a Model by using the Formula Builder. When you do this, the result of the formula gets added to the Model as a column. Use these steps to create a formula:

  1. Create a new Model.

  2. Select Formulas from the top menu and click Add formula.

    Create a new formula for your Model
  3. Type your formula in the Formula Editor.

    Use the Formula Editor
    Formula elements are color coded by type and can include the formula operators and functions (blue), the names of columns (purple), and/or constants (black).
  4. If you want to change what your formula returns, use the Advanced settings gear icon.

    Depending on your formula, you may be able to change:

    • Data type: Determines the type of data that the formula generates. For example, use date for an add_days formula.

    • Measure or attribute: Determines if the output of the formula is a measure or an attribute. For example, choose attribute for a formula that generates age groups, and choose measure for a formula that generates profit.

    • Default Aggregation: Determines the default aggregation of the formula output. For example, choose min to see minimum profit.

    Advanced settings in the Formula Editor
  5. Name the formula by selecting on its title and typing the new name. Select Save.

    For examples of how to use the TS_GROUPS variable as a LIST TYPE, see Examples of ts_groups as a list type.


Was this page helpful?