Configure a calculated field

You have the possibility to add calculated fields. They allow you to create new fields, with the possibility to use many formulas and to apply them on other fields present in your data source.

Add a calculated field

To add a calculated field to a dashboard, right-click on the name of your data source and select "Add calculated field".

You can also calculate a field from the data view via the f(x) button.

Configure the expression of the calculated field

An "Expression Editor" dialog box is opened. You can specify the expression that will be used for your calculated field.

In your calculated field you can use:

• line by line expressions.

• aggregate calculations using the aggregation functions available in the editor.

• aggregate calculations at an intermediate level by combining the use of the aggr() function and aggregation functions. For more details , see the relevant section.

• window calculations by combining the use of the w function, and aggregation functions.

You can add a comment to the expression that start with /* and end with */

Rename a calculated field

Select the calculated field, right-click and click on "Rename".

Change the field type

Select the calculated field, right-click and click on "Field Type". Then select your type.

Delete a calculated field

Select the calculated field, right-click and click on "Delete".

Duplicate a calculated field

Select the calculated field, right-click and click on "Duplicate". You can do what you want on the new calculated field.

Calculated field in data view

The calculated field you have created can be identified by its color, which is different from the initial columns in the data view.