Calculate field in Parent using values from Childs

Nawaaz SOHAWON

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?

 

Trudy P Claspill

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