cancel
Showing results for 
Search instead for 
Did you mean: 

Need to determine the "Time Duration" based on Created & Completed the Service Ticket in the Report

ranjeethgowdakl
Participant
0 Kudos

Dears,

I would like to be determined the "Time Duration" based on Created & Completed the Service Ticket.

Designed the report but we are unable to determine the Time Duration in SAP C4C.

Please assistance on above. Thanks in advance.

Ranjeeth

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member240517
Participant
0 Kudos

Dear Ranjeeth,

I hope you are doing well.

It is possible to determine the Time Duration of a Ticket by following the below steps:

1. Go to Business Analytics work center and Design Key Figures view;

2. Click on New button;

3. Type a name and select a data source (i.e. Ticket);

4. Formula TIME([Completion Date]) - TIME([Created On]);

5. Click on Finish.

Sincerely, Elise Teixeira.

ranjeethgowdakl
Participant
0 Kudos

Dear Elise,

Thanks for your input, but am added the new fields(Completion Date & Time and Creation date & time) at the service ticket. Based on this new fields(Characteristics) Time Duration should be calculated, not based on these key figures (TIME([Completion Date]) - TIME([Created On] ).

Thanks in advance.

Ranjeeth