Creating Custom Calculations

When creating a calculated measure, there are several types of standard calculations listed, including Sum, Average, Ratio, etc.

If you need to use a calculation not included on this list, choose Custom Equation.

When Custom Equation is selected, each of the measure’s disaggregated measures is listed with a letter.

To create the custom equation, click Edit Data.

In the Custom Equation field, enter the equation using standard algebraic characters, as a function of the letters of the disaggregated measures. Note that each disaggregated measure must be included in the equation, and capital letters must be used.

After saving the data, the graph will be generated. If you return to the data editor, you can see each calculated value.