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_create1
  3. Name this calculated field.
  4. Select a function you want to use in this calculated field. cf_create2
  5. Select the column which you want to apply this function.
    cf_create3 You can apply a column from another model through the relationships already defined in this model. cf_create4
  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. cf_update
  2. Choose "Edit".
  3. You can edit the Name or expression of this calculated field cf_update2

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". cf_update
Remember to deploy your changes

Deploy​

Please esure you press the "Deploy" button on the Navbar to synchronize any modifications in the Modeling page with our Wren Engine.

If there are any new changes, navbar will show Undeployed changes message. undeployed

If all changes have been deployed, navbar will show synced message. deployed