Total Time Spent calculates differently in Explore - why?

3 Comentarios

  • Chandra Robrock
    Community Moderator

    Hi Lucy! I attempted to reproduce this in my own Zendesk instance but wasn't able to.

    I have a hunch you might be looking at the SUM of the Total Time Spent (sec) metric rather than the AVG but I'm not 100% sure if that will explain the numbers you're seeing on your end. It's worth a shot though!

    0
  • Lucy Child

    You're right Chandra - but I'm still not sure why. There's only that one ticket that I'm querying, so why would SUM be different to AVG?

    0
  • Chandra Robrock
    Community Moderator

    Lucy Child Based on what I had seen within my own Zendesk instance earlier today, I believe it's because you're looking at three different metrics in your Explore query.

    For instance, in the example I was looking at in my account, if I were to multiply the number I was seeing in the event logs for Total Time Spent by the 'number of updates' and 'number of tickets solved' returned within my Explore query for that same Ticket ID, the numbers added up on my end. Switching it from SUM to AVG allowed me to look at the average Total Time Spent (in the case of a single ticket, this would be the same) versus adding the total time spent for each individual ticket update.

    That said, the numbers weren't adding up in your screenshot which is why I wasn't 100% confident that the AVG function would do the trick here. I have a feeling it might be because you're filtering by Update - Date but, without being able to see all of the filters you've applied to this query, it's a bit difficult to know for certain if that's what is at play here.

    Hopefully that at least helps point you in the right direction! Otherwise, Zendesk's Support team might be able to shed some additional insight in terms of the exact numbers you're seeing on your end. 

    0

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk