Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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? 

3 answers

1 accepted

1 vote
Answer accepted
Jack Community Leader Jan 20, 2021

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 Community Leader Jan 21, 2021

+1

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).

завантаження.png

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

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...

209 views 1 6
Read article

Community Events

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

Events near you