[rt-users] time worked report

[Kenneth Crocker]

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 <dalamars at 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 <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
>
>
> --------
> Final RT training for 2012 in Atlanta, GA - October 23 & 24
>   http://bestpractical.com/training
>
> We're hiring! http://bestpractical.com/jobs
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120919/a0638e7f/attachment.htm>