Calculated Fields

The Dashboard Builder provides the capability to create calculated fields that allow you to apply complex expressions to data fields obtained from the dashboard's data source. As a result, you can use these fields in data visualizations as regular data source fields.

• Creating a Calculated Field
• Editing a Calculated Field

Creating a Calculated Field

You can create calculated fields both in the Data Sources page and from the Binding panel.

• Go to the dashboard menu and go to the Data Sources page. Select a required data source, then select a query and click the Add Calculated Field button.



• Open the Binding panel, go to the Binding section and click the Add calculated field button (the icon).

  

This action invokes the Edit Calculated Field dialog, which allows you to specify an expression that will be used to obtain calculated field values. Here you can construct the required expression.

• Use the Name option to change the default field name.
• Use the Field Type option to specify the required calculated field type.

The following elements are available for creating expressions.

• The Functions section includes different types of functions including aggregate.
• The Operators section allows you to select operators from the list.
• The Fields section contains available fields and dashboard parameters.

After creating the expression, click Save. This creates a new calculated field in the Field List, indicated with the f glyph.

Editing a Calculated Field

You can configure calculated fields both in the Data Sources page and from the Binding panel:

• To edit the created field using the Data Sources page, click the calculated field's Edit button (the icon).
• In the Binding section, select the calculated field you want to edit and click the Edit button (the icon).

This invokes the Edit Calculated Field dialog. You can change the calculated field's name, type or edit the current expression.

To delete the calculated field, use the calculated field's Delete button (the / icons).