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
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,223 views 5 10
Read article

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