The requested page is not available for the requested platform. You are viewing the content for Default platform.

Calculated Fields

  • 2 min to read

The Web Dashboard control 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.

Note

Note that 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 both in the Data Sources page and from the Binding panel.

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

    wdd-calculated-field-create

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

This invokes the Edit Calculated Field dialog, which allows you to 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.

wdd-calculated-field-editor

The following elements are available for creating expressions:

Element

Description

Fields

Contains available fields and dashboard parameters.

Constants

Contains boolean variables.

Functions

Contains different types of functions including aggregate.

Note

To learn how to use Aggregate functions, see Aggregations. The Expression Operators, Functions and Constants topic lists common functions (DateTime, Math, String, etc.) supported by expressions.

Operators

Allows you to select operators from the list.

After creating the expression, click Save to creates a new calculated field and display it in the Field List. This type of a field is indicated with the f glyph.

wdd-calculated-field

Edit 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 wdd-icon-edit-query icon).
  • In the Binding section, 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