Thank you Kenneth. That does help. The one thing I'm struggling with is the Time Worked. I only want to see the Time Worked for that week. For example if I have a ticket that has 40 hours of work over two weeks, I only want Time Worked to reflect the time put in during the week the report covers. So if the split is 18 hours one week, and 22 the following week, I should only see either 18 hours or 22 hours depending on the week selected for the report.
I hope I'm not rambling. :-) What I have done thus far is to run a SQL query looking at the time worked for each ticket update and manually adding them up. Not the best solution to be sure. I was hoping there was a better way. Thanks very much, Paul M On Sep 19, 2012, at 11:02 PM, Kenneth Crocker <[email protected]> wrote: > Paul, > > Like Thomas said, build the query you want and add the Timeworked column. > However, to make this a weekly report, you need to put it in a dashboard set > to run weekly. That would do it. > > Hope this helps. > > Kenn > > On Wed, Sep 19, 2012 at 3:41 PM, Paul Muther <[email protected]> wrote: > Is there a way to do this easily to show time worked for a range of dates? > For example if I submit time for techs on a weekly basis showing the effort > put into each ticket? Currently I'm using a rather unreliable method of > table joins and a back end SQL query. > > In almost all implementations of this there is a desire to look at TechA and > see the time he/she has contributed to a ticket. In most cases the ticket is > owned by that individual so all theTime Worked within that week can be > counted toward the person. > > In other cases I need to know how much in the way of man hours was spent > working tickets for a given week, even if the ticket spans multiple weeks. > There seems to be no easy way to pull that data without opening new tickets > at the beginning of each work week and closing them at the end. > > Thanks much. > > On Sep 19, 2012, at 3:20 PM, Thomas Sibley <[email protected]> wrote: > > > On 09/19/2012 02:48 PM, Frankie Gibbs wrote: > >> I currently use the RT 3.8.7 and I need to automatically calculate the > >> time worked on each ticket, is this possible?. how I can do to get that > >> report? > > > > Construct the search for the tickets you want using the Query Builder > > and then add the TimeWorked column to the format at the bottom of the > > builder. Then run the search to see your results. You can download the > > results as a spreadsheet (TSV) using Feeds → Spreadsheet. > > > > > > -------- > > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > > http://bestpractical.com/training > > > > We're hiring! http://bestpractical.com/jobs > > > -------- > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > http://bestpractical.com/training > > We're hiring! http://bestpractical.com/jobs > > > -------- > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > http://bestpractical.com/training > > We're hiring! http://bestpractical.com/jobs
-------- Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
