APPLYING VARIABLES and Filters IN INDICATOR Formulas

    You can leverage variables and filters in indicators formulas.

    In such dynamic definition, the Views including the Indicator will be recalculated after every modification done to variable.

    For more information about Displaying Indicators - continue by Displaying Indicators .

    Icon

    Prefix variable with '@' in order to refer to variable value.

    Icon

    Report Variables could also serve as a basic planning and forecasting tool. Analyst can setup formulas for various versions or time intervals and then change variables values in order to observe impact of such changes.

    APPLYING VARIABLES and Filters IN TIME INTERVAL SETTINGS

    You can leverage variables in time interval settings. Variable has to have proper date format in order to be able to be used as date interval.

    Icon

    Select Custom interval to apply variables.

    In such dynamic definition, the Views including the Time interval will be recalculated after every modification done to variable.

    For more information about Setting Date Interval - continue by Setting Date Interval .

    Icon

    Prefix variable with '@' in order to refer to variable value.

    USING VARIABLES IN VIEW FILTERS

    For more information about Setting Filters on views - continue by Using Filters .

    Variables can also be used in view filter.

    1. Create new variable, for example"var".
    2. Add filterto view.
    3. Type ${@var} and click on Custom value: ${@var} to confirm.
    4. Close the window and Save filter and report.

    USING VARIABLES IN REPORT AND VIEW TITLES

    You can use variable values in reports' and views' titles. To do so:

    1. Click on Title you would like to modify
    2. Type @ followed by Variable Name. For example: 'Patient Details: @patient_name'.
    3. Click Save or hit Enter
    Icon

    This feature is handy especially when creating Global Filters or drill-throughts with URL Appearance.

    Value of an additional filter can be also displayed the same way. In most cases, it is necessary to change the code of the filter.

    When the value of the variable or filter is not set, nothing will be displayed in the title.

    USING VARIABLES IN INDICATOR NAMES

    Icon

    This function is available since BellaDati 2.9.7.

    It is possible to use variable values in indicator names. To do so:

    1. Click on Indicator you would like to modify
    2. Type @ followed by Variable Name. For example: 'Value as of @date_variable'.
    3. Click Save or hit Enter

    • No labels