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; } } }

Sum up original estimates from stories to Epic

Nicole.Selph

I have searched the community threads on this issue, but it seems that the problem that I am facing has not been answered to my specific situation, so starting a new question.

I am trying to set up an automation that will sum up the original estimate of stories to their linked Epic (Parent). I have set up the rule, and it notes that when run, it is a success, but no changes are apparent. Not sure what I am doing wrong here; I may be going crazy!

Here is my rule

Sum of Original Estimate.PNG

Hoping the community can help me figure out the issue, as I am sure its something small that I am overlooking.

Note: our original estimate is set to hours so using the divide by 3600

Accepted answers

Kalyan Sattaluri_iinm1n

Hello @Nicole.Selph

Are you trying to Sum up estimates from Story to Epic?

If so, your current rule is trying to add subtask values to Epic. Which is not correct and nothing will be updated.

To correct this, inside your branch, first thing you need to do is lookupIssues with "Parent" = {{issue.key}}

Then your total is, {{lookupIssues.remaining estimate.sum}}

And you can assign it to your epic as {{#=}}{{lookupIssues.remaining estimate.sum}} / 3600 {{/}}

All comments

Kalyan Sattaluri_iinm1n

Hello @Nicole.Selph

Are you trying to Sum up estimates from Story to Epic?

If so, your current rule is trying to add subtask values to Epic. Which is not correct and nothing will be updated.

To correct this, inside your branch, first thing you need to do is lookupIssues with "Parent" = {{issue.key}}

Then your total is, {{lookupIssues.remaining estimate.sum}}

And you can assign it to your epic as {{#=}}{{lookupIssues.remaining estimate.sum}} / 3600 {{/}}

Nicole.Selph

Hi @Kalyan Sattaluri

Thank you so much for responding! Pardon my ignorance though, I am not sure where to go to do the lookup issues, so not sure where to correct my rule. This is my first time creating rules, so I am not great at understanding the complexities yet.

Apologies, if my question is silly

Kalyan Sattaluri_iinm1n

Hi @Nicole.Selph

After your Branch statement, delete existing Edit issue step, and below:

Add Component -> Then: Add an action -> Select "Lookup Issues"-> Give JQL => "Parent" = {{issue.key}}
Then Add Component -> Then: Add an action -> Select "Log Action"-> Enter => {{lookupIssues.remaining estimate.sum}}
Finally, Edit Issue -> Choose "Total Effort" and give below as value:

{{#=}}{{lookupIssues.remaining estimate.sum}} / 3600 {{/}}

Kalyan Sattaluri_iinm1n

Should be like below, run rule and share audit log..

Mehmet A _Bloompeak_

Thanks to @Kalyan Sattaluri for detailed explanation of the automation rule.

@Nicole.Selph, as an alternative to automation you can use Sum Up Reports for Jira app developed by our team. It provides a dashboard gadget and you can view multiple fields summed at the same time. The app does not modify your epic fields. Instead it displays the results on the fly in your dashboard.

sum of remaining estimate by epic.png

Hope it helps.

Oksana Kolesnyk

Hello.
Could you help me to find the total Effort?
I do not see such a field in my Jira.
Is is a custom field?

Bill Sheboy

Hi @Oksana Kolesnyk -- Welcome to the Atlassian Community!

Yes, "Total Effort" was a custom field added by the person who originally asked the question.

Kind regards,
Bill

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

automation