How can I determine how long an issue was "open" and the exact date and time it was "resolved"

Question

I need to be able to create a report showing how many issues were created in a calendar period and how many were resolved. I can get the created date, but I'm not finding a resolved date. Is this possible? It seems like it would have to be to actually measure the performance of a service desk team.

Trudy P Claspill · Accepted Answer

Hello @Shaun McGuire

There is a Resolved date for each issue. It is set automatically when the Resolution field is set.

Have you looked at the Created vs. Resolved gadget that is available natively in the Jira Dashboards? That gadget leverages the Created and Resolved dates in the issues to generate the chart.

Valeriia_Havrylenko_SaaSJet · Accepted Answer

Hi @Shaun McGuire 👋 You have three options to determine the resolution time of an issue: * By JQL (Jira Query Language): You can use JQL to create a filter that includes both the creation date and the resolution date of the issues. By constructing a query, you can retrieve the necessary data to calculate the resolution time. Here's an example of how you can do it:


created >= "2023-01-01" and created <= "2024-01-31" AND resolved >= "2023-01-01" and resolved <= "2024-01-31" 

Replace "start_date" and "end_date" with the desired date range. This query will filter issues created and resolved within that range. 


* By Adding the Created vs Resolved Gadget






     

     3. By Time In Status: This add-on tracks the amount of time an issue spends in each status. You can easily gat report about how long an issue was "open" and the exact date and time it was "resolved". Just simply:

* Filter issues by Resolved 
* Set date range for issues. 




Add-on developed by my SaaSJet team. 
Let me know if you need further assistance with either option!