Open issues or issues in a specific state at the end of each week?

[Chris Peake]

How do I get a count of issues that are in a specific state at the end of each week?

I can easily create a chart showing issues created and issues resolved per week.  If I want to show the number of open issues at the end of each week, I can't simply subtract resolved from created as the number is likely non-zero if my chart is configured to show, for example, the last 4 weeks only as the starting value of issues open is unrelated to the number of created/resolved for that first week of the chart.

More generally, how would I show issues with a particular status at the end of each week (e.g. status=Blocked)?

Thx

[Trudy Claspill · Accepted solution]

Hello @Chris Peake 

Have you looked at the WAS operator with the ON predicate?

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

status WAS "Blocked" ON "2025/05/09"

That JQL would get you a list of the issues that had a status of Blocked at any point on the specified date.

If you are looking for some sort of consolidated view that shows the count for all statuses at the end of the week across multiple weeks, I don't think there is a native solution for that. That might require a third party app that provides more complex reporting capabilities.

[Danut M _StonikByte_ · Accepted solution]

Hi @Chris Peake,

You could try using the Cumulative Flow Diagram report, if available in your Jira project, which shows the issues by their status along the time.

If this is not enough, you could search for an app (plugin) on Atlassian Marketplace that offers a better chart or report.

In case you want to try an app, our Great Gadgets app offers a Cumulative Flow Diagram gadget that can show the count of issues in every status on a per-week basis. 

All you have to do is to configure the gadget with a filter/JQL that returns the issues to be tracked, to display bands by issue statuses and to group data by 1 week. You can also exclude the Done statuses if you don't need them.  

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

Danut 

[Maksym Babenko_TypeSwitch_]

Hey @Chris Peake,

I’ve faced a similar challenge before — Jira's built-in reports often struggle with showing status snapshots over time (like “how many issues were Blocked at the end of each week”).

If you’re open to apps, Issue Delivery Report might help.



It reads the full issue history and categorizes time spent in each status (like Blocked, Active, Waiting).

While it doesn’t yet offer weekly snapshots out of the box, it can give you very detailed insights per issue including whether it was added late to the sprint, flow efficiency, and time in each status.

Hope that helps!

[Chris Peake]

Thanks for the quick answers all, I thought I was posting this question in an Analytics-specific area.  I'll try again.