You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

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

There are four types of indicators defined by formula:

  • 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

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

You can edit Formulas 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.

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

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

See Formula Reference Guide for complete specification of available formulas.

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.

Editing Formulas

Click on Indicator name in the report to open Indicator settings window.

Aggregation in Calculated Indicators

Notice that Indicators setting dialog of Calculated Indicator lacks specification of Members and Time aggregation.

This is because you can define it programatically in combination with additional functions.

Member aggregation can be defined by suffixing Indicator with:

  • @SUM for aggregation
  • @AVG for average
  • @MIN for minimum
  • @MAX for maximum
  • @DC for distinct count

Example: use M_SALES@SUM to obtain Total Sales or M_PRICE@MIN to find the lowest price.

Time aggregation can be defined by suffixing Indicator with:

  • @SUMT for aggregation in time
  • @AVGT for average in time
  • @MINT for minimum in time
  • @MAXT for maximum in time
  • @DCT for distinct count in time

Example: use M_SALES@SUMT to obtain Total Sales in time or M_PRICE@MINT to find the lowest price in time.

Memeber and Time aggreagation can be combined togeter.

Visit Formula Reference Guide to learn more about member and time aggregation in formulas.

Next Steps

  • No labels