Versions Compared

Old Version 19

changes.mady.by.user Radek Micka

Saved on

compared with

New Version 20

changes.mady.by.user Martin Trgiňa

Saved on

Key

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

Formulas and scripts are used to create Calculated (derived) Indicators from basic indicators in BellaDati calculated indicators from indicators inside of BellaDati dataset.

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

Note

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.
Info

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

 

 

Tip

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

 

 

See Formula Reference Guide for complete specification of available formulas.

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
Info

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

 

 

Visit Formula Reference Guide to learn more about aggregations in formulas.

Next Steps

Sv translation
languagesk

 

Note

Táto stránka je do Slovenčiny preložená len čiastočne!

Vzorce sú používané na vytvorenie vypočítaných (odvodených) ukazovateľov zo základných ukazovateľov v BellaDati. 

Existujú štyri typy vypočítaných ukazovateľov:

  • Vypočítané ukazovatele definované na úrovni skupiny dát. Tieto sú všetky dostupné v reportoch založených na danej skupine dát.
  • Vypočítané ukazovatele definované ad hoc na úrovni pohľadu v reporte. Tieto sú dostupné len pre daný pohľad a delia sa do dvoch kategórií:
    • Dodatočné ukazovatele definované vzorcom
    • Vzorce na časovej ose

Vytváranie vzorcov

Note

Predtým ako budete pokračovať so vzorcami sa uistite, že ste oboznámený s časťou zobrazovanie ukazovateľov.

Môžete upravovať vzorce len pri vypočítaných ukazovateľoch. Na vytvorenie vypočítaného ukazovateľa: 

  1. Prejdite na okno nastavení ukazovateľov
  2. Zadajte názov a kliknite na zelené plus vedľa poľa Nový ukazovateľrovide name and click on green plus button next to New Indicator input.
  3. Kliknite na Nastavenia ukazovateľa
  4. Vytvorte/upravet vzorec v novom okne
Info

Vypočítané ukazovatele sa dajú rozoznať podľa symbolu kalkulačky hneď vedľa ich názvu.

 

 

Tip

Môžete použiť autocomplete alebo zoznamy dostupných funkcií pre zrýchlenie tvorby vzorcov.

 

 

Pre bližšie informácie prejdite na sprievodcu tvorbou vzrocov.

Úprava vzorcov

Pre otvorenie okna Nastavenia ukazovateľa kliknite na názov ukazovateľa v reporte.

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.

Kam ďalej