Guide
Quite often, creating the required visualisation requires transforming or combining the source data. This can be done using calculations, which enable you to leverage powerful techniques for data manipulation.
Every visualisation parameter (dotted box) in the visualisation pane allows you to do some calculations (like aggregation or grouping) via the basic parameter configuration settings.
For other, more complex cases, you will need to use the calculation box.
Using calculations
New calculations can be added using the "+" sign, or by clicking the parameter box. The "New Calculation" popup will appear.
An existing parameter's calculation can be modified via the parameter configuration.
It utilizes autocomplete and while being used, the source settings and available fields sections are replaced with a guide to the available functions, as well as samples of how they can be used.
The available functions are as follows:
Logic functions
Numeric functions
Text functions
Date functions
The syntax used for report calculations is different from the syntax used for database Formulas