Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

carl-johan.backman April 30, 2025

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

2 answers

0 votes
Danut M _StonikByte_
Atlassian Partner
May 2, 2025

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.

image.png

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.

image.png

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. 

 

0 votes
Marc - Devoteam
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.
April 30, 2025

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 April 30, 2025

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
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.
May 1, 2025

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 May 1, 2025

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
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.
May 1, 2025

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 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events