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

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • 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

how to find number of open jira's during a week



My requirement is I like to find number of open jira's per week basis.

for example I want number of Open JIRA's between two dates 2020/12/1 and 2020/12/5 if I am using a filter like " AND status was in (Open)  during ("2020/12/1", "2020/12/5")" the problem is it is showing the jira's which are moved to closed/confirmed in between these date. I don't want these jira's to show up.

Can any one help me.

1 answer

0 votes


Query issues created in a period of time:

created >= 2020-12-1 and created <= 2020-12-31

If you use was, the query result will return all Issues that were in the open state, even if they are closed.

Hi @Ollie Guan_携程 


Thanks for the response.


I am not looking for the jira;s that are created in between dates.

My requirement is to get the number of Open JIRAs' (can be created at any date for a given project) between two dates.

For example between 2020/12/01 to 2020/12/05 I want the number of open jira's these open jira's need to be created in between these dates.

createdDate >=2020-12-01 and createdDate <=2020-012-05 and status was Open


This will gives you info of how many Jira tickets status was changed from open status to Next Status and created between 2020/12/01 to 2020/12/05.

Suggest an answer

Log in or Sign up to answer

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