Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,656
Community Members
 
Community Events
165
Community Groups

How to create report of open tickets by week

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

  JiraReport.PNG

2 answers

Hi @LeChatN01r,

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:

Screenshot 2022-06-11 at 11.43.43.png

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:

Screenshot 2022-06-11 at 11.37.15.pngHope this helps! 

Try creating a filter like below, save and associate with a Dashboard gadget such as the created vs resolved or Two-dimensional or other. 

project = abc and created < startofweek() and created >= startofweek(-1)

Thanks, I can do that, but I'd have to run it every week I assume. I wanted a report of previous weeks too. 

Thanks again,

Daboopster

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

302 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you