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.