Skip to main content

Working with Calculated Fields

Calculated fields empower you to generate custom columns by employing expressions (similar to formulas in spreadsheet software such as Excel and Google Sheets) to compute values for the new column.

List of expressions​

See a full list of expressions supported in calculated field.

Create a calculated field​

  1. Go to the diagram of the model you want to create a calculated field.

  2. Click the "+" icon next to the "Calculated Fields" section.

    cf_2

  3. Name this calculated field.

  4. Select a function you want to use in this calculated field.

    cf_4

  5. Select the column which you want to apply this function.

    cf_5_1

    You can apply a column from another model through the relationships already defined in this model.

    cf_5_2

  6. Click "Save" to create.

Update a calculated field​

To update calculated field settings in a model:

  1. Click the "..." icon next to the calculated field on the model diagram.
  2. Choose "Edit".
  3. You can edit the Name or expression of this calculated field

Delete a calculated field​

To delete a calculated field:

  1. Click the "..." icon next to the calculated field on the model diagram.
  2. Choose "Delete".
Remember to deploy your changes

Deploy​

Please press the "Deploy" button on the navigation bar to synchronize any modifications in the Modeling page.

The navigation bar will show an Undeployed changes message if there are any new changes. undeployed

The navigation bar will show a synced message if all changes have been deployed. deployed