Adding Custom Calculated Fields - Reporting Dashboards - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - external

Reporting Dashboards

Platform
OnBase
Product
Reporting Dashboards
Release
Foundation 24.1
License

Calculated fields allow you to apply custom expressions to data obtained from a data source. Calculated fields can be used as any other field. For example, calculated fields can be used as a target value for comparison in dashboard items.

To add a calculated field:

  1. In the data provider pane, right click on the data provider for which you would like to create a calculated field.
  2. Select Add Calculated Field.
  3. The Expression Editor is displayed. For more information on the Expression Editor, see Using the Expression Editor.
  4. Enter the desired function. Functions, aggregate functions, operators, fields, constants, and parameter elements can be used.
  5. When finished adding the function, click OK. The calculated field is displayed in the data provider pane.