is it possible to produce report showing elapsed time by resource for each issue?
Greeting Gemini Users -
I'd like to understand where issues are getting stuck as they are moved across various resources. As an example - a report could be something like a stacked bar chart where the slices that make up the stacked bar are each person having worked on the issue and the axis are issues and elapsed time.
Can anyone tell me if this is feasible to create and if so how? Anyone have a query that they can send me?
thanks in advance!
Shannon
· 1 |
|
Tuesday, October 26, 2010, 4:49:31 PM |
0
|
Are you looking to see the time spent (logged) per resource per issue? |
||||
|
0
|
Hello - Our goal is to see where issues are getting bogged down. So the thinking was that we need to be able to see the overall elapsed time required to get an issues closed, and then, for each issue, a view of how long each person had the issue. example; assume mary logs the issue and assigns to betty. betty has the issue for 3 days and completed research of root cause. She assignes to Jimmy in IT to fix. Jimmy has the issue for 5 days and then gives to QA. QA has issue for 2 days and then give back to betty to conduct UAT. Betty then has the issue for 20 days before marking it closed. In that scenario we would have an open issue for 30 days. a stacked bar graph could show a total bar that makes a height of 30 days and slices of the bar "stack" would be betty (33 days), jimmy (5 days), QA (2 days). So the above I'm assuming might be based on logs of who was assigned the issue and for how long. So I am assuming that only 1 person is assigned at a time. Conversly, it appears that we could also use the time tracking and in that case each person working an issue would also be logging the time they spent. With time tracking we would probably have much better knowledge of how much time is being spent and where we are really getting bogged down. I don't think we are using time tracking yet. Hope this all makes sense as I am a pretty new user to the tool so don't understand exactly how everything worls in the tool. thanks in advance for any assistance you can provide! Much appreciate it
|
||||
|
0
|
You will be able to create a custom report by time logged quite easily. But to create one by assinged resource, you will have to parse the issue history table. |
||||
|
0
|
Hello, So if I am understanding correctly, it would be fairly easy to create a report based on the time each resource logged to support a given issue. This requires that each resource supporting the issue also uses timelogging within the gemini tool correct? Is time logging available for version 3.5.2? Just want ot make sure on that! Conversly, if we do not use time logging and try to create a report based on assigned resource, then we will have a more difficult custom report to produce. It almost sounds like we would need both in order to understand who is sitting on issues versus which area has to invest the most time to resolve an issue? Do you agree with my impression? Last, in term so of creating custom reports, can i use microsoft reporting services or is there a better tool to support this? Also, how do I go about knowing the underlying data - is something published? thanks a ton for you help! |
||||
|
0
|
Also, where in the user manual or anywhere else may i find an overview of the available "canned" reports? I don't see a resource load report on my main page so have asked someone if my id may be set up to disallow viewing of this type of report.
|
||||
|
0
|
Yes, time logging is there for 3.5. You need to be Gemini administrator to view the workload report. |
||||
|
0
|
Hi Mark - Question - where can i find a sample of the report to see if it would be worthwhile to beg and plead for admin rights? |
||||
|
0
|
We don't have one handy, but ask your admin to show you the report on your system. |
||||
|
0
|
Ok.....i give up but thanks for the effort on this. I actually contacted our internal staff first, and Gemini as a second option. Our internal team has not provided an example, nor are they very interested in attempting to help me when I do not know if the report in question is of any use to me without know what it contains or provides. Would be nice add to include in your manual when you get around to updating that. Perhaps one of your other users could produce one and use snag it add in to take a screen shot and attach to this thread?
|
||||
|