Skip to main content

Calculated Fields on the Web

  • 2 minutes to read

The Web Dashboard control supports calculated fields. Calculated fields allow you to apply 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.


Calculated fields are not supported for the OLAP data source.

You can add a new calculated field based on the existing data source fields after you have created a data source.

Create a Calculated Field

You can create calculated fields in the Data Sources page or Binding panel of the dashboard item menu.

The Data Sources Page

Go to the dashboard menu and open the Data Sources page. Select a data source (and a query/data member, if applicable) and click the Add Calculated Field button to create a calculated field.

The Data Sources Page - Add Calculated Field

The Binding Panel

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

The Binding Panel - Add Calculated Field

This invokes the Edit Calculated Field dialog that allows you to construct an expression for the field

The Edit Calculated Field Window

You can specify the following option for a calculated field:

Changes the default field name
Field Type
Specifies the calculated field type

The following elements are available for expressions:

Lists available fields and dashboard parameters.
Lists Boolean variables.

Lists different types of functions including aggregate.

You can find a list of common functions supported by expressions in the following topic: Expression Operators, Functions and Constants.

Lists available operators.

You can add a comment to your expression to explain it and make the expression more readable. Comments are multi-line and begin with /* and end with */.

After you created the expression, click Save to add a newly created calculated field and display it in the Field List. The f glyph indicates that this field is a calculated field:

Calculated Field

Edit a Calculated Field

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

The Data Sources Page
Click the calculated field’s Edit button (the wdd-icon-edit-query icon)
The Binding Panel
Select the calculated field you want to edit and click the Edit button (the wdd-icon-editCalcField 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 wdd-icon-delete-query / wdd-icon-deleteCalField icons).

See Also