I need a report to get all the defects closed/resolved within 20 day period from their created date.

[RM]

I need a report to get all the defects, closed/resolved within 20 day period from their created date. Can this be achieved using JQL? 

[Mehmet A _Bloompeak_]

Hi @RM 

Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need resolution time to be calculated first.

For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping statuses you can get resolution time(E.g from new status to done status). You can also export the report as CSV and open it in excel to filter issues which exceeded 20 days resolution time.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try without installing the app.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

[Martins Vanags -eazyBI-]

Hi @RM 

Perhaps you could explore eazyBI app.

We have few public report examples to group issues by Resolution intervals (resolution is calculated as difference between creation and resolution)

https://eazybi.com/accounts/1000/cubes/Issues/reports/559656-monte-carlo-chart-resolution-days

https://eazybi.com/accounts/1000/cubes/Issues/reports/97436-issue-resolution-days-lead-time

https://eazybi.com/accounts/1000/cubes/Issues/reports/155045-average-resolution-time-and-trend-lead-time

Btw, you can customize resolution intervals in this dimension.

Martins / eazyBI

[Rahul_RVS]

Hi @RM 

As an alternative you can also try out our plugin,

Agile Tools : Epic Tree & Time in Status 

The add-on provides the time in each status for the entire lifecycle of the issue. You can also combine your statuses to define your Resolution time and also extract the transitions history of the issues. Along with various Issue stats reports, you get additional features like Epic Hierarchy, Links Hierarchy & Worklogs Report to track the project's progress. The main features of the app are as below

• More than 8 types of Time in Status Reports. Excel Export available for all status reports.
  
  • Time in Status
  • Time with Assignee
  • Time in Status with Assignee
  • Time with Assignee per Status
  • Status/Assignee Count
  • Multiple Transition Reports
  • Avg Time reports
• Epic Hierarchy / Sum Up (Standard Jira Hierarchy Epic -> Story -> SubTask)
• Link Hierarchy / Sum Up (Hierarchy based on your issue link, upto 10 level deep)
• Worklogs Report
• Timesheet Entry screen

[Emre Toptancı _OBSS_]

Hello @RM

Our team at OBSS built Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Server, Cloud, and Data Center.

Time in Status allows you to see how much time each issue spent on each status. You can also pick individual statuses into Consolidated Columns to see metrics like Resolution Time, Ticket Age, Cycle Time, or Lead Time.

You can calculate averages and sums of those durations grouped by the issue fields you select. 

The best part is: you can filter issues based on these values. For example, you can see issues that were in In Progress for more than 5 days.

    

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
• Export your data as XLS, XLSX, or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets

Timepiece - Time in Status for Jira

EmreT

[KAGITHALA BABU ANVESH]

Hello @RM ,

created >= -20d and issuetype =defect and resolution in (Resolved,done)

Can you please try the above.

Thanks,

Kagithala Babu Anvesh

[RM]

Thank you @KAGITHALA BABU ANVESH for the response, but i am after something like,

resolved date <= created - 20d

Thanks!

[Zoryana Bohutska _SaaSJet_]

Hi @RM 

I had the same problem when I wanted to view all issues we resolved last month.

I can`t find right Jira filters, so I used Dynamic Filter (created by my team).

It allows select any issue field and date period for filtering. In my case, I selected issues' field resolution date and date period I needed. 

As the result, I get the list of issues closed/resolved at time period I need. 

[Serhii Kibitkin_SAASJet_]

By the way, you will use another option of Dynamic Filter to extract resolved and closed tasks for 20 days, 

1) Created task from today day minus 20 days (this option will be able to calculate every day from the current date.

2)Statuses of tasks in (Closed, Resolved) 

3) Apply 2 Smart fields to filter. 

[Serhii Kibitkin_SAASJet_]

or pure JQL query with 2-3 values for each request: 

Filter last 20 days from today with statuses Closed and Resolved  in projects  Dev, Support, QA:

created <= startOfDay(-20d) AND status in (Closed, Resolved) and project in (Development, Support)