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 vote

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 Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

25,937 views 2 7
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