I would add 3 fields. One for a start date, one for an end date, and an integer field for number of minutes. Create 2 filters. First would set the $TIMESTAMP$ to the start date when the TR value of the Status is pending, and the DB is not pending. The second would set the $TIMESTAMP$ to the end date when the TR value of the Status is not pending and the DB value is. It would then subtract end from start and ADD that to the integer field.
Regards, Ben Trimmer RSP DJHuang <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 09/27/2007 10:20 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Need a way to measure the duration of pending status without SLM. ** Hi Listers, I would like to find a way to measure or calculate how long the incident ticket stayed under status "Pending". AFAIK, there's only a time stamp when a ticket enters pending, such as Status History.Pending.Time but not for exiting pending. I've managed to calculate how long it took from "New" to "Resolved" for resolution time but still need to remove the pending duration. Is there anyone could kindly give me a hint or a approach how to do it? Thanks. DJHuang __20060125_______________________This posting was submitted with HTML in it___ * * * * * * * * * * * * * * * * * * * * * * * * * IMPORTANT NOTICE* * * * * * * * * * * * * * * * * * * * * * * * * Unless otherwise indicated or obvious from the nature of the transmittal, the information contained in this email message is CONFIDENTIAL information intended for the use of the individual or entity named herein. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender using the above contact information or by return email and delete this message and any copies from your computer system. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"