[rt-users] Ave time to resolve is off by 1 day

[Kelly F. Hickel]

Bruce,
	I didn't design this, so I don't know for certain.  I know that I did have some issues with timezones, and had to put a conversion function in Statistics.pm, you might look there, possibly add some debugging information.  The problem had to do with figuring out which tickets belonged to "today"......

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

> -----Original Message-----
> From: Kogami, Bruce [mailto:bkogami at randmcnally.com]
> Sent: Tuesday, March 30, 2004 10:16 AM
> To: Kogami, Bruce; 'Paulo Matos'
> Cc: 'David M Dennis'; Kelly F. Hickel; 'rt-users at lists.bestpractical.com'
> Subject: RE: [rt-users] Ave time to resolve is off by 1 day
> 
> I downloaded the latest Statistics from
> ftp://anonftp.mqsoftware.com/kfh/RT/Statistics3-0_1_3.tgz and got the same
> results. When I create a new ticket today (March 30) and select "Average
> Time to Resolution", the March 29 row will increase by one and no change
> will be on March 30. If I resolve the ticket on March 30, March 29 row
> will show the change and no change will be on March 30.
> 
> I know David Dennis has seen this. Has anyone else?
> 
> I still have a feeling this might have been done by design but I just
> don't see the connection with creating and resolving a ticket on one day
> and have the "Average Time to Resolution" statistics change on a different
> day. All other statistics seem to update correctly.
> 
> If anyone has any thoughts on this, let me know.
> 
> Thanks,
> Bruce
> 
> > -----Original Message-----
> > From: Kogami, Bruce
> > Sent: Monday, March 29, 2004 4:58 PM
> > To: Paulo Matos; Kogami, Bruce
> > Cc: David M Dennis; KellyF.Hickel; rt-users at lists.bestpractical.com
> > Subject: RE: [rt-users] Ave time to resolve is off by 1 day
> >
> > Thanks for the info.
> >
> > I'll try it out.
> >
> > Bruce
> >
> > > -----Original Message-----
> > > From: Paulo Matos [mailto:pjsm at fct.unl.pt]
> > > Sent: Friday, March 26, 2004 2:26 AM
> > > To: Kogami, Bruce
> > > Cc: David M Dennis; KellyF.Hickel; rt-users at lists.bestpractical.com
> > > Subject: RE: [rt-users] Ave time to resolve is off by 1 day
> > >
> > > On Thu, 25 Mar 2004, Kogami, Bruce wrote:
> > >
> > > > I'm hoping that wasn't done by design but a simple mistake.
> > > >
> > > > If anyone has any suggestions on how I can fix this problem, please
> > let
> > > > me know. All other stats display correctly.
> > >
> > > You're not using the latest Statistics package.
> > >
> > > Get it from:
> > > ftp://anonftp.mqsoftware.com/kfh/RT/Statistics3-0_1_3.tgz
> > >
> > > --
> > > 	Paulo Matos
> > >  ----------------------------------- ---------------------------------
> -
> > > |Sys & Net Admin                    | Serviço de Informática
> |
> > > |Faculdade de Ciências e Tecnologia | Tel: +351-21-2948596
> |
> > > |Universidade Nova de Lisboa        | Fax: +351-21-2948548
> |
> > > |P-2829-516 Caparica                | e-Mail: pjsm at fct.unl.pt
> |
> > >  ----------------------------------- ---------------------------------
> -
> 
> 
> ***************************************************************
> This E-mail is confidential.  It should not be read, copied, disclosed or
> used by any person other than the intended recipient.  Unauthorized use,
> disclosure or copying by whatever medium is strictly prohibited and may be
> unlawful.  If you have received this E-mail in error, please contact the
> sender immediately and delete the E-mail from your system.
> ***************************************************************