Create a formula indicator
-
- UpdatedJan 30, 2025
- 8 minutes to read
- Yokohama
- Performance Analytics
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
- 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.
Procedure
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.


Related Content
- Get analytics methods in formulas
To insert a calculated value from the Analytics Hub into a formula, use a method in the formula.
- Prevent a contributing indicator in a formula from following breakdowns
You can select contributing indicators in a formula to not be broken down. When a user applies a breakdown to the formula indicator, the breakdown does not apply to these indicators.
- Breakdown matrices in formula indicators
Formula indicators inherit breakdown matrices from indicators in the formula.
- Applying time series to result or to contributing indicators
For a formula indicator, a time series aggregation can apply either to each indicator in the formula individually or to the formula result.
- Detect indicators with no scores in a formula
As the formula creator, you can handle contributing indicators that have null scores. First set the formula indicator to calculate the formula even when it contains a null score.
- Indexing multiple indicators in a formula
You can write a formula to measure what the gap is to the overall target of multiple, combined indicators. Such a formula indicator is called an 'index indicator'.
- Changes to score_start/end because of different user time zones
For formula indicators, the values of the variables score_start and score_end are calculated based on the time zone of the user who is executing the formula. If users in different time zones execute the same formula, the values of score_start and score_end change.