Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen

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 .

Note

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

Tip

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.


Tip

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.

Info

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 .

Note

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
Anchor
UsingVariablesinReportandViewTitles
UsingVariablesinReportandViewTitles

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
Tip

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

Note

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

...