The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi,
I have many customers that are looking to sum up Story points and other custom number fields from stories to their epics.
Waiting for this feature to be deployed: https://codebarrel.atlassian.net/browse/AUT-476
The current status is "deployed to cloud" - is it available for use on Jira cloud? what's the chosen code for that?
Thanks,
Elad.
This rule works on my case and it may help you.
This works for me. Thank you.
One question though. How to apply this to more then 1 epic?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The way Carlos has this set up is it works for any epic within the given project you're working with and keys off of as soon as a story point value has been updated that has an epic link.
Well done Carlos, thank you for figuring out this functionality.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Carlos - Thank you for the screenshots, however i get an error when I use the syntax for Epic link. Any thoughts, please.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
For me this solution unfortunately did not work, the automation even runs successfully, but even if the stories are with values greater than 0, the automation is always 0 in the epic, it doesn't work.
Can you help me?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Andreza Santostry using "Parent" instead of "Epic Link" in the Lookup Issues component. I had the same zero sum problem, and this change worked for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Carlos Treminio your suggestion works a treat. Was struggling to get this working so thank you for the assist
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi folks - I implemented Carlos' solution and it works like a charm! Thanks Carlos! :)
Having said that, I ran into a couple of scenarios where the Story Point totals get misaligned...
In each of the above cases, the Story Point totals do not get updated on the Epic(s).
So, to address these use cases, I created an additional Automation that gets triggered when a Story is updated. It checks to see if the Epic Link was changed, captures the changed To/From values and recalculates the Story Point totals accordingly.
Here are the Automation settings I used...
I hope this helps!!! ...Cheers! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you very much for this detailed automation.
One question though: when I create the Branch Rule inside the "If/Then" block, it opens a new nested branch ("For JQL"). Should the following statements be inside that nested branch?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Didi Goldbart - Yes, that is correct. ...you'll have two separate IF blocks, one for the EpicLinkChangedTo (just as you depicted above), and another for the EpicLinkChangedFrom. Here's a screenshot of the entire Automation Rule...
Also, I ended up adding a 3rd Automation to handle the use case where a child ticket gets Deleted. Here's a screenshot of that Automation Rule as well...
I hope these help. Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Guy Anela - This is very helpful, thank you very much (great catch adding the deleted child rule)!
I'm having some issues with the 2nd automation, its seems that an error occurred. I went over the definitions and they seems correct. Do you have any idea how do I inspect those errors? I couldn't find a log or other entry with the error details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Didi Goldbart - Glad it was helpful.
As far as the error, you should be able to track things down by viewing the Audit log. You can expand the Show more information for the specific execution and see the Conditions that were met and the Actions that were taken...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Elad Ben-Noam ,
Thanks for your message. John from the automation team here.
This new feature has indeed shipped last week. We are just putting a blog together right now to inform customers.
We will also be running through this new feature in a webinar on June 11th: https://www.atlassian.com/webinars/software/how-to-supercharge-your-automation-in-jira-cloud
Below is the smart value you could use. However, keep in mind that at the moment it will only work for summing up subtasks to the parent rather than stories to the Epic.
Hope that helps but any questions, just let me know.
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That is great! @John McKiernan when is it planned to add support for summing up values from stories on epic level?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Glad it solves a problem @Sebastian Nordin !
I haven't got a date for this just yet but will make sure to update this page once that ships :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John - Any updates on when JIRA will support summing up values from stories/tasks/sub-tasks on epic level?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm afraid not @Sameer P though if you check out the comments on this post from the engineer who built it, you might find a workaround: https://community.atlassian.com/t5/Automation-articles/How-to-sum-up-logged-hours-using-automation-in-Jira-Cloud/ba-p/1409115
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@John McKiernan Can you please give a 2022 update on this feature? I tried your smart sum on a simple parent/child task relationship and it fails with the error: is not a number
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am just implementing something like this for my client. The original automation outlined by @Carlos Treminio worked perfectly for me!
I added one additional condition though as my client wanted to exclude any issues that are in the "Done" status category. Thought I'd share in case others are interested in the same use case.
In order to achieve this I:
This will monitor the Status of issues and exclude the story points of those issues that are closed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I followed this video and the automation kicked in but for some reason it makes the story points in the Epic 20 points regardless of how many points I put in the tasks. Any ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the Epic I get 20 points, so I went through the issues and added silly points like 88 and 23 and I get the correct number in the 'estimate' field but not in the Story Point field.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Epic status by Story Points report in Jira that can also be displayed in Confluence
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the meantime, you can see total number of story points on an epic by following these steps:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
John McKiernan Can you please confirm the above is the right way to get the total story points on an epic?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Everyone, In this roundup we combine all the jira automation rules to sum up story points across different issue types. We start from the lowest level, summing up story points from sub-tasks t...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.