How can I measure how many tickets were closed within 5 hours of opening via Jira dashboards?

[Marco Antonio]

How can I measure how many tickets were closed within 5 hours of opening via Jira dashboards?

I looked at this link https://confluence.atlassian.com/jsbr/pesquisa-avancada-referencia-de-campos-920354924.html and didn't find the answer i need.

[Mark Segall]

Hi @Marco Antonio - You could use a filter like this:

resolved >= -5h

[Marco Antonio]

I tried and didn't work as I was expected.

When I used the filter you suggested, it didn't exactly show all the tickets that were closed within 5 hours. I could see many other tickets that were closed in less than 5 hours and did not enter the filter you suggested.

[Marco Antonio]

Do you have any another suggestion?

[Mark Segall]

Hi Marco - Does your workflow enforce that issues moved to "Closed" are also marked as resolved?  If not, then yes you'll have some issues that are closed, but not resolved and thus the query won't work.

You could try something like this instead:

status = Closed AND status changed to (Closed) AFTER -5h

[Marco Antonio]

Your suggestion had the same result of the other. 

And yes I mark the concluded field as resolved. I noticed that the filter you both suggested me is bringing the tickets that were closed in time from 5 hours ago to now. But, this was not my question, I'd like to understand from all the tickets already marked as resolved, which of them were opened and closed in a period of only 5 hours?

[Mark Segall]

Ahh - Misunderstood.  Apologies.  Here's a query that should work:

created >= -5h AND resolved IS NOT EMPTY

[Mark Segall]

Note - To get any issues closed in a 5 hour period (regardless of last 5 hours) you would need a 3rd party app like script runner.