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 .

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

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.

When subset is selected, custom members can be also filtered

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.

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 .

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

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

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