Formula indicators are to produce a new computed score from one or more “normal” indicators. Generally, they are often used to calculate ratios and percentages, combine data from different applications, build predictive indicators based on historic performance, etc. In fact, they are similar to the normal ones but instead to fill the source, additional conditions and collection properties, I have to define a formula statement to get the data.
Formulas can consist of other indicators, constants, variables, and time series, or any combination of these elements. To resume, it will allow me to get the resolution rate for instance to be shown in a chart. If what you want it is to create a simple indicator, read my topic ServiceNow: indicator to define my chart for a report management.
To create a formula indicator, follow those steps:
- 1. Go to “performance analytics -> indicators -> formula indicators”
a. Click to “new”
b. Add indicator groups: I put the group name where I want to put this indicator, a list will appear and I select from this list then press “ENTER” in the keyboard. If I don’t select it from the list, it will not work
c. Name: put a name
d. Description: put a description
e. Direction: select one of the options
NOTE: minimize to display larger tiles for large value and maximize is the opposite. For example, the goal of risk is to minimize the risk, so minimize will be selected so that higher risk scores appear more prominently in larger tiles.
f. Unit: select how I want to display the data (number, percentage, etc.)
g. Precision: put how I want to round up/down the data
NOTE: if 0, it rounds the result to the nearest even, whole number. If 1 or more, it rounds to the nearest decimal point for the given precision (for instance, it rounds a result of 4.45 to 4.5).
h. Key: select only if I consider that this indicator is important
i. Access control, other, forecasting and statistics exclusion: fill the different options if needed
j. Formula, there are 2 ways to do it:
- i. Manually, if I know the formula, I put it here
- ii. Automatically, using the wizard option by clicking on “browse for an indicator”
In my example, I put 2 indicators to get the resolution rate of the workgroup “win LV2” by adding manually the mathematics part.
1. Indicator: select an indicator
2. Breakdown: select the breakdown
3. Element: select the element
4. 2nd breakdown, 2nd element: select them
5. Time series: only if I want a trend chart so I select how to calculate the data
6. Once done, click “select”
7. Repeat the wizard to add the 2nd indicator.
- 2. Now do one of the 2 options:
a. If not into an indicator group, go to “performance analytics -> indicators -> formula indicators”
b. If into an indicator group, go to “performance analytics -> indicators -> indicator groups”
- i. Search for the indicator
- ii. Open it to fill the other optional fields not displaying during the creation
- iii. Click “update” if I do some changes
- i. Search for the group where I put the indicator
- ii. Search for the indicator
- iii. Open it to fill the other optional fields not displaying during the creation
- iv. Click “update” if I do some changes