Question regarding JIRA Structure arrays

[AMIT GULATI]

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 

[Stepan Kholodov _Tempo_]

Hello @AMIT GULATI 

You can extract the Sprint Goal and show it for each issue using this formula: sprint.goal

Enabling the 'Sum over sub-items' option in the Formula column's configuration will aggregate the values. But please note - it depends on your setup, on what type of values are shown in the Goal field (is it just numbers or is it also text), and how many Sprints with set Goal each issue has. So, the formula might need to be adjusted accordingly.

You can also add grouping by Sprints for Stories - this way Sprints-based groups will appear above Stories and aggregating the Formula column's values will give you sums of Goals for each Sprint.

I hope this helps. If you need further assistance or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)T

[AMIT GULATI]

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

[Stepan Kholodov _Tempo_]

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]

@Stepan Kholodov _Tempo_ 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.