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

VARUN KUMAR REDDY January 3, 2021

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.

1 answer

0 votes
Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 4, 2021

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.

VARUN KUMAR REDDY January 4, 2021

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.

KAGITHALA BABU ANVESH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 4, 2021

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