Sum up story points from all epics to parent issue

Joost Klykens December 3, 2021

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 

2 answers

1 accepted

1 vote
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 3, 2021

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

Joost Klykens December 3, 2021

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

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 3, 2021

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.

Joost Klykens December 8, 2021

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
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 8, 2021

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

Tim Lankford April 5, 2022

@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
Sarah Shoemaker September 8, 2023

Hello, I have a slight variation on this question. I'd like to Sum up the points from the Epics *only if* they match a certain custom field.

So if the total story points is 100, I'd like to know (perhaps in another field) if 50 of them are from Epics with a "Q3" label.

Is this possible?

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 9, 2023

Hi @Sarah Shoemaker -- Welcome to the Atlassian Community!

First thing, please consider making a new question for something like this...and linking back to this original thread.  Otherwise only the people following this older one will see your question to offer suggestions.  Thanks!

Back to your question...

If you are using Jira Cloud (or Jira Data Center) versions of automation rules, you have the Lookup Issues action with JQL.  And so you could add that check on labels to the JQL to limit the issues summed up.  Another way to do this is to with smart value, list filtering and math expressions.

Kind regards,
Bill

Sarah Shoemaker September 11, 2023

Thanks Bill! Appreciate your quick response. I've asked my question more specifically here. 

https://community.atlassian.com/t5/Jira-questions/Can-I-sum-story-points-from-different-projects-in-each-Epic/qaq-p/2472545

1 vote
Jordan Richter October 17, 2023

This method works for me. I'm using this to sum all child Epics' story points to the parent Initiative's story points field. This is in tandem with Advanced Roadmaps, so I'm using the Parent Link field instead of an Issue Link fields.

Story points from Epics to Initiative.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events