Amy,
If you are creating a standard AR report in the windows user tool, go to the
'Statistics' tab and add the 'Average' operation on the following
expression:
'Status*-History.Resolved.TIME' - 'Status*-History.New.TIME'
The result should appear in HH:MM:SS format.
HTH,
Thomas
----- Original Message -----
From: "Amy Belile" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <[email protected]>
Sent: Thursday, December 06, 2007 12:25 PM
Subject: User Tool Statistical Reporting
Hi, listers.
I am using the User Tool to create a report on the HPD:HelpDesk form
(6.0) that will list all cases that were created or resolved in the
past week on a certain CTI. I want to have a statistic that will tell
me the average time it took to resolve all the cases. Any advice on
how to to do that?? I can't figure it out! There is a handy 'Hours
to resolve' field but I cannot find any documentation on how to use
that in an expression, assuming I would use the Average operation...?
Thanks in advance for your help!
Amy Belile
Remedy Engineer
[EMAIL PROTECTED]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
