nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Diana Gorv

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.

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:

Accepted answers

Uday Kiran Bhaviri_cp1r58

Hi @Diana Gorv

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

All comments

Uday Kiran Bhaviri_cp1r58

Hi @Diana Gorv

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

Diana Gorv

@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:

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

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)

Diana Gorv

@Stepan

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

addon-com.almworks.jira.structure

data-center

formula

jira-software-data-center