What's New
Search Results for

    Show / Hide Table of Contents

    Creating Calculated Fields

    The Dashboard Designer provides the capability to create calculated fields that allow you to apply complex expressions to data fields that are obtained from the dashboard's data source. You can use these fields in data visualizations as regular data source fields.

    Creating a Calculated Field

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

    To create a calculated field, select the required data source (and the required DAS report/data member, if applicable) in the Data Source Browser and click the Add Calculated Field button in the Ribbon's Data Source tab...

    CalculatedFileds_AddCalculatedFieldButton_Ribbon

    ...or right-click the Field List and select Add Calculated Field in the context menu.

    CalculatedFileds_AddCalculatedField_ContextMenu

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

    CalculatedFileds_ExpressionEditor

    You can use the following elements in expressions.

    • Functions

      Note

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

    • Operators

    • Columns
    • Constants
    • Parameters

    After the expression has been specified, click OK. This displays a new calculated field in the data source structure.

    CalculatedFileds_DataSourceStructure

    Now you can specify the required calculated field type, change its default name, etc.

    Editing a Calculated Field

    To edit a calculated field, use its context menu.

    CalculatedFileds_FieldContextMenu

    This menu contains the following items.

    Item Description
    Edit Expression... Invokes the Expression Editor dialog, which allows you to change an expression for an existing calculated field.
    Field Type Specifies the type of the calculated field.
    Rename Changes the calculated field name.
    Delete Removes the existing calculated field from the data source.
    In This Article
    Back to top 2025 - ReportsNow Inc Download as PDF