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.
SAP Cloud for Customer
Reproducing the Issue
Go to the Business Analytics Work Center.
Go to the Report view and open a 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.
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 the report the search applies some additional filters. For example, irrelevant tickets are automatically filtered out.
You can add the field classification (
Ticket report, Data source CRMSRQHB, ticket, irrelevant tickets, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem