[rt-users] Statistics revisitation

[Mathew Snyder]

How difficult is it to add custom reports?  I have a custom field that lists all
of our customers and I'd like to be able to generate a report that indicates how
much total time has been spent on each customer as well as how much time each
user spent on each customer.

Mathew

Nick Metrowsky wrote:
> Hi Everyone,
> 
> Over the past year or so, I have made some customizations to
> RTx::Statistics for our site use. Some of these changes include:
> 
> 1. Some logic changes, because some of the calculations in the web
> display did not match the spreadsheet (spreadsheet was correct).
> 2. On the Tickets per day per Queue reports, I show columns for Created,
> Resolved, Rejected, Stalled, Queue Depth and Time to Resolve. Queue
> Depth shows how many tickets are open or new in a particular queue on
> any given day in time. This change is in both the spreadsheet and the
> web display.
> 3. Based upon the Ticket per day Queue screen, I have written batch
> reports which can generate text based reports for one or many queues for
> any time period. I also have a script which can do the same thing to an
> MS Excel or OpenOffice Calc spreadsheet.
> 3. Not related to RTx::Statistics, but I also have taking the
> rt-remind.pl script and used that for generating reports to our
> technical teams. There were a few minor modifications, again for our
> site.
> 
> If anyone is interested in anything I have, I will be glad to send you a
> copy. I know Kelly wanted to implement some of the items mentioned in
> this e-mail, based upon an e-mail conversation we had a while back.
> 
> Finally, RTx::Statistics does work with RT 3.6.3, but you have to change
> the index.html file for Tickets per day per Queue (CallsQueueDay
> directory) as for some reason it does not like /Elements/TitleBox, but
> will work with /Elements/TitleBoxStart and /Elements/TitleBoxEnd. 
> Nick
> 
> ------------------------------------------------------------------------
> ---------
> Nick Metrowsky
> Consulting System Administrator
> 303-684-4785 Office
> 303-684-4100 Fax
> nmetrowsky at digitalglobe.com
> DigitalGlobe (r), An Imaging and Information Company
> http://www.digitalglobe.com
> ------------------------------------------------------------------------
> ---------
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kelly F.
> Hickel
> Sent: Wednesday, January 17, 2007 2:00 PM
> To: Jason Fenner; Mathew Snyder
> Cc: RT Users
> Subject: RE: [rt-users] Statistics revisitation
> 
> You could copy me as well.  I haven't had time to get back to this,
> although that might change a bit in the future.  I'm also still open to
> assistant maintainers (or someone who wants to take it over completely).
> 
> I have a number of contributed changes pending, but haven't had any time
> to look at them.
>