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 <dalam...@gmail.com> 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 <t...@bestpractical.com> 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