How to create report of open tickets by week

Question

The report wants to show tickets (series = created)

created even though I add the status of open tickets. I just want the total open tickets per week.

I know I'm missing something.  I would assume that I could chose the series as Status but it's not there

Johnny Jenkins · Answer

That graph is what every service desk needs.

Adamantia Leivada · Answer

I use the cumulative flow diagram to display status trends over time and cherry pick only the "open" status, not the "done" status

Walter Buggenhout · Answer

Hi @WM,

What you are looking for, is unlocking the issue history that Jira has, but not always exposes very well.

A good starting point that is available out of the box, may be the Created vs Resolved chart. It displays the number of issues created, resolved AND the trend of resulting open issues:

It can be configured to display the evolution on a weekly basis, to a maximum of 300 days in the past until the current date.

All you need to set it up, is a JQL filter to retrieve the issues you want to report on (could be as simple as: Project = <your JSM project>) and a dashboard to add the gadget to.

If you want to do more advanced reporting and would like to do more advanced reporting, you should revert to a more advanced reporting solution from the marketplace. This is an example built with EazyBI e.g:

Hope this helps!