Creating a Calculated Metric
Calculated Metric properties include:
- Calculated Value:
Expression
to determine the Metric value. For example, FCR rate could be calculated like
this:
(AllIncidentsClosedonFirstCall/AllClosedIncidents)
To create a Calculated Metric:
- Open the Metric Manager.
- Select a scope and subfolder (if needed).
-
Click the
Create New button
.
-
Define the following Metrics properties:
Option Description Name Provide a display name to use within CSM (this property can be searched in CSM Item Managers).
Description Provide a description to use within CSM (this property can be searched in CSM Item Managers).
Metric Type Select the Calculated radio button.
Business Object Select the Business Object whose data to include in the Metric (ex: Incident).Note: Only one type of Business Object can be selected. The drop-down displays only Major Business Objects. To display all Business Objects, select the Show All check box.Data Type Select the type of data (format) to return in the Metric (select one):- Date/Time
- Logical
- Number
- Text
-
In the Expression area, click the
Selector button
(or right-click in the text box), and then add Tokens (example: System Functions, Prompts, Expressions, Stored Values, Metrics, and Counters) and Math Operators (example: Add, Subtract, Multiply, etc.) to create an Expression. Examples might include:
- FCR Rate: (AllIncidentsClosedonFirstCall/AllClosedIncidents) would return a decimal value like .54.
- Percentage of reopened Incidents: (AllReopenedIncidents/AllOpenIncidents)*100 would return a whole number that is then converted to a percentage value, like 10 percent.
- Incident Success rate: (AllResolvedClosedIncidentswithinResolutionSLA/AllResolvedClosedIncidents)*100 would return a whole number that is then converted to a percentage value, like 85 percent.
-
(Optional) Right-click in the Expression text to access a context
menu with options to delete an item, access its properties, or add a
Modifier
(example: Number format).
Note: If using other Metrics in the Expression, you are prompted to define which Metric values to retrieve for use in the Expression (Metric Properties window pops up when you add a Metric). For details, refer to Using a Metric Within a Metric.
- Click OK.