Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

How to roll up story points from Stories to Epic in company managed projects

Hi,

We have a company managed project so my only option is to use Automation. I am trying to roll up story points from all child stories and tasks to the parent epic. 

We use only one level of heirarchy i.e. parent to story or a task. Story or task will not have further breakdown. 

Also, if child story or task have change in story points that should trigger the epic story point to automatically update. 

Will appreciate help with this as it will make reporting the status a lot easier without manually summing up using excel to track changes at epic level. Thanks!

3 answers

2 accepted

1 vote
Answer accepted
Marc Koppelaar
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.
Oct 13, 2023

Hi @AT 

Yuu could setup an automation rule as follows:

If you use issue link parent

Automation screen shot.png

The edit issue fields action should look like:

Screenshot 2023-10-13 at 17.44.23.png

If you run into an issue relating to that the sum is zero, replace the "parent" in the Lookup issues action with "Epic Link" 

Keep the quotes, they are reuired.

@Marc Koppelaar Thank you! I appreciate it so much. I have looked at other responses on questions that similar to mine but the amount of information was overwhelming for a relatively newer project admin like me. This made it super easy and as you mentioned I had to use Epic Link instead of parent to get the sum.

It works great. Is there a way to trigger this automation for all existing epics so that story points roll up to them? Again, thank you.

Like Marc Koppelaar likes this
Marc Koppelaar
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.
Oct 19, 2023

HI @AT 

You could create a copy of the rule use the manual trigger, to start the rule.

Provide the correct fitting JQL clause in the manual trigger, to action on issues the are already done

Like AT likes this
Jerry Esquivel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Nov 01, 2023

Hi @Marc Koppelaar this has been really helpful for me as well. Instead of making multiple copies of the automation is there a way to set one automation that will trigger all the epics to update?

Marc Koppelaar
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.
Nov 02, 2023

Hi @Jerry Esquivel 

Are you pointing to copies of the rule for each project.

The scope of the rule can be set to all or multiple projects, this requires Jira Admin permissions.

Jerry Esquivel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Nov 02, 2023

Got it. Thank you! @Marc Koppelaar 

Like Marc Koppelaar likes this

Hello Marc, for this same automation how can I set it such that instead of all child types, only story points for stories and bug issue types is rolled up. Adding 'story, bug and epic' under 'Issue type if not one of' did not help. 

Thanks!

Marc Koppelaar
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.
Nov 29, 2023

Hi @AT 

Change the condition on issue type to: Issue Type is one of Story,Bug

0 votes
Answer accepted
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Oct 14, 2023

Hi @AT

I trust that you find a solution for Jira Automation based on the great answers above.

Just to point out an alternative direction: If you would prefer a more "real time" view on your epic's total story pointers - i.e., updating immediately as you change the story points on your stories - you may want to have a look at Advanced Roadmaps, which is part of Jira Premium.

Alternatively, there's a number of Marketplace Apps that can help with this, too. E.g., this is how this would look in the app that my team and I are working on, JXL for Jira:

epic-story-points-sum-up.gif

(This works with all fields, and also based on different issue grouping and hierarchy configurations.) 

Note that neither Advanced Roadmaps nor e.g. JXL actually store the summed up story points on the epic, so you somewhat rely on their specific views to see them.

Best,

Hannes

Thank you Hannes! I checked out the advanced roadmaps after your response and set one up for our project. Our PO loves it and it provides a real time view that we were looking for. 

4 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 13, 2023

Hi @AT ,

There are a lot of posts in the Community on this with very good discussions and solutions already. As well there is an Automation template provided by Atlassian that could work. If you have some unique needs please let us know where the current solutions fall short.

2023-10-13_11-27-57.jpg

Here are the details of this template.

2023-10-13_11-31-59.jpg 

 

Here is one of many Community posts - Sum-up-story-points-in-epic . Feel free to use the search bar for more posts as needed; "sum story points epic" should work.

 

 

Suggest an answer

Log in or Sign up to answer