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

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,551,904
Community Members
 
Community Events
184
Community Groups

Jira Automation: Complete Video Guides on how to Sum Up Story Points between Subtasks/Stories/Epics

Eli Solutions Team -Eli Solutions-
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Jul 05, 2021

Hi Everyone,

One of the most commonly asked questions we receive here in the Jira Automation is whether or not it is possible to sum up story points between Subtasks/Stories/Epics. We are very excited to announce that we have posted 2 new video tutorials that will help you accomplish this step by step.

Sum Up Story points from Stories to Epics:

  • Video Tutorial Link:  https://youtu.be/PROcxEOMyGM 
  • Sum Up Story Points from Stories - key Formulas:
    • JQL Lookup: issuetype in (story) and "Epic Link" = "{{issue.Epic Name}}"
    • Sum Up Story Points: {{lookupIssues.Story Points.sum}}
  • Sum Up Story Points when an Epic Link is updated in a story - Key Formulas:
    • JQL Lookup: issuetype in (story) and "Epic Link" = "{{issue.Epic Name}}"
    • Sum Up Story Points: {{lookupIssues.Story Points.sum}}
  • Sum Up Story Points through a Scheduled rule - key Formulas:
    • Scheduled JQL which can be updated as you require: issuetype in (epic) and status not in (done)
    • JQL Lookup: issuetype in (story) and "Epic Link" = "{{issue.Epic Name}}"
    • Sum Up Story Points: {{lookupIssues.Story Points.sum}}

 

Sum Up Story Points from Subtasks:

 

You can use the first tutorial to update any type of relationship by modifying the conditions and JQL Lookup Issues filters. (e.g. Adding Story Points form an Epic to an Initiative)

We hope you enjoy the videos.  Please support the channel by subscribing to it.

 

Thanks,

Eli Solutions

3 comments

The videos are great.

Thanks for sharing!

Thanks for pulling this information together.  For those of us using server/DC installation, the lookupIssues function is not supported... any suggestions on alternate methods, specifically to sum up story points into the parent Epic?

@Eli Solutions Team -Eli Solutions-  any suggestions on troubleshooting this?

I have my automation set up exactly the same way you showed in the video, and it's not working for me.

Thoughts? 

Eli Solutions Team -Eli Solutions-
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Jan 28, 2022

Hi @Jon Zacharias

You need to use the correct capitalization for trigger issues. 

Use with the capital "I".

{{triggerIssue}}

Like # people like this

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events