Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate field in Parent using values from Childs

Nawaaz SOHAWON
Contributor
February 15, 2023

I need an automation which does the follow:

Trigger: Field value change in CHILD ticket

Branch/related issues: Identification of PARENT through JQL

Action: Update of field in Parent by doing an average of values from the same fields from all CHILD tickets linked to the PARENT

I have configured the trigger and branch/related issue section but cannot find any smart values which retrieves values from CHILD tickets.

Linked Issues have this smart value: {{issue.issuelinks.Issue."FIELDNAME".average}}

Any one ever used the smart value for the parent/child link?

 

1 answer

0 votes
Trudy Claspill
Community Champion
February 15, 2023

Hello @Nawaaz SOHAWON 

I recommend that within the branch you use a Lookup Issues action to retrieve all the "child" issues of the parent. Then you can average the values thus:

{{lookupIssues.<fieldname>.average}}

Suggest an answer

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

Atlassian Community Events