Are you looking to see the time spent (logged) per resource per issue?

eg Issue X has 3 Resources time logged, so you'll see Resource 1 spent Y etc...?

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

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.

However, the fact that an issue was assigned to Betty for 5 days doesn't mean that she has spent all that time on the issue. If you are looking for a resource load report you can find it on the "All projects" tab in the main page of Gemini.

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!

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.

Yes, time logging is there for 3.5. You need to be Gemini administrator to view the workload report.

You can create this report using any report writer, but might need to do some data preperation before.

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?

We don't have one handy, but ask your admin to show you the report on your system.

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?