Create a formula indicator to produce a new computed score from one or more other indicators. Besides indicator scores, the formula can include calculations such as the gap between an indicator score and the indicator target.

Before you begin

Role required: pa_power_user, pa_admin, 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.

The fields of a formula indicator are similar to the fields of an automated indicator. However, instead of Source, Additional Conditions, and Collection properties, a Formula Statement is defined. Formulas can consist of other indicators, constants, variables, and time series, or any combination of these elements.

Note:
  • You must have a subscription for Performance Analytics to create indicators.
  • If you are using domain separation, the indicator is created in the domain that you are currently in.

Procedure

  1. Use one of the following navigation paths:
    • If you are on an upgraded instance that has not migrated to Platform Analytics, navigate to All > Performance Analytics > Indicators > Formula Indicators and select New.
    • If you are on a new instance or have migrated to Platform Analytics, navigate to All > Platform Analytics Administration > Indicators > Formula Indicators and select New.
  2. In the Name field, give the indicator a descriptive name, such as Average duration of open incidents.
  3. In the Calendars field, select either the standard calendar or a business or fiscal calendar group.
  4. If you selected a business or fiscal calendar, select the calendar frequency.
    At least one indicator in the formula must match the specified calendar frequency. The choice of calendar frequencies depends on the setting of the business calendar entries or fiscal calendar schedules.
    For example, the Gregorian calendar has Quarter, Month, Week, and Year frequencies. If you are using the Gregorian calendar, you must choose one of these frequencies.
    Calendar frequency options for the Gregorian calendar
  5. If you prefer that the score of this indicator increases or decreases over time, select Maximize or Minimize in the Direction field.
    Analytical tools and graphic displays use this Direction with this indicator.
    Tip: Set a direction whenever you can. All key indicators should be set to Maximize or Minimize.
    ValueUse case
    Maximize Select if an increase in this indicator score is desired. For example, consider selecting Maximize for an indicator that shows revenue. Analytic tools and graphic elements reflect that an increase in this indicator score is good and a decrease is bad.
    Minimize Select if a decrease in this indicator score is desired. For example, consider selecting Minimize for an indicator that shows costs. Analytic tools and graphic elements reflect that a decrease in this indicator score is good and an increase is bad.
    None Select if the direction of change in this score does not matter to your business.
  6. Define the Formula for this indicator.
    1. To use a calculated value in the formula, click Browse for a method (Repeatable).
      A dialog opens for you to insert a method from PAFormulaUtils() into the formula. This API returns the calculated value for an indicator. For more information about using this API, see Get analytics methods in formulas.
      List of descriptive labels of methods in the "Add a method to the formula" dialog box, with Get global target gap of the specified indicator" highlighted.
    2. To put the score of an indicator in the formula, click the Browse for an indicator link and fill in the dialog (Repeatable).

      You could add indicators manually. However, by using the Browse for an indicator function, you ensure that you have the proper notation for indicators and breakdown elements.

      After you save the formula indicator, the indicators in the formula appear in the Contributing indicators related list. If you included any formula indicators, their contributing indicators are also listed.
    3. Add mathematical operators and symbols to the Formula as needed.

      Enter any operators or numbers to include in the formula. Use valid operator symbols, such as +, -, /, %, >, <. You can also add more indicators to the formula. For example, to calculate the average age of open incidents based on summed age of open incidents and number of open incidents, use the following formula: [[Summed age of open incidents]] / [[Open incidents]] / 24

      To specify a data collection period in the formula, you can use the variables score_start and score_end to refer to the start and end of the data collection period, respectively. However, see the caveats in Changes to score_start/end because of different user time zones.
      Warning: Try not to use GlideRecords or GlideAggregates in Performance Analytics scripts or formula indicators. While sometimes you must use these operations to get what you want, they are expensive, potentially running hundreds of thousands of times. Be certain that no alternative exists before you use them.
  7. In the Access control tab, set whether to save this indicator to the library and whether to limit the visibility of the indicator by user, group, or role.
  8. In the Other tab, set miscellaneous properties.
    These properties apply to the entire formula indicator.
  9. (Optional) In the Forecasting tab, set the forecast method, the number of data collection periods to forecast, the amount of historical data to base the forecast on, and the upper and lower limits of forecast values.
    For more information, see Performance Analytics scores forecasts.
  10. Expand the context menu and click Save.

    Save option in the context menu
  11. To apply a breakdown to the entire formula indicator, click Manage breakdowns at the top of the page.
    By default, you can apply only breakdowns that are configured for every contributing indicator in the formula.
    Note: The system property com.snc.pa.formula_indicator_valid_breakdown controls this behavior. By default, it is true. Changing it to false allows you to apply a breakdown to a formula indicator when at least one contributing indicator uses that breakdown. Attempts to view scores for unsupported breakdowns in a widget, the Analytics Hub, or KPI Details result in a warning message instead of a value.

    You cannot select a breakdown element in the formula indicator record. You can select the breakdown The breakdown can only be used interactively, meaning on the Analytics Hub, KPI Details, appropriately configured widgets, and breakdown dashboards. For information about using the Manage breakdowns tool, see Assign and map breakdowns.

Example: Incident Backlog Growth

As an Incident Manager, you want to improve the efficiency of incident resolution. You already track new and resolved incidents as the Number of new incidents and Number of resolved incidents indicators. However, these indicators do not tell you if you are achieving your goal of improving incident resolution.

You need a new Backlog Growth KPI to measure the volume of outstanding incidents. To implement this KPI, you create a formula indicator named Incident Backlog Growth, with the following formula:
[[Number of new incident]] - [[Number of resolved incidents]]

Incident backlog growth indicator record.
By turning on Show in library, you make the indicator visible in KPI Details. In the information panel on KPI Details, you can see the formula used in the indicator.
The Incident Backlog Growth indicator in KPI Details