How do I create a custom calculation?

To create a new custom calculation, go to the Analyze tool page and:

1. Run a query using the indicators you wish to use as constituents for your calculations.
2. Click on the ‘Calculations’ icon at the top of the visualization window. A dialogue box opens.
3. Give a name to your new indicator in the ‘Calculation Name’ field so it is easily identifiable in your visualization.
4. Click on the indicators you initially selected (listed under ‘Fields and Calculations’) to add them to the formula.
5. Add mathematical operations such as add, subtract, multiply or divide. For example, “(Indicator 1 + Indicator 2) / (Indicator 3 - Indicator 4)”. If you wish, add custom logic using Javascript language (create conditional statements, use logical operators like &&, ||,! etc.).
6. Click ‘Create’ to generate the new calculated indicator. It will be shown on your current visualization alongside the indicators used to create it.

The new calculation can be manipulated on the visualization (e.g. set a new axis, new color) just like any other. The ‘Valid’ sign located above the ‘Create’ button will turn into ‘X Invalid or missing symbol’ error message if your calculation is incomplete.

Note: Although the platform provides a great amount of flexibility to analysts with respect to creating custom calculations, it is up to you to make sure that the query actually makes sense.

Updated on: 24/09/2025