How to sumif estimates on specific sub-task types

[Michael G_]

I'm trying to sum numerical fields on sub-tasks at the parent level if the sub-task is of a particular sub-task type (we've setup new sub-task issue types).

I've managed to setup automation that sums up all sub-tasks regardless of sub-task type, but I need to be able to narrow it down further. Here's the snippet I use for the additional fields:

{
"fields": {
"Sum Back-end Estimates": {{issue.subtasks.Story Points.sum}}
}
}

 I want it to be more like

{
"fields": {
"Sum Back-end Estimates": {{issue.subtasks.Story Points.sumif(issue.subtasks.issueType.name,"Back-end Sub-Task")}}
}
}

[Bill Sheboy · Accepted solution]

Hi @Michael G_ 

There are at least a couple of ways to do this:

1. using JQL to find the subtasks you want (which have the trigger issue as parent), use the lookup issues action to gather and sum the values
2. using an mathematical expression, an iterator on the subtasks, and conditional logic on the issueType, sum the values

I recommend trying the first one.

Kind regards,
Bill

[Michael G_]

Ah, using the look up action and then the corresponding {{lookupIssues}} resolved it. Thank you!

[Jamie Spatz]

I need a similar thing, Michael can you post a screenshot or text of the rule that you ended up writing for this? I'm not 100% clear on how one can use the lookup issues function here. 

[Michael G_]

the general flow goes:

1. When Value changes for {field}
2. Issue Type is one of {sub-task}
3. For Parent
   1. Then: Lookup issues: issuetype = "Sub-Task" AND parent = {{triggerIssue.parent}}
   2. And: Edit issue fields

{
"fields": {
"Sum Estimates": {{lookupIssues.Story Points.sum}}
}
}