Is there a way to get the sum of the Original Estimates of all sub-tasks planned into a Sprint?

Question

The reason for this:

We do 'Capacity Driven Sprint Planning'

We estimate our Backlog Items (e.g. Stories) in Story Points

We then break down the Stories into sub-tasks and estimate those sub-tasks in time.

Our 'Capacity Driven Sprint Planning' technique then finds the availability of each team member for the Sprint (e.g. assume 1-week Sprints for simplicity and assume 3 Developers on the team: Developer A has 30h availability, Developer B = 30h, Developer C = 20h)

So total team capacity for the 3 Developers = 30+30+20 = 80h

And so it would be nice to cross-reference the Developers' total capacity with the sum of all the Original Estimate on all sub-tasks, just to confirm 'the work will fit'

Francis Batilo_vmnw04 · Accepted Answer

Hi @Darren

A similar inquiry has been answered by one of our Atlassian Community Leaders, Trudy.

You'll just have to tweak her screenshot to align with your requirement of only taking issues within your sprints.

Here's the link to the thread: Solved: Sum up rough estimation, original estimation and t... (atlassian.com)

I hope this helps

Cheers,
Francis

Danut M _StonikByte_ · Accepted Answer

Hi @Darren,

This should be possible with our Great Gadgets app.

First, you need to create and save a filter that returns the subtasks from your sprint, with a JQL like this:

sprint = "Your Sprint" and issueType in subTaskIssueTypes()

Then, you can configure the Issue Filter Formula Gadget or the Advanced Issue Filter Formula Gadget offered by our Great Gadgets app to calculate the SUM of Original Estimate field and to display it on your dashboard, as in this example:

Please note that the above JQL works only for company managed projects. Due to a limitation of Jira Cloud (see JSWCLOUD-18394)), in team-managed projects the subtasks cannot be filtered by sprint. So you'll need to find a different method to filter the sprint subtasks.

With this plugin you can track many other things, especially agile projects. Take a look on our blog to make a better idea.

I hope this helps.

Danut.

Hannes Obweger - JXL for Jira · Accepted Answer

Hi @Darren

from your description of your planning approach, I think you might like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can easily view the overall estimates of your sub-tasks, but also view the estimates per developer in just a few clicks, like so:

I have some estimates on story/bug level here, but this shouldn't make much of a difference.

JXL is an incredibly flexible tool, so if you want to e.g. group by any other field, or do any other kind of sum-up, you can do that do.

Any questions just let me know,

Best,

Hannes

RVS_Support · Accepted Answer

Hi @Darren

If you are open for a mktplace app, you can try out the one we have developed for the same use case.

Capacity Planner

The app allows to store the capacity for individual users and save as templates. which can be mapped to a sprint to track the allocation and remaining time per user. Do try it out.

Disclaimer : I am part of the team which developed this app