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?
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.
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
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.
We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan. &nb...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events