Last assignment to resolution time in Business Hour | The place for Zendesk users to come together and share
Skip to main content
Pam11
Pam11
June 28, 2022
Question

Last assignment to resolution time in Business Hour

  • June 28, 2022
  • 3 replies
  • 38 views

We have a group of agents where their full resolution time is measured from the last assignment timestamp to the ticket solve timestamp. I am struggling with how to apply business hours versus calendar hours to the calculation.  Does anyone have any ideas on how I can edit this calculation to account for business hours vs. calendar hours?

DATE_DIFF([Ticket solved - Timestamp],[Ticket assigned - Timestamp], "nb_of_hours")

      3 replies

      ZZ59
      ZZ59
      June 29, 2022

      Pam

      Unfortunately, I do not believe that is possible.

      Zendesk tracks business hours metrics at ticket level, not at the assignee level. So it is not possible to drill to that level of detail.

       

      Hannah12
      Hannah12
      Newcomer
      October 5, 2023

      Hi! I am also curious on why time from last assignment to resolution can't be converted to business hours. Isn't this just a conversion of time? Also, isn't the assign event stamped on the ticket, thus it lives at the ticket level? Trying to better understand. :)

      Chai12
      Chai12Employee
      Employee
      November 26, 2023
      Hi Hannah, 
       
      Some metrics come natively out of the system. Others - the ones with the eye icon beside it- are calculated between timestamps. Only the former can be 'business hours'. You are also correct in notating that assignment events are part of the ticket events. When you could say that it lives at the ticket level, it also relies on the system's stamped time. 
       
      Of course, Hannah. Thank you for taking the time to learn more about Explore and the Last assignment to Resolution time metric. 
       
      Terms & ConditionsAccessibility statement