Creating Status comparison reports
You can create a report that compares the number of tickets in one state at a certain time with the number of tickets in another state. For example, you might want to create a report that shows how many tickets were received and how many were closed, based on specific criteria. This type of report is the State 1 vs. State 2 report, available in the Ticket Management report category. You can also create a State Transition type report to generate lifecycle data. For more information, see Creating-lifecycle-comparison-reports.
To define a Status comparison report
- Click Service Analytics.
The Service Analytics utility opens in a new window.
A table listing the available reports appears at the top of the page. The Count field shows how many reports have been defined for each category. - Click New and select Ticket Management > State 1 vs. State 2.
The Report Settings page appears. The Report Type field is read-only. - In the Report Setup section:
- In the Record Type field, select an item.
- In the Title field, type a descriptive name for this report.
- (Optional) In the Description field, add any notes to explain the purpose of this report.
- (Optional) To allow other users to access this report, in the Report Visibility Is field, select Shared.
If you accept the default of Private, no other users can access this report. If you select Shared, only users authorized with at least read-only rights to the selected workspace can view this report. - (Optional) If you want this report to be available as a console widget, in the Make Available In field, select Consoles.
The next scheduled run date appears below this field. The options in the Configurations and Filters sections vary based on your selections in the Report Setup section.
- In the Configurations section:
- (Optional) In the Saved Search field, select a search to find the data for this report. To create a new search, click the Create a new saved search link. When the search is saved, click the Refresh icon next to the Saved Search field to update the list.
For more information, see Using Advanced Search and saving searches. - In the State 1 field, select the first state that you want to compare,
- In the State 2 field, select the second state that you want to compare,
- (Optional) In the Custom Field Dimension field, select a field to impose additional constraints on the returned data.
- (Optional) In the Assignment field, select Assignees.
- Click Apply changes.
- (Optional) In the Saved Search field, select a search to find the data for this report. To create a new search, click the Create a new saved search link. When the search is saved, click the Refresh icon next to the Saved Search field to update the list.
- In the Filters section:
- In the Rows field, select a category for the data rows.
For more information about defining filter criteria, see Defining-filters-for-reports. - (Optional) In the Columns field, select a format for the data columns.
Do not select the same category as you selected for Rows. You cannot display the same data category both as a row and a column. - (Optional) In the Values field, select a value.
- (Optional) In the Filter field, select a filter.
- (Optional) In the View field, select the report graphs that you want available for the displaying on the Dashboard.
As you make selections in the Filters section, the sample report shown in the bottom half of the page will refresh to show the impact of your changes.
- In the Rows field, select a category for the data rows.
- In the Table section, review the sample report. To review the most current data, click Refresh.
The available report formats for this type of report appear below the Table section. Generally, there is a Chart format and one or two additional formats such as Heatmap.- Review the report samples to verify that your settings are returning the data you need.
- (Optional) In the format sections, select display options to change the default views.
- (Optional) Make additional changes to the report, click Apply changes and review the updated results in the bottom sections of the page.
- When you have finished defining your report, click Save.
A confirmation message appears.
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*