Calculations Pane
SuperTables offers the possibility to create (SuperTable only) calculated fields. The extensions API transfers summary data only, so ratios and percentages are transferred as numbers instead of calculations. There is nothing wrong with that when you are presenting your data on a row level, but when you use the custom grouping options of SuperTables you will be presented aggregated values of the percentages and ratios that will not match the correct values.
This is where the SuperTables Calculated Fields come in handy. With this simple Calculation editor you can easily perform simple mathematical calculations which use operands like Add, Subtract, Divide and Multiply. So for instance, if you have Profit and Sales columns in your dataset you can create a calculated field like SUM(Profit)/SUM(Sales) to calculate the Profit Ratio which will also aggregate properly when using custom groups.
Calculations also have access to the same If-Else Formula Editor as the Formulas tab, allowing for further customization of your SuperTables measures.
To setup a calculation follow this guide: Setting up Calculations
Last updated