It's all about the answers!

Ask a question

Report Builder : Work Item's "Estimate" field and its "Correction Field"


Peter Turvey (99130) | asked Jul 10 '18, 10:50 a.m.

I have created a report in Report Builder that shows the "Actual Work" for an iteration versus the "Planned Work".

The underlying SQL shows that the "Planned Work" information comes from [dw].vw_request.planned_work

This is normally the "Estimate" field on the Work item's Overview tab. e.g. 90 hours

But if a user subsequently enters a "Correction" ,e.g. 30 hours, in the Work Item's Overview tab then Planned Work becomes 30 hours.

I want my report to show the original estimate of 90 hours.
Is there anywhere in the [dw] database that shows this information ? because  [dw].vw_request.planned_work is now showing 30.

Thanks

              Peter

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.