[rt-users] time worked report

[Paul Muther]

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 <trs at 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