report generation hours(effort) against weekly work

farrugiarobert wrote:

Hi,

i would like to genereate a report/graph which shows the effort( or
hours in this case) needed to complete the tasks for each
week.(showing hours on the y axis and weeks on the x axis). On the
graph i would also like to be able to plot the tasks that we managed
to conquer during that week and the tasks still pending...

is this possible?

thanks
Rob

Hi Rob,

Work items currently have an "estimate" field. Is this the data you
would like to plot? (Note that estimate is obviously a different thing
than the time *actually* required to complete the work). If it's not,
how would you calculate the duration? My guess is that it would simply
be the amount of time between when the work item entered an IN_PROGRESS
state and the time it entered a CLOSED state.

In the data warehouse, we currently don't collect information about the
estimates, but that might be a good candidate for us to add.

james

Hi,

Yes, i noticed that estimates is not found in the data ware house. it would be a good idea to be added since one can use it to calculate the effort needed to be done in a fixed period of time.

Keep me posted
Thanks.

Minor addition: APT will add another field to a work item to track the
time spent to do "the work"

Dirk

James Moody wrote:

farrugiarobert wrote:
Hi,

i would like to genereate a report/graph which shows the effort( or
hours in this case) needed to complete the tasks for each
week.(showing hours on the y axis and weeks on the x axis). On the
graph i would also like to be able to plot the tasks that we managed
to conquer during that week and the tasks still pending...

is this possible?

thanks
Rob


Hi Rob,

Work items currently have an "estimate" field. Is this the data you
would like to plot? (Note that estimate is obviously a different thing
than the time *actually* required to complete the work). If it's not,
how would you calculate the duration? My guess is that it would simply
be the amount of time between when the work item entered an IN_PROGRESS
state and the time it entered a CLOSED state.

In the data warehouse, we currently don't collect information about the
estimates, but that might be a good candidate for us to add.

james

THANKS! :)