[rt-users] BASIC statistics question

[Drew Barnes]

Bear in mind, I am running RT3.6.5 so your list may vary...

Built in under Tools->Reports are:
- Resolved by owner: Total tickets in a queue resolved by each
privileged owner
- Resolved in date range: Same as above, but allows you to specify a
date range
- Created in a date range: Shows number of tickets created in a given
date range and their current status: deleted, new,open, rejected,
resolved, stalled

There have been posts to the list in the past of how people use Crystal
Reports (for example) to do their own reports.  I have not been asked to
do so and have no personal experience with it.  I also have not tried
any "add-on" statistics packages or scripts.


Fuller, David wrote:
>
> HI :
>
>  
>
> My basic question: What statistical reports are available via RT ?
>
>  
>
> My task is to report to management many/all statistical reports
> available in RT.
>
> Management will then decide whether or not to implement the RT
> statistics package.
>
> I looked at the RT3 statistics package.
>
> The ‘TimeWorked’ module [
> http://wiki.bestpractical.com/view/TimeWorked ] seems to fill *_one_*
> of our current needs but
>
> I haven’t found a list of available reports / graphs.
>
> Is there, where is – such a list ?
>
>  
>
> We have  RT 3.6.1  .
>
>  
>
> Thank you.
>
>  
>
> D
>
>  
>
> *Is this a list of statistical reports ?*
>
> *I downloaded the: rtstats-1.03.tar.tar file.*
>
> *In it was  the ‘rtstats.pl file.*
>
> * I found what _MAY_ be report descriptions in this file.*
>
> Created vs Resolved Graph
>
> resolved_totals ()
>
> created_totals ()
>
> resolved_totals_by_area ()
>
> Get the next number request to be generated.
>
> Generate average time to resolve
>
> Generate average time by person to resolve
>
> Generate average time by area to resolve
>
> Average Time a open ticket has been sitting since last acted on
>
> Tickets created in the last 24 hours
>
> Tickets closed in the last 24 hours by person
>
> tickets resolved by person
>
> Average time to resolve in days
>
> Create "restime by owner"
>
> Create "restime by area"
>
> Get active total number ()
>
>  
>
>  
>
> *_Search History:_*
>
> I went here looking for said list:
>
> http://wiki.bestpractical.com/view/RT3StatisticsPackage
>
> and read this *_excerpt_*:
>
> *RTx::Statistics Package*
>
> Current release: v. 0.1.8
>
> Description: Produces statistical information based on RT3 data.
>
> http://wiki.bestpractical.com/view/RT3StatisticsPackageWishList
>
>  
>
> http://opensvn.csie.org/RTx_Statistics/releases/0.1.8/README
>
>  
>
>  
>
>  
>
>  
>
> **David Fuller**
>
> **Student Affairs Information Technology**
>
> **860.486.8992**
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
>
> If you sign up for a new RT support contract before December 31, we'll take
> up to 20 percent off the price. This sale won't last long, so get in touch today. 
>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
>
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com