Aggregate Children Based on a Condition

Todd_Levinson March 10, 2020

I'm trying to create a column in a structure that joins the summaries of each issue in an epic based on the sprint each issue is in. For example, I want a comma separated list of all the issues in "Sprint 1". I see how to use an aggregation function to do this for all the issues, but can't figure out if there is a way to aggregate based on a conditional statement. 

1 answer

1 accepted

1 vote
Answer accepted
Egor Tasa [ALM Works]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 10, 2020

Hi Todd,

You can aggregate things conditionally, so the formula you are looking for is probably:

JOIN#subtree{IF(sprint="Sprint 1", summary)}

Note that it works if only one sprint at a time is assigned. If issue is a part of several sprints you'd have to use IF(SEARCH("Sprint 1", sprint), summary) 

Please, let me know if this helps.

Regards,
Egor Tasa

ALM Works

Todd_Levinson March 11, 2020

Thanks so much. This works. In the documentation it uses semi-colons between arguments in the IF function. Are commas and semi-colons interchangable?

Egor Tasa [ALM Works]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2020

Yes, you can use either comma or semicolon.

Regards,
Egor

Suggest an answer

Log in or Sign up to answer