Structure: How do I get the sum of the child issues with the same team?

Diana
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.
February 20, 2024

I'm trying to get the sum of story points, but only if the parent issue and the child issue are assigned to the same team. See screenshot example. 


teamAFeature.PNG

I have the structure grouped by team. Feature 4 is assign to Team A and it has 5 child stories. But there's 1 story assign to Team B. 

How do I get the formula to work so that Team A total story points reads as 10 and not 11?

Currently my formula:

formula.PNG

1 answer

1 accepted

0 votes
Answer accepted
Uday Kiran Bhaviri
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.
February 20, 2024

Hi @Diana Gorv 

I think you can check for condition if Custom Team = "Team A" then sum up all points.

Diana
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.
February 20, 2024

@Uday Kiran Bhaviri Thanks for the quick response.

Unfortunately, that won't work. The formula needs to grab whatever is the parent's team and check to see if its child issue are also the same team, because we're looking at more than just Team A. 

See this screenshot example:

morethan1team.PNG

For the grouping in Team B as an example, Team B's should total to 4 points if we exclude the story that's assign to Team D. 

Basically, I'm trying to get the formula so that if the parent issue and its child issues are the same team, then add up the story points.

Stepan Kholodov _Tempo_
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.
February 21, 2024

Hello @Diana Gorv 

You can try adding this part in front of your original formula:

if customteam = parent#level=-2{summary}: 

the formula will check if the Custom Team value of an issue matches the name of the group it's placed in and if it does, then the formula will extract Story Points of linked issues. Please note that the hierarchy matters in this case - the formula specifically references the level of the parent, so it would need to be changed if the hierarchy changes.

I hope this helps. Please reach out to us directly at our support portal if you need help with Structure in the future.

Best regards,
Stepan
Tempo (the Structure app vendor)

Like Uday Kiran Bhaviri likes this
Diana
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.
February 21, 2024

@Stepan Kholodov _Tempo_ 

Thank you! This is exactly what I need.

Final formula is:

if customteam = parent#level=-2{summary}:

issueLinks.MAP(
IF($.type='derivation' AND $.source.team = $.destination.team,
storypoints))

With option 'Sum over sub-items' checked.

Like Uday Kiran Bhaviri likes this

Suggest an answer

Log in or Sign up to answer