Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,550
Community Members
 
Community Events
165
Community Groups

How can I get a breakdown of completed vs. incomplete issues for multiple epics for reporting?

Edited

I am an administrator at my firm for Jira - we're attempting to create a report, dashboard, or query that displays the breakdown of completed vs incomplete issues for around 15-20 of a project's epics. The goal is to get the big picture (pun intended) of X amount complete vs X amount incomplete in one cohesive area/list for these epics.

I've created a filter that properly pulls the associated issues and attempted to use gadgets to create the data we need, but nothing displays the breakdown of the complete vs. unresolved stories per epic. The Epic Report displays everything we need to know, but only for a single epic at a time - since there's hundreds of epics in the project, we'd prefer not to refer leadership to search through the list for each of the 15-20 epic reports.

Is there a gadget that can be utilized to display this type of information, a way to create a series of Epic Reports for the desired list of epics, or any alternate solutions anyone can assist me with?

Appreciate it!

3 answers

Hi @Krista Nicol

here's another app that you might like: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing and inline-editing all your issue fields. You can also view your issues in their parent/child-relationships, group them by one or more issue fields, and calculate "sum-ups" across these groups.

What you could do is,

  • Create a JXL "sheet" based on JQL query that includes your epics and any possible child issues; don't worry about the parent/child relationship; JXL will sort this out for you.
  • In JXL, enable the default issue hierarchy (that's just one click), or combine issue hierarchy with various groupings.

Depending on your exact needs, you can now add any fields that you are interested in and chose from different sum-ups styles (simple "sum" vs. status bar vs. etc. etc.)

This is how this look in action:

completed-vs-incomplete.gif  

If needed, you can also easily export your sheet to Google Sheets/Excel for further processing.

Hope this is useful,

Best,

Hannes

1 vote

Hi @Krista Nicol , 

This is something Pivot Report we develop was created for:

shot_220523_213736.png


This demo report is available by this link, feel free to play around (no login required). 

Parts of the report like Summary table on the top could be displayed as a gadget.

If needed, please ping me, so we can arrange a call and go over your request in detail. 

1 vote
Fabian Lim Community Leader May 20, 2022

Hi @Krista Nicol

I suggest you look into reporting plugins in the marketplace. 

Here is an example of using eazybi: https://eazybi.com/accounts/1000/cubes/Issues/reports/844993-issue-epic-hierarchy

Regards

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

99 views 1 3
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you