Here you can create custom formulas for the chosen account.
Further information on creating custom formulas can be found in the training chapter on Custom Figures.
Description
Formula name
The name of the custom formula. You may only use a name that is not a name of another custom metric or formula.
Elements of formula
Click on elements the corresponding elements to use them in the formulas. You may use:
Predefined metrics: Can be edited within a formula. The adapted metric is only available within this formula.
Custom metrics: Can be edited within a formula. The adapted metric is only available within this formula.
Predefined formulas
Custom formulas
Operators
Numbers
Format
Here you can adapt the output of the result in the data table.
Standard: The result is not formatted.
Time: The result is displayed in the format [hh:mm:ss].
Currency: The currency symbol set in the system configuration is added.
Distribution: The symbol "%" is added.
Comparison: The symbol "%" is added.
Visualization
Within the data table, different visualizations can be helpful when interpreting data.
None
Traffic lights: Shows a red (=bad), green (=good), or yellow (=medium) dot. The colours are chosen automatically based on the actual values of the formula; anyway, you can also adapt the value ranges for the colours (see "Threshold values").
Heatmap: Shows five differently bright blue tones. The darker the colour, the better the value.
The colours are chosen automatically based on the actual values of the formula; anyway, you can also adapt the value ranges for the colours (see "Threshold values").
Bars
Threshold Values
(only available if you choose Traffic lights or Heatmap)
The colours are chosen automatically based on the actual values of the formula. This can be adapted here.
Example: Automatic vs. manually specified colouring
Target Value
(only available if you choose Traffic lights or Heatmap)
Defines whether the target is preferably high or low value.
Max: Using Traffic lights, high values are green and low values are red. Using Heatmap, high values are dark blue, and low values are light blue.
Min: Using Traffic lights, high values are red and low values are green. Using Heatmap, high values are light blue and low values are dark blue.
Decimal Places
Defines how many decimal places are put out. If "0" is set, values are rounded off. If no decimal places are set, the values are not rounded off.
Description
The description is shown in the overview of custom formulas, and in the Configure Metric window:
Was this article helpful?
Thank you for your feedback! Our team will get back to you