Use formulas to create a new indicator based on the historic data of other indicators
or based on analytical functions.
are often used to:
Role required: pa_admin, pa_power_user, or admin
- Calculate ratios and percentages
- Combine data from different applications
- Build predictive indicators based on historic performance
fields of a formula indicator are similar to an automated indicator except for
the condition. Formulas can consist of other indicators, constants, and time
series, or any combination of these.
In the Formula section of the Indicators form, click the Browse for
an indicator link.
Select an Indicator to display.
Select a Breakdown and breakdown
Element to filter the indicator data.
You can select an additional breakdown and breakdown element to further filter
Select a Time series to use when aggregating the
The Formula field is automatically populated
based on your selections.
Modify the Formula as needed. Enter any operators or
numbers to include in the formula. Use valid operator symbols, such as +, -, /,
%, >, <.
For example, if you want to calculate the average age of open incidents based
on summed age of open incidents and number of open incidents, you could use
this formula: [[Summed age of open incidents]] / [[Open incidents]] / 24
Formulas support multi-level breakdowns. For indicators that have
Collect breakdown matrix enabled, it is possible
to drill down to the second level in the detailed scorecard on the
Breakdowns tab. For example, Closed incidents by
Category, and then by Priority, or vice versa.