Data discrepancies between Ticket created date and Ticket solved date

4 Commentaires

  • Jahn Bronilla

    If you want to get the monthly "SOLVED" tickets by each agent you will need to use the filter Ticket Solved Date.

    If you will use Ticket Created Date filter to measure the solved tickets by each agent, you will only get the number of solved tickets based on the ticket create month. 

    0
  • Levon Galstyan

    Thanks Jahn for you reply, that what I was thinking honestly. 

    Since we are working with the data through our data warehouse in SQL, logically we would need to take the date of the solved_at column right (and not created_at) ?

    0
  • Jahn Bronilla

    Yes, if your goal is to get the number of Solved Tickets per agent per month. In this case you will also be able to get those solved tickets that are not created only from this month for example. 

    0
  • CJ Johnson

    One thing that may bite you as well -- you should also be aware that "Solved Tickets" on the Updates History dataset is a known bad metric that returns bad data. There's a workaround formula you can write to make it correct: https://support.zendesk.com/hc/en-us/community/posts/4811432683034-Tickets-solved-metric-discrepancy-in-Updates-history-Explore-dataset



    0

Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk