Consolidated report for all projects

I want to create a consolidated reports for all projects. 

Report format - there will be different columns.

Column 1 - Project names

column 2 - count of issue with no due date(result will be based on my query)

column 3 - count of issue with no description(result will be based on my query)

etc 

etc

2 answers

1 votes

You'll need to find or write a reporting add-on to do that in one go.

But, off-the-shelf, you can do it separately.  For what you describe:

  • Create a filter for "duedate is empty" and save it.
  • Create a filter for "description is empty" and save it.
  • Create a new dashboard
  • Add a "filter statistics" gadget using the duedate filter and selecting project as the statistic
  • Add a "filter statistics" gadget using the description filter and selecting project as the statistic

and so-on.  It's not one report, just one page, but it will give you the answers.

0 votes

You can definitely do this with the Better Excel Plugin by:

  1. Writing a one-liner Groovy method that returns all your projects
  2. Iterating over the projects and
    1. Writing a short Groovy method (it's easy!) that receives a project key, inserts that to a JQL query, executes the JQL and returns the count of issues found
  3. Creating an Excel template that executes the Groovy and puts the results into a spreadsheet

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,865 views 12 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot