Adding a Calculated Field - Reporting Dashboards - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Reporting Dashboards

Platform
OnBase
Product
Reporting Dashboards
Release
Foundation 23.1
License

Calculated field can be added to data providers in the Web Dashboard Designer. To add a calculated field to a data source from the Data Sources screen:

  1. Click Add Calculated Field. The Edit Calculated Field dialog box is displayed.
  2. Enter a name for the calculated field in the Name field.
  3. Select the type of calculated field from the Field Type drop down menu. Available types include String, Integer, Decimal, Boolean, DateTime, Object, and Auto. By default, Auto is selected.
  4. Enter the desired function. Various fields and variables can be selected from the list below the expression field.
  5. Once you have entered the function, click Save to store the calculated field. The dialog box is closed.

Calculated fields can be edited by clicking the pencil icon next to the field, or deleted by clicking the trash can icon.