SAP Knowledge Base Article - Public

2670897 - Calculation of Total Time at Requester and Total Time at Processor

Symptom

In the datasource Ticket (technical ID CRMSRQHB) the two key figures Total Time at Processor and Total Time at Requestor are showing no results for most of the tickets.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the view Design Data Sources.
  3. Search for data source Ticket (technical ID CRMSRQHB) and open it.
  4. Add characteristic Ticket to the view.
  5. Remove all key figures except Total Time at Processor and Total Time at Requestor from the view.
  6. Most of the Tickets will not show a value for the both key figures.

Cause

This is the expected system behavior.

Resolution

In a Ticket the duration Total Time at Requester is only calculated, when the status changes from requester action (customer action) to a different status.

The Total Time at Processor is only calculated, when the status changes to requester action (customer action, this also includes putting status to completed).

If a Ticket status never changed to requester action (customer action), the durations are empty in such tickets. So in this scenario the key figures won't show any result. This is expected system behavior and it works as designed.

Keywords

key figure; ticket; total time; CRMSRQHB; formula , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-LE-CSM-SVL-ANA , Service Level Objective Analytics , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions