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?
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?