nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What is the easiest way to automatically sum up story points from child issues to the parent epic?

john_howard

Ideally I'd like to have Epics present totals for:

Todo Points: ( Summed story points from all issues, for this epic, whose status is not In QA nor Done )

Total Points: ( Summed story points from all issues for this epic )

Percent complete: ( ( 1 - ( Todo Points / Total Points ) ) * 100 )

Just some basic summations and calculations; which are easily done in SQL or with databases, yet I have not found any straight forward way to do this in Jira ...

Accepted answers

Bill Sheboy

Hi @john_howard -- Welcome to the Atlassian Community!

You could do this by adding custom fields to your epic and updating them with a scheduled automation rule. Maybe something like this:

Trigger: scheduled with JQL to check just the epics that are not done/completed
Action: lookup issues with JQL for issues in the epic.

"epic link" = {{issue.key}}

Action: create variable (varTotalPoints) to sum up the story point total.

{{lookupIssues.Story Points.sum}}

Action: lookup issues with JQL for open issues in the epic.

"epic link" = {{issue.key}} AND status NOT IN (QA, Done)

Action: create variable (varTodoPoints) to sum up the story points ToDo.

{{lookupIssues.Story Points.sum}}

Action: edit the epic to set the values, including your percent complete

{{#=}}(1 - ( {{varToDoPoints}} / {{varTotalPoints}} ) ) * 100{{/}}

Please see these sources for documentation and some example rules:

https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

Best regards,

Bill

john_howard

Thanks for the follow up.
Re. " "Epic Link" = {{issue.key}} " --- this is under the "For Parent" branch thus this is looking up issues where the "Epic Link" of the child issue matches that of the parent issue.key. That is the "issue.key" is the key of the Epic. And this does seem to be working since all of the appropriate child issues are found per the Audit Log.

This is a Classic project on Atlassian cloud. Something also odd that I've noticed is that although the Audit Log shows that the automation ran today, and found the right items, and edited the parent Epic the History for the parent Epic shows only that the automation rule made edits to that Epic yesterday. Is there some limitation to Automation that it can only update an item a certain number of times or something like that?

john_howard

Note -- I've found that setting the Epic points to a value using:
{{#=}} 2 {{/}}
does work fine.
However, setting the Epic points to a value using:
{{lookupissues.Story Points.sum}}
or
{{#=}} {{lookupissues.Story Points.sum}} {{/}}
does not even though the Audit Log clearly indicates that child issues ( lookupissues ) were found and that they do have points ...

All comments

Bill Sheboy

Hi @john_howard -- Welcome to the Atlassian Community!

You could do this by adding custom fields to your epic and updating them with a scheduled automation rule. Maybe something like this:

Trigger: scheduled with JQL to check just the epics that are not done/completed
Action: lookup issues with JQL for issues in the epic.

"epic link" = {{issue.key}}

Action: create variable (varTotalPoints) to sum up the story point total.

{{lookupIssues.Story Points.sum}}

Action: lookup issues with JQL for open issues in the epic.

"epic link" = {{issue.key}} AND status NOT IN (QA, Done)

Action: create variable (varTodoPoints) to sum up the story points ToDo.

{{lookupIssues.Story Points.sum}}

Action: edit the epic to set the values, including your percent complete

{{#=}}(1 - ( {{varToDoPoints}} / {{varTotalPoints}} ) ) * 100{{/}}

Please see these sources for documentation and some example rules:

https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

Best regards,

Bill

john_howard

Thanks @Bill Sheboy . Below is the Automation Rule that I added. The rule runs, and the Audit log shows that it does find the child records, and it does update straight text, however, the calculations do not seem to get the "lookupissues" values nor update the parent Epic:

john_howard

And even though the Audit log shows that a bunch of Lookup issues were found, and I even added a clause to make sure that they all had Story Points ( e.g. AND Story Points is not Empty ) the end result of the update on the parent for Story Points = {{lookupissues.Story Points.sum}}
is:

That's right, for some reason Jira thinks {{lookupissues.Story Points.sum}} = "None"

Any idea why {{lookupissues.Story Points.sum}} would evaluate to "None"?

Bill Sheboy

Hi John,

I noted that you changed the trigger to be from the story level (after a story point change) rather than scheduled.

That probably will work, however please note in your lookup issues JQL, you are testing "Epic Link" = {{issue.key}} That would try to match a story's key as an epic, which cannot work. Instead you want "Epic Link" = {{issue.epic link}} AND...

This may also be why the story points got cleared to "None", because the Lookup Issues is empty (null). When expecting a number to possibly be empty, you may use the default handling like this to replace with zero: {{issue.Story Points|0}

And one more thing to confirm, this is for a Classic project, correct? If it is for NextGen, then use "Story Point Estimate" rather than "Story Points".

john_howard

Bill Sheboy

Oops, sorry that I missed your nesting for the epic link check. You could have used {{triggerIssue.epic link}} instead to be what I intended.

No limits on edits, only limits on executions for global rules and for a "run-away", where the rule execution get halted due to rapid execution looping.

Bill Sheboy

Automation rule smart values are often case-sensitive, so please try this for the lookup:

{{lookupIssues.Story Points.sum}}

Also, try adding some information to the audit log (or add an email send) to dump out the looked up issues:

Count: {{lookupIssues.size}}

The list: {{#lookupIssues}}{{key}}: {{Story Points}}{{^last}}; {{/}}{{/}}

john_howard

Re. "Automation rule smart values are often case-sensitive" --
THANKS @Bill Sheboy !! Yes, that was it -- the small "i" needed to be a capital "I" in lookupIssues -- I was staring at this too long

I'm getting reasonable results now:

However, 4/18 should be 22% so I'm not sure what's going on with this math:
{{issue.Actual Story Points.divide(issue.Story Points).asPercentage}}

Thanks

Bill Sheboy

John, I am glad to hear that worked for you.

If that math results seem unexpected, consider logging the values to see what is up: numerator and denominator. I believe asPercentage rounds (not truncates) so the input values may be the factor.

Marcel Rossouw

Hmm seems I suggested an answer but was trying to reply. My bad - don't know where to delete this answer.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud