Hello, I'm trying to build a query to determine the average/median number of replies for each Support Agent on our team. I'm using the Support: Ticket Events dataset, and I thought to use Agent Comments as my metric, and Assignee Name as my attribute. However, I believe that the way this is set up, the query will count the number of Agent replies on each ticket, regardless of who commented, and count those toward whoever the ticket was assigned to, which is not the output I want. Any help would be appreciated here, thank you!
Please sign in to leave a comment.