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
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.
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.