It's all about the answers!

Ask a question

report generation hours(effort) against weekly work


Robert Farrugia (5614) | asked Nov 07 '07, 3:53 a.m.
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

4 answers



permanent link
James Moody (3.3k24) | answered Nov 12 '07, 9:38 a.m.
JAZZ DEVELOPER
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

permanent link
Robert Farrugia (5614) | answered Nov 13 '07, 7:02 a.m.
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.

permanent link
Dirk Baeumer (4811) | answered Nov 15 '07, 9:28 a.m.
JAZZ DEVELOPER
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

permanent link
Robert Farrugia (5614) | answered Nov 15 '07, 10:11 a.m.
THANKS! :)

Your answer


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.