Create a filter for issues resolved within "x" days of created date

[Angie]

Greetings 

Will you assist me with creating a filter that shows my old Issues  

e.g   Created 1st Jan 2020 - Resolved 5th Jan 2020 

is it possible to create a filter like that? 

[Jack Brickey · Accepted solution]

JQL OOTB doesn’t support two field comparisons. You could look at an app addon or, if this is something you want to monitor long term consider using automation and custom field where when an issue is closed check if the closed date is within x days of created and if so set the custom field to true. In this way you can filter for that field and illustrate percent of true vs false. Of course this later does work for those already closed. 

[Ignacio Pulgar]

+1

[Mariana_Pryshliak_Saasjet]

Hello @Angie 

You can try the Dynamic Filters: JQL Replacer for Jira add-on. It helps to create a custom issue list quickly. Regarding your issue - choose the date ranges you need and get the necessary data (even about the old issues).

Also, you can export all data as XLSX or CSV files for deeper analysis.

I hope, you find it helpful.

Best regards, Mariana

[Mehmet A _Bloompeak_]

Hi @Angie ,

You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process the exported data.

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(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try. Hope it helps.