Create a report with snapshot of all open issues of a project

[carl-johan.backman]

Hi,

I'm looking to create a report that shows all open issues (statusCategory != Done) for a specific project. A single digit for the current snapshot would be great and even better if it's possible to see the backlog trend over time.

Is this possible?

Thanks!

Best,

CJ

[Danut M _StonikByte_]

Hi @carl-johan.backman,

You could try the Cumulative Flow Diagram report, if available in Jira for your project type. It has an option to exclude the statuses, so it could do the trick for you.

If you want something more advanced and flexible/configurable, you could look for an app on Atlassian Marketplace.

In case you want to try an app, our Great Gadgets app offers a Cumulative Flow Diagram gadget that can display this info for you, and it is highly configurable.

This gadget has the advantage of being more configurable, uses a filter/JQL as data source, it can also calculate by status categories (not only by statuses), by sum of story points (not only by count), and much more.

You could also use the WIP Run Chart gadget offered by the same app.

See more examples here: https://community.atlassian.com/forums/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut. 

[Marc - Devoteam]

Hi @carl-johan.backman 

Welcome to the community.

You can create a filter with the required JQL

the cretae a dashboard and use the gadget "Recently Created Chart". This will provide a bar chart on issues created overtime, use the created filter in this gadget and set the required time period, daily, weekly, etc..

[carl-johan.backman]

Hi @Marc - Devoteam ,

Thank you!

To make sure I understand: won't the the solution you suggest just show the issues created during the selected timeframe?

What I'm looking for is a snapshot of the total amount of open issues at a given time point.

Say that yesterday we had 300 open issues in the project, today 2 were created and 1 resolved. In this example the yesterday bar should be 300 and today bar 301.

Or another example: if I look at the past 7 days, I want to see the total number of open issues each day during the last week.

[Marc - Devoteam]

Hi @carl-johan.backman 

Jira has no dashboard gadget for this, Jira is based on real-time information.

Then you need to revert to the marketplace and look foor apps that can extend your dashboards/reports

Or export information via the API and use this information in an external tool to create a report.

[carl-johan.backman]

Thanks, @Marc - Devoteam

To confirm: it’s also not possible to get a point in time number for all open issues?

If I can’t get it over time ut would still be valuable to have a real-time number. 

[Marc - Devoteam]

Hi @carl-johan.backman 

This you could search for.

Example:

status was not in (Done, Closed, Resolved) DURING ("2025-01-01","2025-03-01")

or

status was not in (Done, Closed, Resolved) before startOfMonth(-5)

You can't use the statusCategory in these kind of searches.

See documentation on advanced JQL operators, specific WAS, WAS IN, WAS NOT IN, WAS NOT, CHANGED

https://support.atlassian.com/jira-service-management-cloud/docs/jql-operators/#WAS