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

Help Needed: Automation Rule to Sum Child Issues' Fields and Update Epic

Krista Woolhiser
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!
May 23, 2024

Hi everyone,

I'm trying to set up an automation rule in Jira to sum a custom field "Order Quantity" of all child issues and update the Epic's "Order Quantity" field with the total. I've followed several steps but can't seem to get it working correctly.

Here's what I've tried:

  1. Scheduled Trigger:

    • Set up a trigger to run daily.
    • JQL query: issuetype = Epic.
  2. Branch Rule for Child Issues:

    • Added a branch rule for related issues.
    • Chose For Children.
  3. Create Variable to Sum Order Quantities:

    • Inside the branch, added an action to create a variable totalOrderQuantity.
    • Used the smart value: {{issue.fields."Order Quantity".sum}}.
  4. Edit Epic to Update Order Quantity:

    • Added an action to edit the Epic after the branch.
    • Set the Epic's "Order Quantity" field to {{totalOrderQuantity}}.

 

Is anyone able to pinpoint what I'm doing wrong or guide me on an easier way to achieve this?

 

Screenshot 2024-05-23 at 7.33.03 PM.png 

1 answer

1 vote
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 23, 2024

Hi Krista - Welcome to the Atlassian Community!

Here's an example of one that I use that probably does the same thing, except that I am doing an average instead of a sum. 

Screenshot.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events