How do I get a list of tasks and a count of the number of sub tasks for each?

[Haydn Robinson]

I need to get a report of how many sub tasks there are for each standard task.  We create sub tasks each time there is an issue reported against a main task.  We are looking to use this to then highlight problem tasks by the number of sub tasks it has.  The more sub tasks, the more problems it has.  I can't find any way or anything obvious to do this.

Can anyone help?

[Aron Gombas _Midori_]

One manual, but painless approach to solve this:

1. Add the column "Sub-tasks" to Issue Navigator
2. Export your issues to Excel with the Better Excel Exporter
3. Add a formula which is:
   1. 0 if the Sub-task column is blank
   2. the count of the ',' characters in the Sub-tasks column otherwise
4. Bingo! 
5. (You can sort the list, you can create a pivot table or chart to find the extremes, etc.)

(Discl. it is a paid and supported app developed by our team.)

[Dave Rosenlund _Tempo_]

Hi, @Haydn Robinson.  As you can probably tell from the other answers, there's no easy way to do what you describe with Jira "out-of-the-box."

Rather than promote yet another marketplace app., what I'd like to do is suggest you learn how to craft the right searches for the right app on the Atlassian Marketplace (although, I am not presuming you don't already know).

This Atlassian Community article, 

How to Evaluate Jira Apps: Advice for Solution-Hunting

talks about how to find the right app.

In your case, I suggest start with "spreadsheet" as your search term. What you describe sounds a lot like what one might do in a spreadsheet-like app designed for Jira.

Make sure you select Jira for "Product" and "Cloud" for hosting type when you search. You also choose how to sort the search results: by review rating, by number sold, etc. And, consider whether your want to filter by apps that are Cloud Fortified. 

Hope this helps,

-dave

[Hannes Obweger - Fine Software - JXL]

Hi @Haydn Robinson

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 issues fields, plus a number of "special fields" that aren't natively available. One of these special fields is the "number of sub tasks".

This is how it looks in action:

As you can see above, you can view, sort, and filter by the number of subtasks. You could also group by the number of sub tasks (and for any other field, by the way) and calculate different kinds of "sum ups" across these groups, or even across complex issue hierarchies. Of course you can export your view to Google Sheets or Excel with just one click, if further processing is needed. Disclaimer: I work on JXL :)

Hope this is helpful,

Best,

Hannes

[Haydn Robinson]

Thanks @Hannes.  I'll have a look at this, could be just what I need!

[Rahul_RVS_Support]

Hi @Haydn Robinson 

If you are fine with a mktplace app for a readymade solution, you can try out our add-on

Issue Hierarchy Reports 

The app shows the child tasks count at each hierarchy level as shown below.
You can also generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number
fields

- Group you results to get more out of the data