Structure Sprint capacity formula- before sprint

Ashley F February 21, 2024

Hey All, 

I need help with a structure formula for total sprint capacity before the sprint starts (team members x days of sprint). 

I have this formula but it calculates total remaining capacity in the sprint: 

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()

 

Thanks!

1 answer

0 votes
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 22, 2024

Hello @Ashley F 

The formula you mentioned does exactly what you described - it multiplies the number of team members in a Sprint(the number of Assignees of its issues) by the number of days of a Sprint (days between its Start & End dates). So it's not clear to me what exactly do you mean by 'before sprint' in this context.

But we sure have a closer look at your setup and requirements, and recommend a fitting solution. If you need our help, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

Ashley F February 22, 2024

Hi @Stepan Kholodov _Tempo_ , This formula returns "0" and other low numbers on my Structure for teams that have 5+ members and 10 sprint days. This is why I assumed that the formula was returning the remaining capacity after a sprint has begun. 

I want to show something such as 400hr capacity in a sprint, or even better, if I can show 80% of that, as this is our actual allocation.

Suggest an answer

Log in or Sign up to answer