Create a formula indicator

Use formulas to create a new indicator based on the historic data of other indicators or based on analytical functions.

Before you begin

Role required: pa_admin, pa_power_user, or admin

About this task

Formulas are often used to:
  • Calculate ratios and percentages
  • Combine data from different applications
  • Build predictive indicators based on historic performance

Procedure

  1. Navigate to Performance Analytics > Indicators > Formula Indicators.
    The 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.
  2. In the Formula section of the Indicators form, click the Browse for an indicator link.
  3. Select an Indicator to display.
  4. (Optional) Select a Breakdown and breakdown Element to filter the indicator data.
    You can select an additional breakdown and breakdown element to further filter the data.
  5. (Optional) Select a Time series to use when aggregating the data.
  6. Click Select.
    The Formula field is automatically populated based on your selections.
  7. 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.