Managing the indicators is a part of BellaDati's data warehouse modelling. Values of particular indicators represent the point of the examination interest. Indicators have usually numeric values (wages, costs, incomes etc.).
We are distinguishing two types of indicators:
- data set indicators are defined within the data set and are available as musters for report indicators. Another settings (like aggregations, appearance, etc.) are not supported. Simply said, the data set indicators represents a raw numerical value (in the OLAP language it is a fact) with basic attributes - name, unit and rounding mode. Values of these indicators are straightforwardly stored in BellaDati's data warehouse directly from imported data.
- report indicators are created in the report from the data set indicators or ad hoc. Unlike the data set indicators, report indicators are supporting wide range of various settings - aggregations, appearance, conditional formating, extended formula support with etc. Report indicators can contain also non-numerical values.
- Formula indicators: Their value is calculated according assigned mathematical formula or another operation. Values of indicators created by formula are not imported to data set, they are evaluated from formula. Formula indicators can be defined on report level as well. See Formula Reference Guide for details.
Creating data set indicator
New indicator can be created by following ways:
- Within data set (data set indicators)
- During the import
- Transforming an attribute into an data set indicator
- When inserting data row manually
Data set indicator settings
When you click on the name of particular indicator name in the data set, you can adjust a lot of different parameters of this indicator. You can define or change:
- Indicator name
- ETL column name
- Indicator unit
- Format (see chapter below)
- Type of rounding
- Assign indicator to group
- Formula. This function is available only when the indicator is defined by formula or when creating new one.
Those adjustments will take effect in each occurrence of this indicator (data sets, reports, dashboards).
Format is a useful tool to:
- insert separate characters into indicator
- insert additional characters into unit
- adjust number of decimal positions
Indicators without adjusted decimal format are displayed with a comma after each three positions of digits (thousands, millions etc.) and with dot between whole number and decimal places. You can use prepared help window in BellaDati for some examples, how to define the decimal format. Basic description is also in the table below:
Represents one digit
Separator of digit places (thousands, millions etc.). It's displayed as a comma in English localization.
Decimal separator. It's displayed as a dot in english localization.
Multiply value by 100 and add % symbol
If you want to display any of described operational character (., #), you have to place it between '' characters. It's a useful function, when you deal with shortcuts which ends with "." character.
Decimal format examples:
$1 234, 56
$1 234 k
Click on the cross icon (Remove link) at the end of corresponding row in indicators' list. Then confirm the removal in popup.