Workload by assignee in backlog view: show story points of ALL tickets in sprint

[Gaetan]

Hi Atlassian community,

We use a company-managed Jira project. In the backlog view, for on-going sprints, we often refer to the "Workload by assignee" pop-up to check the total workload in the sprint:

Problem: it seems that issues with a status in "Done" category as not counted in the Story Points column, although they are counted in the Issues column.

This is inconsistent and misleading. The Story points column should display all the story pints in the sprint, no matter the status of the corresponding issues.

Could you please fix this, or let me know a way to configure the Story points count differently?

Thank you

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

There's nothing to fix here, the display is telling you what you really need to know.  If an issue is "done", that really does mean "there is no more work to be done on this", so you no longer care what the estimate was - it's effectively 0 because you've finished the issue.

If the story points showed you all the done issues as well, you would not be seeing a workloard report, you'd just get a flat report on "what we said we would do during a sprint", which you can get from the Velocity report already, it wouldn't give you any workload information any more.

[Gaetan]

What I need to see at a glance is the total workload planned in the sprint, regardless of ticket status.

So where can I get the information easily, summed up for each team member?

[Marc Lehr]

Exactly, that's what we need as well, directly from Atlassian.
These different SP number displays are misleading everyone on our side as well.

[Gaetan]

I've tried to produce the intended result with custom dashboards, but there seems to be no way to simply sum up the values of a field (in this instance: Story points) by assignee.

Either I'm missing something fundamental in Jira Cloud, or a basic "pivot" feature is missing here.

[Hannes Obweger - JXL for Jira]

Hi @Gaetan

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using 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 build a view like this in just a couple of clicks:

This uses a two-level grouping to narrow down to a particular sprint, but as every JXL sheet is, ultimately, powered by a JQL statement, you can also just pull in the issues of the sprint you are interested in. As you can see, this view is fully interactive, meaning that you can work on your issues directly in JXL (but also trigger various operations in Jira, or export your data to CSV or Excel in just a click). 

Any questions just let me know,

Best,

Hannes

[Gaetan]

Thanks Hannes, this looks good. However, we're looking for a free / built-in solution (we've got many more than 10 active users).