Symptom
You run a report based on data source Ticket, you notice the number of tickets in a report do not match to the number of tickets in the Tickets view in Service work center.
Environment
SAP Cloud for Customer
Reproducing the Issue
-
Go to the Business Analytics Work Center.
-
Go to the Report view and open a standard ticket report based on data source CRMSRQHB.
-
Download the report to Excel and count the total amount of tickets.
The total amount of tickets that you count is 300 (for example).
Compare this with the Ticket View:
-
Go to the Service work center.
-
Go To the Ticket view or Employee Support view.
-
Search for all tickets.
You can see the total amount of tickets displayed is 100 (for example). This is different to the amount counted in the report.
Cause
This is not the correct way to compare results of the tickets in the report and those in the Service work center. The search criteria are not the same.
In the Service work center, Ticket View or Employee Support view the search applies all ticket types, however in standard reports the search usually applies some additional filters. For example, irrelevant tickets are automatically filtered out.
Resolution
You can create a custom report and add the field Classification or
Irrelevant tickets will have the classification code Not Relevant.
Keywords
Ticket report, Data source CRMSRQHB, ticket, irrelevant tickets, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem