Hey HS Community,
Trying to create a report that calculates the number of interactions/emails per closed ticket. Any tips and tricks will be helpful.
Hi @PHoward7,
I played around with this a bit and I’m not sure it’s possible at this stage. This would be a report in the custom report builder (Menu > Reports > Reports > Create custom report > Custom Report Builder) with the data sources “Tickets” and “Sales activities” (which include service activities for the purpose of this report).
You can then drag and drop Count of sales activities, Ticket owner and Activity type, for example:
However, it’s not possible to change the Count of sales activities from an aggregate to an average. You would have to create two reports, once that shows the Count of tickets, another that shows the Count of sales activities and do that last step of the calculation yourself. Not ideal, I know.
Hope this helps, still!