How are you aggregating total handling time across tickets? | Community
Skip to main content
Answered

How are you aggregating total handling time across tickets?

  • October 5, 2022
  • 2 replies
  • 159 views

It appears that the only opportunities for aggregation are Average, Median, Minimum, and Maximum but I want a Sum of all the time spent handling tickets for the last three months. How can I aggregate by Sum instead?

 

How can I either remove the aggregation options so I can see a total sum, or get a full list of all the conversations and all of their handling time so I can sum it myself?

 

Thanks!

Best answer by Maryanne Miller

We built a conversation attribute that captures the time spent on a ticket that our support rep fills out and I can aggrecgate that in monthly reports and on a per client basis but I am still working out the full solution. 

2 replies

Racheal
Intercom Team
Forum|alt.badge.img+5
  • Customer Support Engineer
  • 512 replies
  • October 11, 2022

Hey @laura l​ Racheal form the Support Engineer team 👋

 

I see that you have been chatting with my teammate Aidan on this- let us know if you have any other questions!


  • New Participant
  • 2 replies
  • Answer
  • June 18, 2025

We built a conversation attribute that captures the time spent on a ticket that our support rep fills out and I can aggrecgate that in monthly reports and on a per client basis but I am still working out the full solution.