Trying to create a simple report for Resolution times

Question

Hi, I am trying to create a report to show me the number of tickets closed within 2hours, 4 hours and anything over? Is this possible using the advanced query aspect?

Thomas Magny-Garcia · Answer

Edit : Using the "resolutionDate" should be better, I guess.
Query : "resolutiondate >= -5d"

Bill Sheboy · Answer

Hi @jonathan appleby

Welcome to the community!

The answer to your question may depend upon how your team works...

* If you create an issue in Jira just-in-time before you start it, using the relative date/time idea suggested by @Thomas Magny-Garcia will work
* For any other scenario, you would need to do some math, calculating the difference between your starting-status datetime and completed-status datetime.  Jira cannot do that out-of-the-box, so you would need an add-on to enhance filter capabilities, or export to another tool to do the reporting.

Best regards,

Bill

Thomas Magny-Garcia · Answer

Hello !
I am not sure you can get directly the number of tickets neither the completion date..
But maybe you can figure out something using query like that : "updatedDate >= -5d and status in( Done, "Done Done")" ?