C4C Ticket (Service) Total Duration Key Figure

[szientara]

Hi experts,

we have problems to identify the correct key figure for the time between the reported on and closing date of a ticket (Status = Completed).

Total Duration = Completion Date Time (2) - Reported On (1)

We did not find any field in any datasource which enables us to track this.
We even tried to calculate it but the date field "Resolved On" is not available as a Key Figure.

Does anyone have an idea or has the same question already been solved elsewhere?

Thank you very much in advance.

BR,

Simo

[AnkushPashine]

Hello Simon,

Please check , if this helps your requirement :- Need to determine the "Time Duration" based on Created & Completed the Service Ticket in the Report ...

if Yes - set this as answered ...Good Day !

Best Regards,Ankush

[szientara]

Hello a.pashine ,

We already followed the advice of the given link, unfortunately this only provides a key figure on daily basis.

Our requirement is the calculation based on time stamps, which are not available as key figures in the data sources “Ticket”, “Ticket Time Points and Contact Party”, “Ticket History”, “Service Request“, “Service Request Time Recording“.

Are there data sources we should check?

What can be a suitable approach?

Thanks.

BR,

Simon