Custom Formulas allow you to visualize custom aggregations on charts.
Adding a Custom Formula
Custom Formulas can be used on the following charts:
- Bar Charts
- Line Charts
- Combo Charts
- Area Charts
- Pie Charts
- Heat Maps
- Spider Charts
Use a Custom Formula
To use a custom formula, go to the Data tab and click on the “fx” button to the right of the aggregation configuration section.
In the input field, write your formula using SQL aggregation functions.
Here are some examples of custom formulas:
SUM(revenue) - SUM(cost)
Edit or Remove a Custom Formula
You can edit the formula by clicking on the icon to the left, and you can delete the formula by clicking on the icon to the right
Rename the Formula
You can rename the label that appears in tooltips and legends in the Data Labels section of the Format tab