Recent searches
No recent searches
Should Tickets updated w/comment match the total of Public + Internal comments?
Posted Dec 08, 2021
Hi!
I have cloned the table query from our Zendesk Support Agent Updates.
Should the sum of Public + Internal comments match the number in Tickets updated w/comment? As I can see now, the numbers don't match.
Does anyone know why they don't? Isn't it counting a ticket as updated everytime a comment is added and should therefore add to the count of Tickets updated w/comment?
0
5
5 comments
Dave Dyson
No, because "Tickets updated w/comment" is counting the number of tickets, not the number of updates that include comments. A single ticket could be updated several times as public and internal comments are added (not to mention updates where no comment is added, but only field values are changed).
Does that help clarify things?
0
Ali Berté
Hey @...
I have the same question and would like to make sure I understood your explanation.
- Tickets updated w/comment: "is counting the number of tickets" based on what?
- Tickets updated w/ public comment: is counting the number of tickets updated with public comment, or is it counting the number of public comments?
- Tickets updated w/ internal comment: is counting the number of tickets updated with internal comment, or is it counting the number of internal comments?
Thank you for your help :)
0
Dane
You can refer to Support Metrics and Attributes to have an overview of the Support dataset.
- Tickets updated w/comment is counting the number of ticket that has Internal or Public Comments.
- Tickets updated w/ public comment is counting the total number of tickets that were updated with a public comment.
- Tickets updated w/ internal comment is counting the number of tickets updated with internal comment.
Hope this helps.
0
Ali Berté
Hi Dane
Thank you, yes it helps.
But, I still don't understand why internal + public comment doesn't equal Ticket updated w/comment ?
Thanks for your help
1
Gab Guinto
The metrics Internal comments and Public comments count each individual comment; the metric Tickets updated w/comment count the tickets that received at least one comment. If for example, a ticket have both internal and public comments, Tickets updated w/comment will only return 1 count for that ticket – it counts the number of unique Ticket IDs, and not the number of updates. Adding up the number of internal and public comments will definitely result to a higher count than the number of tickets, unless each ticket only receives either one internal note or one public reply.
0