Recent searches

No recent searches

How to convert Total time spent (sec) in Total time spent (hour) in a report in Explore

image avatar

Renaud Croix

Most Engaged Newbie of the Year - 2021

Posted May 07, 2024

Hello,

I try to have the average time spent by ticket in hours.
At this stage, i'm using the metric “Total Time spent (sec)".

How to have the same data I obtain in hours ?
 


Thank you very much
 

0

1

1 comment

Date
    image avatar

    Alex Zheng

    Zendesk Customer Care

    Hey Renaud,
     
    You can create a custom metric and take the total time spent and multiple it by 3600 to get the same value in hours like below.
     

     
    Let me know if you have any further questions.

    0

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post