Custom Formulas

​

Adding a Custom Formula

​

Supported charts

Custom Formulas can be used on the following charts:

• KPIs
• Bar Charts
• Line Charts
• Combo Charts
• Area Charts
• Pie Charts
• Heat Maps
• Funnels
• 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(price)

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