Scheduled Automation to sum up story points linked to an Epic

[NandaKumar Subash]

Hi All,

I have done an automation to sum up all story points linked to an Epic by following the steps in the below documentation. This works perfect when the issue is created/transitioned.  

Automation to sum up story points of Stories in different statuses and add the value to the parent | Jira | Atlassian Documentation

I wanted to do the same calculation of all existing epics (like an one time scheduled triggered) without issue being created/transitioned. The same steps are not working for the scheduled trigger (no errors but the values are not getting returned), can someone help? Thanks in advance.  

[Mehmet A _Bloompeak_]

Hi @NandaKumar Subash

Welcome to the Atlassian Community!

As an alternative to automation, you can try Sum Up Reports for Jira app developed by our team. This app provides various table reports based on the fields you choose.

• You can list the issue fields you want and sum up the values at the bottom.
• You can group your data on any field (sprint, status, assignee, component, project etc.) and sum up the field values (story points, time estimate etc.) or take averages.
• You can add this app as a gadget to your Jira dashboards.

Here is our live demo dashboard where you can see and modify any sample report and play with it.

For further details, you can have a look at Sum Up and Average Reports in Jira Dashboards article.

If you have any questions, feel free to schedule a demo with us.

 Hope it helps.

[Trudy Claspill]

Hello @NandaKumar Subash 

Welcome to the Atlassian community.

For a one time (or periodic) recalculation for all Epics you would need your Schedule trigger to use a JQL that selects the Epics.

The next step in the rule would be a Lookup Issues action with a JQL to get all the child issues of the Epic.

Parent={{issue.key}}

The last step would be an Edit action to edit the field in the Epic to insert the sum of Story points of the retrieved child issues.

{{lookupIssues Story points.sum}}