Team Capacity by Hours

Questions & Answers
,
1

Hello,
I been trying to create a table where I can see the teams capacity by hours. Just like this image shows I have each project team and then every fix version.

image
image780×716 14.1 KB

Right now the way I’m calculating it by using this formula, where the Capacity per iteration (hours) is another calculated measure where I multiply the number of member on that team by the number of hours per iteration (80 - 8 hour per day) by 0.80 (which is the utilization rate).
image

My question/problem is that some issues have more than one fix version which means that the original estimated hours will appear for both versions and that wont give accurate results i dont think. for example if one the first version i did 5 hours on a 20 hour estimated issue on the second fix version i would only want to appear 15 i think.
If anyone could help me i would aprecciate it!
Thanks in Advance

2

Hi @Goncalo_Marques ,

Thanks for posting your question!
Unfortunately FixVersion is a multi select field and we cannot import change history for this field (I have added your vote to a feature request we have in our backlog). There is no other option how to determine how many hours you have spent or dedicated on each of the fix version. The closest would be to take the average estimate for the fix versions.

Here is a formula you could try. This will distribute average Original estimated hours per fix version.

[Measures].[Original estimated hours]/
CASE WHEN NOT IsEmpty([Measures].[Issue fix versions]) THEN
Len([Measures].[Issue fix versions])
- Len(Replace([Measures].[Issue fix versions], ',', ''))
+ 1
END

Best wishes,
Elita from support@eazybi.com