Sum Story Points to Epics with more that 100 children

[Wade H]

Hello, I have automation to sum the story points of children to epics, this has been working fins so far, but now we have epics with more that 100 children and the lookup no longer catches all of them. Has anyone solved for this yet? either using automation or I could use Scriptrunner as well if I need to.

thanks,
-wade

[Rahul_RVS]

Hi @Wade H 

If you are open for a mktplace solution, we have built an app for the same use case.

Issue Hierarchy Reports 

Through this app you can visualize your Epics with multiple child issues. Do Try it out.

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

[Andrew]

Hello @Wade H 

The root case in the automation JQL limit Jira automation actions | Cloud automation Cloud | Atlassian Support "Search for up to 100 issues using an Assets AQL query"

Please, look at this topic Solved: Using Scriptrunner to sum sub-tasks story points t... (atlassian.com)

Regards,

[Wade H]

Hello @Andrew 

Thanks for the reply, Looks like that link is for server. I did follow the link to the cloud version of the script that is referenced but I did not see nay examples of summing story points to epics.

thanks,
-wade

[Andrew]

Hello @Wade H 

Take a look, please Sum Story Points in Jira Cloud with ScriptRunner - Atlassian Community

Regards

[Marlene Kegel - codefortynine]

Hi @Wade H,

I am Marlene, product manager of Quick Filters for Jira Dashboards.  

Another option to sum-up story points under epics would be our Marketplace app mentioned above. 

You can sum-up story points and any other number fields with the following gadgets:

• Quick Issue Statistics gadget
• Quick Two Dimensional Filter Statistics gadget
• Quick Pie Chart gadget

You can check out our app without installation on our demo dashboards. 

[Hannes Obweger - JXL for Jira]

Hi @Wade H

there's actually a number of apps from the Atlassian Marketplace that can help with that, not being subject to any (practical) issue limit. I myself happen to work on an app in which your use case would be trivial to solve: 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), and sum-ups. With these, creating a view like this can be done in just a few clicks:

This works across any hierarchy and/or grouping of issues, with configurable sum-up styles. As you can see above, you can also work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

As said above, there'll be other apps that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know,

Best,

Hannes

[Andreas Haaken _APTIS_]

Hi @wad , 

Do you need the values at the Epic Level for filtering or sorting? 

Are you on Cloud or DC?

[Wade H]

Hello @Andreas Haaken _APTIS_ 
I am on cloud, what i need to get is the sum of all story points for any issue that is a child of an epic, I can do this fine in automation, however now we have more than 100 issues on an epic and the lookup only gets 100

[Andreas Haaken _APTIS_]

Hey @Wade H , 

is something like this what you are looking for?

[Wade H]

Hi @Andreas Haaken _APTIS_ 

That does look nice.

Is that the Epic Sum Up app in the marketplace? I would like to be able to do this without purchasing an app.

thanks,
-wade

[Andreas Haaken _APTIS_]

yes, it is.. the cloud is very limited when it comes to such requirements.

that is why we developed this app.

of course it does a lot more that could be helpful. without any App it could be difficult to achieve.

the are too many limitations. 

[Wade H]

@Andreas Haaken _APTIS_ i will take a look at the app and see what we think. Thanks for the idea.

I will book a demo.