RE: [rt-users] Statistics revisitation
Hello all, I'd love to have a copy of this to please Thanks a lot. Thomas. De : Marco Avvisano [mailto:[EMAIL PROTECTED] Envoyé : lundi 22 janvier 2007 09:15 À : RT Users Objet : Re: [rt-users] Statistics revisitation I would like too thanks Marco - Original Message - From: Jared Hanks mailto:[EMAIL PROTECTED] To: Roy El-Hames mailto:[EMAIL PROTECTED] ; Mathew Snyder mailto:[EMAIL PROTECTED] 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 [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 ___ 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 Get free, personalized online radio with MSN Radio powered by Pandora. Try it! http://radio.msn.com
Re: [rt-users] Statistics revisitation
I would like too thanks Marco - Original Message - From: 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. 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 ___ 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 -- Get free, personalized online radio with MSN Radio powered by Pandora. Try it! -- ___ 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___ 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
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 [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 ___ 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 _ Type your favorite song. Get a customized station. Try MSN Radio powered by Pandora. http://radio.msn.com___ 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
Re: [rt-users] Statistics revisitation
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 [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
Re: [rt-users] Statistics revisitation
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
Re: [rt-users] Statistics revisitation
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 __ 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 ___ 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
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. -- Kelly F. Hickel Senior Software Architect MQSoftware, Inc 952.345.8677 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:rt-users- [EMAIL PROTECTED] On Behalf Of Jason Fenner Sent: Wednesday, January 17, 2007 1:22 PM To: Mathew Snyder Cc: RT Users Subject: Re: [rt-users] Statistics revisitation 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 __ 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 ___ 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 ___ 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
[rt-users] Statistics revisitation
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 ___ 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