Create a calculated field

In addition to the fields with values based on columns from the data source, you can create fields that use functions and operators of different types:

  1. Open the Visualization page in the console.

  2. Open the workbook and select the dataset in which you want to create a calculated field.

  3. On your dataset page, open the Fields tab.

  4. To create a new field, click + Add field and enter the Field name. Stay on the Formula tab.

  5. Select one or more existing fields from the list on the left.

  6. Use the editor to combine these fields the way you need.

    Tip

    Click the Reference button to see the information on all the available functions you can use in your formulas.

  7. (optional) Check the Don't display in wizard box to hide the field by default.

  8. Click Create.

  9. Click Update fields to see the new field on the list.

  10. Click Save in the upper-right corner of your dataset page.

See also