True first resolution calculation | Community
Skip to main content

True first resolution calculation

  • November 30, 2023
  • 3 replies
  • 0 views

I'm looking to get an understanding of how to calculate my teams effectiveness at resolving customer issues first time round. Essentially, I want to create a report that calculates whether a customer recontacts us again for the same/similar issue within 7 days/30 days. 

I imagine it to look like :
Ticket Created date > Customer Name > TicketID > Issue (Form) > Contact again within 7 days (Y/N) - IF yes [Issue] > Contact Again 30 days (Y/N) - IF Yes [Issue]  

Is there a way to do this in Explore?

3 replies

Alex89
  • December 4, 2023
Hey Steven,

I'm having a little bit of difficulty understanding your question. Are these columns that you want to show in Explore? Are these custom fields that already exist in your account?

  • Author
  • December 4, 2023

Hi  Alex,

No they aren't custom fields. I'm just trying to calculate our resolution effectiveness by creating a report indicating whether customers are contacting us again within certain time frames after resolution eg. 1-7 days, 7-30 days, 30 days + or no recontact. Does that make sense?

I am unsure how to best go about creating this in Explore, whether it be creating custom fields like you suggested or custom metrics, or whether it is possible now. Would love any direction.





Alex89
  • December 6, 2023
Hey Steven,

I think a simple way you could go about doing this is just looking at the difference between full resolution time and first resolution time, the one caveat is that the tickets must now be already in a solved status for these metrics to calculate. Otherwise, you would need probably more custom formulas to accomplish what you are looking for.