How to see the amount of open bugs at any given date in time?

[Matt Chau]

I would like to search by specific date, quarter, or year, and see how many open bugs there were at that point.

My goal is to track the seasonality of bugs quarter over quarter, or year over year.

How can I do that currently?

Thank you.

[Trudy Claspill]

Hello @Matt Chau 

Welcome to the community.

You can filter on an issue's ResolutionDate field to determine if it was resolved or not resolved on a given date.

Keep in mind that the field will be empty if the issue is not resolved when you run your filter, so you have to take that into consideration as you formulate your filter.

You would probably also want to consider the Created Date when selecting which issues to include

A simple example of all issues unresolved on a specific date would be:

i.e. Date=Jan. 1, 2022

CreatedDate <= "2022/01/01" and (ResolutionDate is empty or ResolutionDate >= "2022/01/02")

I would need a little more data about your use case for bugs open in a quarter or in a year to formulate appropriate filters.

[Matt Chau]

Thank you. The goal of this dashboard or report will be to show how many open bugs we have at any given point in time. 

For example on 7/19/20, we may have had 5 open bugs.

On 7/19/21, we may have had 8 open bugs.

On 7/19/22, we may have had 12 open bugs.

This would then tell me that open bugs have been increasingly through the life of the product.

Adding onto the above scenario, if in December of each year from 2020-2022, we had just 1 bug, then I can draw a trend analysis that says during the Winter, we experience less bugs (perhaps because of less feature releases).

[Trudy Claspill]

What is your definition of an "open" bug?

Are you trying to assess the number of bugs not getting resolved, or the number of new bugs being opened?

The filter I was proposing reflects bugs that have not gotten resolved, that were created on any date prior to the date of the query. 

If you are trying to assess new bugs being found regardless of whether they have gotten resolved, that would be a different filter.

I don't think there is necessarily a correlation between the number of bugs not getting resolved and the conclusion that you experience less/more bugs. The number of new bugs may be increasing, but the team may be getting more efficient at resolving them, thereby reducing the overall number of unresolved bugs. That doesn't tell you if there were more or fewer bugs getting opened. Perhaps for the trend you are trying to derive it would be more accurate for you to filter only on the CreatedDate of the bugs.

[Eduardo Oliveira - Mindpro Apps]

Hi @Matt Chau, how are you? 👋🏻

I would like to share a simple solution that may be useful in your need / scenario 👉🏻 MindPro Insights - Dynamic Reports for Jira

With this solution, you can quickly filter your project issue types (e.g., Bugs), filter the desired dates, and present the information in interactive dashboards.

And you can even see your bugs and other issue types in a hierarchy view.

If you want to see how it works, take a look at this quick tour. I hope it can help you.

Best, Eduardo Oliveira | MindPro Team