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?
One manual, but painless approach to solve this:
(Discl. it is a paid and supported app developed by our team.)
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,
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,
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,
If you are fine with a mktplace app for a readymade solution, you can try out our add-on
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
- Group you results to get more out of the data
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
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