List of stories where all sub-tasks have been completed

[Alfin Ghazali]

Assume 1 story has 4 sub-tasks; each sub-task is assigned to an individual to complete the task.

When I view the story, JIRA page shows % Done so if 2 people (out of the total 4) had completed their sub-tasks, it would show 50% Done.

Now I would like to report or list out a list of stories and its relevant % Done (aggregate number from its sub-tasks).

Could anyone suggest the best way of achieving that e.g. JQL? 

[Stuart Capel - London]

Hi Alfin,

I think you're looking for something like this:

I'm afraid there's nothing to display information like this with the default Jira UI - so I've built a report that can be scheduled to refresh in Google Sheets (same functionality is available for Excel I believe in case you're into Microsoft).

I find the ability to set up a scheduled data dump into Sheets/Excel really helpful for reporting to senior stakeholders, however it is not how I like to run my projects. For that, the visual interface that comes from a Jira Kanban board helps me to run the ship more effectively:

One thing to think about is the work involved in each sub-task. If you add time estimates or story points it will give you a better way to track progress than number of sub-tasks completed alone.

If you want to set up a Google Sheets or Excel report go to

'Issues' in your project

and select 'Advanced Search' (top right of screen).

From here you can filter down the issues to include using basic search or JQL, and there are Sheets and Excel icons to allow you to export the issues. First time round you'll need to install the relevant add-on and allow access so you may need to check with IT.

I love the Google Sheets add-on because it lets me set up a datadump which I build reports off in separate tabs and I can schedule it to refresh hourly (that's the best bit). Of course you wouldn't want that frequency with a large data set - daily and out of hours would be best 

My report is a dump of all the issues in my project, story and sub-task, so that I can calculate how many sub-tasks each story has that are complete or in progress, but to get your required view you can filter for just the Stories.

[Stuart Capel - London]

Here's a link to the report if you want to take a look:

https://docs.google.com/spreadsheets/d/1dAXE8u-uomoP_ZRVL4RkxCXib-PdqaJv77pfbTqNDz8/edit?usp=sharing

[Alfin Ghazali]

Thanks Stuart, that's what I was looking for - the google sheet with scheduler is an awesome solution!

I'm looking forward for JIRA to have an enhancement that would include this information. 

Another question, if not using sub-tasks, how would you set up something similar in JIRA that would come with the OOTB reporting dashboard? 

[Stuart Capel - London]

Hi Alfin,

Excellent - glad you like it!

With regards to the other question, Jira doesn't provide this kind of reporting and I can only give you my take on this. I think it's partly to do with the fact that there are many ways to report of all of the data that Jira can be configured to contain and manage. Jira is highly configurable and extensible, so the different ways of reporting are so numerous that a product feature to suit everyone probably wouldn't be that practical. That's why there is a marketplace for 'add-ons'. Here there are many different reporting products (https://marketplace.atlassian.com/search?category=Reports). Third party developers can create and manage their own solutions - one of them might be exactly what you're looking for! They cost extra though, often based on the number of jira licenses you are using.

The other reason is that Jira is designed to work well for Agile methodologies and they tend not to focus on tracking how many tasks have been completed. Agile delivery is more about estimating how complex the work is and working on sections of work iteratively. It's a big topic - https://www.atlassian.com/agile but it can help teams deliver more value more quickly.

Hope this helps - please mark the question as answered to help others if they have the same questions.