Example: Creating a Change Management KPI report
With Remedy Smart Reporting, you can create Incident Management and Change Management KPI reports. This topic describes how to create a sample Change Resolution trend report based on the support group.
The following video (9:12) describes the process for creating a custom KPI report.
To create a new KPI report
- Select Create > Report.
Select the required KPI from the list.
On the Data page, the available fields differ from the ones displayed on a regular report.
Remedy Smart Reporting provides History and Summary KPI reports for Change Management and Incident Management.
To the Columns field, drag the KPI History or Summary fields for which you want to create the KPI.
For example, let us create a report of the change resolution trends for each support group for a given period of time. Select the following fields from Change KPI-History:
- Total Changes
- Resolved Changes
Add the Grouping Dimension History or Summary fields to your KPI report.
For our example, from Secondary Group for the Change History KPI report, select the Secondary Group field (which is defined as the Support Group). For a History KPI report, add the Sample Date and KPI Name to the filters list.
If you add a group field to the filters, and the field contains an enumerated type (ENUM) field value (for example, priority), you must:
1. Add the corresponding Field ID to the filter list.
2. In the Advanced Settings for the filters, manually add the ENUM field name to the Field ID using the Select Custom Value option. The Group and Field IDs are mapped as follows:
Group Field ID Primary Group Field ID 2 Secondary Group Field ID 3 Tertiary Group Field ID 4 Quaternary Group Field ID 5 Quinary Group Field ID 6
Click Filters > Advanced Settings.
- On the Configure Filters page:
- For KPI Name, select In List from the drop-down list.
- Click Define Value, and select Defined Value, and add the form names for the selected aggregate fields.
- Click Submit.
- For Sample Date, select Sample Date Greater than or equal to from the drop-down list.
- Click Define Value, and select Defined Value, and select Current date - 2 Days.
- Click Submit.
Close the Configure Filters page.
Click the Charts tab to create the chart for the KPI report.
For example, under Combination Charts from the Chart Type options, select Overlay chart. For information about creating charts, see Visualizing report data in a chart.
Add Dimensions to the horizontal axis, and Metrics fields to the vertical axis.
For example, add Secondary Group (that is, Support Group) to the horizontal axis, and Total Changes and Resolved Changes to the vertical axis.
Click the Design tab to view a sample of your change request trend KPI.
- Click Report > Save.
Enter a name for the KPI report, a short description, and select the category from the drop-down list. Additionally, define the access rights for the report.
For more information about saving the report, see Saving and providing access to reports.