Versions Compared

Old Version 3

changes.mady.by.user Unknown User (jurbancik)

Saved on

compared with

New Version 4

changes.mady.by.user Peter Fedorocko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Formulas serve for calculating indicators are used to create Calculated (derived) Indicators from basic indicators in BellaDati.

...

  • Formula indicators defined on data set level. These are available in all reports based on this data set.
  • Formula indicators defined ad hoc on view level in each report. These are available only for the particular view and belong to the two subcathegories:
    • Additional formula defined indicators
    • Formulas on date/time axis

Creating Formulas

Note

Make sure that you are familiar with Displaying Indicators section prior proceeding with Formulas.

You can create/edit Formula only of Calculated Indicators. To create Calculated Indicator:

  1. Go to Indicators Settings dialog.
  2. Provide name and click on green plus button next to New Indicator input.
  3. Click on Indicator Settings.
  4. Create/edit formula in Formula window.
Info

Calculated indicators can be determined by calculator symbol next to indicator name.

ilupng
newindicator
Tip

You can leverage autocomplete or lists of availabe functions for rapid formula development.

ilupng
newindicatorformula

See Formula Reference Guide for complete specification of available formulas.

Note

Indicators defined by formulas have currently the following limitations in BellaDati:

  • Sorting by formula indicators is not possible (exception: attribute counts and distinct counts).
  • You cannot refer to already existing formula indicators from other formula indicators.
Warning

Will be completed soon...

Next Steps