Versions Compared

Old Version 7

changes.mady.by.user Peter Fedorocko

Saved on

compared with

New Version 8

changes.mady.by.user Peter Fedorocko

Saved on

Key

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

...

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.

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
Info

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
Info

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

Note

Memeber and Time aggreagation can be combined togeter.

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

Next Steps