Can I sum story points from different projects in each Epic?

[Sarah Shoemaker]

1 Epic may have tasks from multiple software projects assigned to it. I have an automation set up to sum up the total story points from all of those tasks in the Epic, but I actually want to see the # of story points from each project within the Epic.

For example:

- Example Epic has a total of 20 story points in the tasks within it.

- 5 story points are tasks from Project A

- 15 story points are tasks from Project B

- I want to be able to track somewhere that the 20 story points are 5 from Project A and 15 from Project B

Does anyone know how to do this? Some combination of smart numbers, custom fields, and automated rules?

[Hannes Obweger - JXL for Jira]

HI @Sarah Shoemaker

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

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).

If you want to see the issues of only one epic, you can use JXL's column filtering capabilities to quickly narrow down to the specific epic you are interested in.

Any questions just let me know,

Best,

Hannes

[Sarah Shoemaker]

Sorry Hannes, I don't have purchasing power. Trying to do this with smart values if I can.

[Sayed Bares [ServiceRocket]]

@Sarah Shoemaker Welcome to Atlassian community!

Would you like to show the story points in the Epic issue? or somewhere in Project A or Project B?

[Sarah Shoemaker]

I imagined I'd show the story points on the Epic issue... so that I could see how many points were assigned by project right on that Epic and maybe display the info across many Epics on a dashboard as well.

[christopher_branaman]

I am also interested in this! Currently I have a working automation that will show total story points for an Epic.

But what I just realized is that it is not pulling in stories from another board, even though they are both linked to the same Epic. Here is my current setup for my Automation 

Lookup Issues - issuetype in (story,bug,task) and "Epic Link" = "{{issue.key}}"

Smart Values condition - {{lookupIssues.size}}

Edit Issue - {{lookupIssues.Story points.sum|0}}

My assumption was that all cards from the Parent would be pulled in and totaled regardless of which project board they live on.

[Bill Sheboy]

Hi @christopher_branaman 

Although automation rules with a single project-scope can create (or clone) issues into other projects, they cannot access or update issues in other projects.  Instead the rule needs to be multiple-project or global-scope.

Please work with your Jira Site Admin to change the scope of your rule to be multiple-project so it can access the other issues with the Lookup Issues action.  When you do this, you may need additional conditions in your rule to manage the behavior, as needed.

Kind regards,
Bill