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")}}
}
}
Hi @Michael G_
There are at least a couple of ways to do this:
I recommend trying the first one.
Kind regards,
Bill
Ah, using the look up action and then the corresponding {{lookupIssues}} resolved it. Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the general flow goes:
{
"fields": {
"Sum Estimates": {{lookupIssues.Story Points.sum}}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.