• Viktor Osetrov

  • April 24, 2023 11:49

  Zendesk Customer Care

  Hello Allen,
  
  I'm afraid there's no option in Explore that would allow you to count the number of business days or hours in a certain time period. May I ask why you are looking to count the number of business days? If you need to use this in certain calculations within Explore queries, then maybe we can find a workaround. Can you provide more details on your use case and what kind of report you are trying to set up? Would the default business hour metrics fit your query to achieve your reporting needs?
  
  Thanks
  
• Allen Lai | Head of CX, Otter.ai

  • April 26, 2023 05:07

  Viktor OsetrovI'd like to use it to help calculate different averages and use the number of business days in a month as the denominator. For example, taking the total number of tickets handled per month and divide it by the number of business days in a month to give me the average number of tickets handled per business day.

• Viktor Osetrov

  • April 28, 2023 09:33

  Zendesk Customer Care

  Hello Allen,
  
  Thanks for your clarification. I believe the best solution is to extract this information using theTime Tracking app. For example, you can analyzeTicket handling time by monththere.
  Please join tothis conversationthere if you have any issues regarding this app.
  
  Kind Regards
  

Pleasesign into leave a comment.