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

Question

Hi,

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.

KAGITHALA BABU ANVESH_z1zl10 · Answer

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.

VARUN KUMAR REDDY · Answer

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.

Ollie Guan · Answer

Hi @VARUN KUMAR REDDY ,

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.