How to report Ticket resolution time in days, rather than minutes | XM Community
Solved

How to report Ticket resolution time in days, rather than minutes

  • 11 April 2019
  • 8 replies
  • 94 views

Userlevel 2
Badge +5
I'm building Dashboards for our Follow-up tickets, and am including the resolution time field in various charts. It seems that the resolution time is recorded in minutes, but I'd like to display it in days. I haven't found a way to do this, even with custom metrics, and am hoping someone will have a great solution!
icon

Best answer by KendraR 8 May 2019, 03:18

View original

8 replies

Userlevel 7
Badge +33
you can do so by editing the widget and selecting goal level as days rather than minutes.
!
Userlevel 2
Badge +5
I'm not seeing that as an option? I've used a simple chart, with Average as the metric and resolutiontime as the field being averaged. This is what I see:
!
Userlevel 1
Badge +1
I have the same requirement. I think bansalpeeyush29 is referring to one of the Ticket specific widgets that I believe is no longer available (see FAQ's at the end of this page - https://www.qualtrics.com/support/vocalize/widgets/ticket-reporting/). I haven't found a way using custom metrics either. I'll submit a feature request, but if anyone finds a way, i'm keen to know.
Userlevel 6
Badge +11
Hey, @ChrisLawton! Just wanted to hop in here and let you know that there is currently not a built in way to report ticket resolution time in days. If you have any further questions about this feel free to reach out to our Support Team!

If you would like to see this functionality created, I’d recommend posting this in our Product Ideas category. Be sure to review the How to Write a Good Product Idea template and our Ideation Guidelines before you post your idea! 😀
I ran into the same problem. What I did is created a "Data calculation field" in the Ticket data settings page and had the start value as "Created at", end value as "Closed at" & chose the time as "days" (there are other options available incl weeks). Once you name this field, it ll be available as an option in the widgets where "resolution time" can be selected. With this method, you can also find and display the "First response time" if that is of a key metric to you.

Cheers!
Badge +1
I tried this method and my resolution time is displaying in days, but with multiple decimal points. For example, resolution time = 0.0053231418443829. Has anyone else run into that problem?
Hi @Chris_Sousa, I have this same issue of multiple decimal points. Were you able to find a solution for this case?
Badge +1
Unfortunately, I have not found a solution to multiple decimal points. When I contacted Support, I was told that there is no way to change the number of places shown. So for now, I'm telling users to ignore all the decimal places.

Leave a Reply