Consolidated report for all projects

Question

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

Aron Gombas _Midori_ · Answer

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

* Writing a one-liner Groovy method that returns all your projects
* Iterating over the projects and* 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

* Creating an Excel template that executes the Groovy and puts the results into a spreadsheet

Nic Brough -Adaptavist- · Answer

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.