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

This widget could not be displayed.

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.

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

112 views 2 0
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