Calculated automatically completed work in TFS 2013 Agile template

Question

How can I implement cumulative automatically hours in completed work field? I tried to use Aggregator plugin but it not working for me. I need to sum all change in remaining work.

I used Agile template, VS 2013 and TFS 2013.4

 <!--Sum all remaining work -->
<AggregatorItem operationType="Numeric" operation="Sum" linkType="Self" linkLevel="1" workItemType="Task">
    <TargetItem name="CompletedWork"/>
    <SourceItem name="RemainingWork"/>
</AggregatorItem>

Can you help me?

score 0 · Answer 1 · answered Jun 30 '15 at 21:28

0

If you're using the Scrum Process Template I don't think you have enough data to calculate this. The Remaining Work field is not a good option to try to capture this. I may start the day with Remaining Work = 8, work 6 hours on the item, but at the end of the day recognize that there is still 4 hours of work left (it was bigger than originally estimated). In that case the remaining work would only decrease by 4 even though I worked 6 hours.

If you need to capture actual work completed, you should be using a separate field on the Work Items. Both the Agile and CMMI process templates have fields for this. If you stick with the Scrum template I'd suggest adding a Completed Work field in addition to the Remaining Work field.

answered Jun 30 '15 at 21:28

Dylan Smith

22,069
2
47
62

Hello Dylan, I'm using Agile process templates. I have completed work and Remaining Work but completed work is empty all the time. – user3149114 Jul 01 '15 at 21:59
1

Yes, you need you team members to manually enter it as it's not possible to accurately calculate it. – Dylan Smith Jul 02 '15 at 03:40
Case in point: Estimate was 10, remaining was 5. Just completed 6 hours and remaing is 8. This is the common scenario and not an exception. Remaining work is the only field of value. – MrHinsh - Martin Hinshelwood Jul 10 '15 at 18:59
Hello, I'm using time tracker is the only option that I founded. – user3149114 Jul 22 '15 at 22:51

Calculated automatically completed work in TFS 2013 Agile template

1 Answers1