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 > [EMAIL PROTECTED] > DigitalGlobe (r), An Imaging and Information Company > http://www.digitalglobe.com > ------------------------------------------------------------------------ > --------- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
