Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,065
Community Members
 
Community Events
168
Community Groups

Sum up story points from all epics to parent issue

Hi,

 

I would like to sum up the story points from all epics to their parent issue. The previous admin created a parent level (standard issue types, he called 'feature') above epic level to reflect the application structures. All applications are first divided into modules (-> feature) and then into functionalities (-> epic). 

I got the sum-up automatisation for subtasks to stories and for stories to epics but don't find anywhere how to sum-up the epics story points into the 'feature' issue type. I suppose it should be a variation on the sum-up of subtasks to stories but can't get it working.

Current formula in 'Edit issue Advanced' is (previous part is when value changes for Story Points, branch rule = 'For Parent'):

{
"fields": {
"customfield_10032": {{#=}}{{epics.customfield_10032.join(" + ")}}
{{/}}

}
}

 

'customfield_10032' = 'Story Points' field

'epics' in the formula is variation on 'subtasks' I use this to sum up subtasks to stories and there it works. In my case the epics are subtasks from my 'feature' level but of course this doesn't work...

 

Anybody who can help with this please? I would 

1 answer

1 accepted

1 vote
Answer accepted

Hi @Joost Klykens 

To do this with automation, I recommend using a JQL statement to gather the epics with the Lookup Issues action.  You may then get the sum with: {{lookupIssues.Story points.sum|0}}

Kind regards,
Bill

Hi Bill,

 

Thank you for the quick response. Could you give some more details please since I can't get it working and did try different variations of Lookup Issues action. Added a picture of the latest variation.

 

sumup epic points.jpg

 

Thank you very much in advance,

Joost

Hi, Joost.

You are very close to solving this!  The key here is how do you connect your features and epics: custom field, parent, link etc.?  Then write a JQL statement that selects all the siblings.

For an example patterned from your rule image and assuming use of Parent Link:

  • trigger: story points change
  • condition: issue type is epic
  • lookup issues on JQL to get the siblings: "Parent Link" = {{triggerIssue.Parent Link}}
  • branch on JQL to select the feature: key = {{triggerIssue.Parent Link}}
    • action: edit the story points in the feature to be the sum from the lookup
      • {{lookupIssues.Story points.sum|0}}

Please review/update the JQL expressions if you want to add other conditions.

Hello Bill,

 

Apology for the late reply due to sickness. I (of course) made it at first too difficult but got it now and it worked for the level above also! My solution in screenshot, I hope it's a good approach since I didn't use JQL before. Triggering from sub-task to feature works like a charme!

Epic to Feature SP sumup.JPG

 

Thank you very much,

Joost

Like Bill Sheboy likes this

Well done!  Please consider marking this question as answered to help others find solutions faster in the future.  Thanks!

@Joost Klykens @Bill Sheboy 

Thanks for this post!  I was searching for awhile and trying different automation methods to do this but the method above worked!

 

Thanks again,

Tim

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events