Statistics revisitation

RT Users
1

Does anyone know about or have any intentions of updating the RTx::Statistics
package? I’m finding the built-in reports are not sufficient and I don’t know
enough perl to make my way around the RT codebase.

Mathew

2

Mathew Snyder wrote:

Does anyone know about or have any intentions of updating the RTx::Statistics
package? I’m finding the built-in reports are not sufficient and I don’t know
enough perl to make my way around the RT codebase.

Mathew

I am also interested in this. Email me off list to talk about this.

Jason - axelilly

3

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.

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

4

I would love to have a copy of this.

Mathew

Nick Metrowsky wrote:

5

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:

6

Hi Nick;
Can you also send me a copy of this …
Regards;
Roy

Mathew Snyder wrote:

7

I would like this too.

Thanks,
Jared

Hi Nick;> Can you also send me a copy of this …> Regards;> Roy> > Mathew Snyder wrote:> > I would love to have a copy of this.> >> > 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@digitalglobe.com> >> DigitalGlobe (r), An Imaging and Information Company> >> http://www.digitalglobe.com> >> ------------------------------------------------------------------------> >> ---------> >> -----Original Message-----> >> From: rt-users-bounces@lists.bestpractical.com> >> [mailto:rt-users-bounces@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.> >>> >> > > _______________________________________________> > The rt-users Archives> >> > Community help: http://wiki.bestpractical.com> > Commercial support: sales@bestpractical.com> >> >> > Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com> >> > > > _______________________________________________> The rt-users Archives> > Community help: http://wiki.bestpractical.com> Commercial support: sales@bestpractical.com> > > Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. > Buy a copy at http://rtbook.bestpractical.com
Type your favorite song. Get a customized station. Try MSN Radio powered by Pandora.
http://radio.msn.com

8

I would like too

thanks

MarcoFrom: Jared Hanks
To: Roy El-Hames ; Mathew Snyder
Cc: RT Users
Sent: Sunday, January 21, 2007 12:51 AM
Subject: RE: [rt-users] Statistics revisitation

I would like this too.

Thanks,
Jared

Hi Nick;
Can you also send me a copy of this …
Regards;
Roy

Mathew Snyder wrote:

I would love to have a copy of this.

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.
  4. 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@digitalglobe.com
DigitalGlobe (r), An Imaging and Information Company
http://www.digitalglobe.com

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@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.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Get free, personalized online radio with MSN Radio powered by Pandora. Try it!

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

9

Hello all,

I’d love to have a copy of this to please

Thanks a lot.

Thomas.De : Marco Avvisano [mailto:marco.avvisano@regione.toscana.it]
Envoyé : lundi 22 janvier 2007 09:15
À : RT Users
Objet : Re: [rt-users] Statistics revisitation

I would like too

thanks

Marco

From: Jared Hanks <mailto:jmhanks1373@hotmail.com> 

To: Roy El-Hames <mailto:rfh@pipex.net>  ; Mathew Snyder <mailto:theillien@yahoo.com> 

Cc: RT Users <mailto:rt-users@lists.bestpractical.com> 

Sent: Sunday, January 21, 2007 12:51 AM

Subject: RE: [rt-users] Statistics revisitation



I would like this too.

Thanks,
Jared

>
> Hi Nick;
> Can you also send me a copy of this ..
> Regards;
> Roy
>
> Mathew Snyder wrote:
> > I would love to have a copy of this.
> >
> > 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@digitalglobe.com
> >> DigitalGlobe (r), An Imaging and Information Company
> >> http://www.digitalglobe.com
> >> ------------------------------------------------------------------------
> >> ---------
> >> -----Original Message-----
> >> From: rt-users-bounces@lists.bestpractical.com
> >> [mailto:rt-users-bounces@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.
> >>
> >>
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales@bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> >
> >
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales@bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com






Get free, personalized online radio with MSN Radio powered by Pandora. Try it! <http://radio.msn.com> 




http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The information contained in this document is attorney privileged and
confidential.The information is intented only for the use of the individual
or entity named above. Should you receive this message in error, please delete
it immediately from your system and notify the sender of the wrong delivery
and the mail deletion. If the reader of this message is not the intended recipient,
you are hereby notified that any use, disclosure, dissemination copying
(either whole or partial) of this document, or any information it contains,
is strictly prohibited.
E. mail transmission cannot be guarantee to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender Company shall not be liable
for the contents said document.
If verification is required please request a hard copy version.