RTC Custom report for time spent by user, by task and by month
Hi,
A customer is using the Scrum template without adding the "time tracking" functionality from the Traditional Formal Project Management template. They would like to create a custom report showing the activity (time spent) by each user and by task per month (not by iteration). As users will use the time spent attribute to input time spent each day, there is not a detailed info of the time dedicated by day (only through searches in the detailed history of the WI).
As far as I know, the DW WI tables store the total time spent value for each WI but there is not detailed info of when each time addition was entered by the user, so I don't have this info to create the detailed report. Is there something I am missing and could this info be extracted from other WI historical tables or the only info available is the total time spent by each WI but not detailed inputs for this attributes with corresponding timestamps by user and date?.
If customer uses the traditional template and WI time tracking, could this detailed monthly report be created?
Many thanks,
Ana
A customer is using the Scrum template without adding the "time tracking" functionality from the Traditional Formal Project Management template. They would like to create a custom report showing the activity (time spent) by each user and by task per month (not by iteration). As users will use the time spent attribute to input time spent each day, there is not a detailed info of the time dedicated by day (only through searches in the detailed history of the WI).
As far as I know, the DW WI tables store the total time spent value for each WI but there is not detailed info of when each time addition was entered by the user, so I don't have this info to create the detailed report. Is there something I am missing and could this info be extracted from other WI historical tables or the only info available is the total time spent by each WI but not detailed inputs for this attributes with corresponding timestamps by user and date?.
If customer uses the traditional template and WI time tracking, could this detailed monthly report be created?
Many thanks,
Ana
2 answers
Hi Ana,
When using Time Spent attribute instead of Time Tracking tab you can't say exactly which day(s) this time belongs to. Owner can update Time Spent before he plans to work on this task or afterwards (more usual scenario). So you have to rely on start date\finish date and distribute hours spent between all working days. But still this approach has weak points:
- of suggesting work is distributed evenly (it's not true usually)
- start and finish dates are entered accurately (once you pass it to human there's always possibility of mistake)
The more hours spent on task the less accurate your report is.
In my opinion only way to create nice monthly report is to engage Time Tracking tab. In this case you can use BIRT to fetch detailed timesheets for every entry(day) and implement quite custom and complex logic like filtering weekends or considering part of time spent on interval's borders. Good luck!
Comments
I have the same problem as Ana. I need to report the time per week per person.
I looked across the databse of RTC to find historical data of the time spent but I don't found where this information is stored.
I need help. Someone has an idea or solved the problem ?
I looked across the databse of RTC to find historical data of the time spent but I don't found where this information is stored.
I need help. Someone has an idea or solved the problem ?
Comments