Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Generate report month on month for inflow vs outflow defects plus backlog. Edited

Hello, could you please help with below:

I want to generate report month on month for below functions

1) Defects that got 'created' in the past 12months (June, May, April ... and so on)

2)  Defects that got 'closed' in the past 12 months (June, May, April ... and so on)

3) JIRA backlog (JIRA that are not in final state) at the start of every month. (June, May, April ... and so on)

 

Point 1 (created) and 2 (closed) must be presented by a bar graph with different colors. 

X-axis: Months (June, May, April...and so on) for last 12months.

Y- axis: #JIRAs

Line graph: Backlog at the start of each month.

Can we automate this report meaning any time I open this dashboard I get latest data in the graph.

 

 

1 answer

Are you using Jira Server/Data Center or Jira Cloud?

For Cloud, with the native Jira dashboard gadgets you can get a line chart that combines 1 and 2. That would be the Created vs. Resolved Chart.

I don't think there is a native gadget that will get you #3.

There are a variety of apps available in the Marketplace that extend reporting capabilities. I'm sure there is one that covers all three of your reporting needs but you'll have to review them to figure out which one is right for you.

https://marketplace.atlassian.com/search?query=jira%20reports

Thank you for your reply.

Could you please advise on point1 and point2? What will be the search parameters to get created and resolved data for the past 12months (June, May, April ... and so on).  

Below is a screen image from configuring the Created vs. Resolved Chart on a Jira Dashboard.

You don't need to specify criteria specifically for getting the Created and Resolved issues. The gadget charts that information based on the Created and Resolved dates in the issues. And, as you can see, the gadget itself allows you to configure the time period for which you want those issues (365 days) and the grouping (Monthly).

All you need to do is specify the criteria for selecting the projects or issue types on which you want to report.

If you want to report on all the issue types in a single project, then within the gadget you select that project in the Project or Saved Filter field. If you want to report on multiple projects or on only some of the issue types, you will have to create a saved filter that selects the issues in those project(s) and for those issue types, and then select that saved filter in the field of the gadget.

 

Screen Shot 2021-07-06 at 7.46.42 AM.png

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

731 views 2 21
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