Question regarding JIRA Structure arrays

Question

Hi, Need some help from community

I have a JIRA structure hierarchy, where PI (Program Increment) is at top, then there are epic and under epics I have stories. Sprint is one of the fields in stories.

PI

-> Feature 1

------> Story 1             Sprint 1

------> Story 2             Sprint 2

.....

We capture Capacity in the sprint goal. What I want to do is to find sum of the Capacity (story points) belonging to stories under the specific PI.

I am able to create array of distinct sprints using

array#distinct{sprint}

But How do I iterate thru this array to sum up the Capacity corresponding to each sprint?

Any help is appreciated.

Br

Amit

AMIT GULATI · Answer

@Stepan I am able to figure out the solution. Here's what i did

- Create an array of concatenation of all sprints and sprint goals

- Used unique function to filter out duplicates

- Used map and reduce to take out the Capacity from sprint goal in array and sum them up

Thanks for the prompt response.

Stepan Kholodov · Answer

If issues have multiple Sprints, you can group them y Sprints to create proper containers for later aggregating the Goals per Sprint. As a result, issues will be duplicated - one instance per each Sprint and each group will contain relevant issues.

In the formula, you can use an adjustment like this:

sprint.filter($.name = parent{summary}).goal

it will return a single value for each issue, so summing up in the column will be possible.

And as for the format of the returned value - you can omit the text and keep the number using the split() function.

If you need us to have a more detailed look at your setup and recommend something more specific, please submit a support request at our portal.

Best regards,
Stepan

AMIT GULATI · Answer

@StepanThank you. I like the idea of grouping by sprint but I am hesitating in changing the view of the structure to calculate the overall Capacity.

Regarding the first option, since the sprints get repeated for stories, sum over sub-items may not work. I need to calculate the sum of story points for each sprint to be able to roll it up at PI level.

So, If I make an array of (distinct) sprints under the PI, how do I iterate over that array to sum the Capacity captured in sprint goal? Also, Capacity is not captured directly in number. We use a prefix "Planned Capacity". So, I need to extract the Capacity as a number and then use that in the sum.

In pseudo code,

Create Array of sprints

For each item in array, iterate through all the stories under the epic in that PI and then find sum of capacity.

Or Am i making the problem sound more complicated than it is?