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

[Natalia_Kovalchuk_SaaSJet_]

Hi @Chris Peake!

If I understood correctly, you need to monitor the exact number of issues in Jira's specific status and date range.

I recommend you try Issue History for Jira app from my team. This app allows you to easily track all the changes made to issues.

The app provides a Chart View that allows the monitoring of the statuses of different issues.  You can choose the needed project, set a required date range (e.g., this week), and get the chart with the number of issues and their statuses. You can easily track issues with the Blocked status at the end of each week.

Furthermore, you can export the data as a PNG or SVG file.

[Chris Peake]

Hi Natalia,

Sorry I am looking for an Analytics-based solution here.

Chris P.

[Chris Peake]

<deleted was in wrong location>

[Inder Singh]

@Chris Peake : You can check out "Time-in-status history" dashboard template that has a chart with issue count at the end of a period (day/week/month etc.) https://support.atlassian.com/analytics/docs/time-in-status-history-dashboard-template/ 

Thanks,

Inder

[Chris Peake]

Hi Inder, that's not quite what I'm looking for.  I want to be able to see exactly how many issues are in a certain state (or group of states) on a certain day or week...I'm not interested in how long an issue or group of issues has been in a state.

e.g Can I plot the following over time on the same chart with weekly timescale?

• Issues created each week.
• Total issues open at the end of each week where open includes any issues with state not in (Done, Rejected)).
• Total issues with status = Blocked at the end of each week.

[Inder Singh]

@Chris Peake The screenshot I shared from the dashboard template has both count (as line) and time-in-status (as bar). But it shows the count of issues that were in a particular status at any point within that week. I guess you are only interested in the count at the end of the week? 

[Chris Peake]

I'll have another look Inder but, yes, at the end of the week (I should be able to add all issues in each status for the column and have it end up = to total issue count).