How do I report on the progress of Epics based on the status of all sub-tasks?

Bit of background - I have several Epics that have sub-tasks - sub-tasks are used to record the work and various things to be done to progress the Epic, similar to sub-tasks for Stories. Each Epic in my project has the same subset of sub-tasks.

This is what I am looking for:

I want to have a view of all Epics showing a count of sub-tasks grouped by sub-task status so I can see how many sub-tasks are To Do, In Progress or Complete and understand the progress of the sub-tasks on each Epic.

I also want to be able to pull a list of all Epics that have a sub-task in a specific status with said sub-task displayed with the Epic, so that I can manage sub-tasks by type of work in groups.

3 answers

Hi Laurence,

That could be achieved with our Structure add-on.

  1. View of all epics with count of sub-tasks, grouped by sub-task status:
    image2017-3-15 16:8:5.png
  2. List of Epics with sub-task in specific status, just add a filter to the same structure above:
     image2017-3-15 16:9:51.png
0 votes

Better Excel Plugin can provide both views with a custom Excel pivot table.

What you want is actually relatively close to one of the default templates (that you could customize) that calculates a pivot table and renders the below stacked bar chart from the Story Points of the stories of an Epic:


Your second use case would be just a filter on the Status dimension.

Another option here is Pivot Report add-on. We have created it for Epic overview first and after that just extended with other options. 
It works with Epic/Task/Sub-tasks, Boards and JQL/filters.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

631 views 4 15
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot