Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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

0 votes


Be the first one to answer this question!

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 10 '18, 10:50 a.m.

Question was seen: 340 times

Last updated: Jul 10 '18, 10:50 a.m.

Confirmation Cancel Confirm