How to create an Explore formula for Occupancy rate? | Community
Skip to main content

How to create an Explore formula for Occupancy rate?

  • September 24, 2021
  • 1 reply
  • 0 views

I looked into this article and it mentions the occupancy rate and it is something that our team would like to track, however, I noticed that there is no preset query added to add this to Explore,

It says:

To calculate the occupancy rate for an individual customer service agent:
  1. Add up the total amount of time spent on ticket-related activities, also known as handling time (e.g., answering customer calls or resolving tickets) 
  2. Next, add up the total amount of time that the agent spent logged in (i.e., clocked in and ready to assist customers)
  3. Divide handling time by logged-in time, then multiply by 100 to get a percentage

1. I do have the metric for handling time
2. to measure the time logged in, we will calculate based on 8 hours that the agent is clocked in.

If someone could please help me out with how the formula for this should be, I am kinda stuck!

1 reply

Dave12
  • September 28, 2021

Hi Josselinne,

Unfortunately, there's not currently a way to record an agent's online time in Zendesk. Please upvote and add your use case to this product feedback thread: Reporting on 'Total online time' and 'Time available' metrics