Sum of all Story points of the Tasks based on EPIC label

[Harsha M S]

I am trying a way to showcase the effort of work into different categories based on the EPIC label and calculating the sum of story points associated with that label.

Example:

EPIC 1 - LABEL1

    |- Task - Storypoints x

    |- Task - Storypoints y

EPIC 2 - LABEL1

    |- Task - Storypoints x

    |- Task - Storypoints y

EPIC 2 - LABEL2

    |- Task - Storypoints x

    |- Task - Storypoints y

Output

Label1 - EPICs Sum of Tasks Storypoints - 80%

Label2 - EPICs Sum of Tasks Storypoints - 20%

[Hannes Obweger - JXL for Jira]

Hi @Harsha M S

if you're open to solutions from the Atlassian Marketplace, I think you'd get pretty close 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 e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view, group by, and sum up any other field(s), configure different sum-up styles (like min, max, average), etc. etc.

Any questions just let me know,

Best,

Hannes