Jira Structure- calculating sprint capacity

[Ashley F]

Hello, 

I would like to calculate sprint capacity per sprint and display it as a column on Structure.

For example: 10 days x 5 team members

How do I do this? 

[Stepan Kholodov _Tempo_]

Hello @Ashley F 

If you want to calculate the capacity of a Sprint based on its duration (taken from its defined Start & End dates on the Agile board) and on the number of Assignees of its issues, you can try the following approach:

1. Add issues from the board to a structure as a flat list with an Insert generator.
2. Add the group by Sprint generator.
3. And add the Formula column with this formula:

if !issuetype: max#strict{days_between(sprint.filter($.name = split(split(parent{summary}, ": ").last(), " (").first()).startdate,
sprint.filter($.name = split(split(parent{summary}, ": ").last(), " (").first()).enddate)} * array#strict{assignee}.unique().size()

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Ashley F]

Thank you so much @Stepan Kholodov _Tempo_ ! I was able to follow these steps and get a number through the formula. I am seeing relatively low numbers for each sprint though, such as 14 or 26, which I'm assuming is "capacity remaining" ? There are around least 5 people in this team for a 10 day sprint. Can you help me understand this number?

[Humashankar VJ]

Hi @Ashley F 

1. Add column in your structure board

2. Configure it in the column settings to display the capacity

3. Display capacity as a column in your board 

Kindly try this

[Ashley F]

Hi @Humashankar VJ ,

I have tried this- the Total Capacity column, but there is no data associated with it.