I'm running CR v10 and have an oracle database table that has history of events for each record. For ex: Enter, Approve, HR Update, Pay Update, Pension Update. I'm using the Minimum and Maximum date function to get the min and max date/time on records that are = Enter and Pension Update. (Don't care about any steps in between). I want to know when the record was entered and when it was updated by pensions (how long from enter to pensions) then total by dept# and get the average time it takes to enter and get to pensions. How can I get total time for each dept and calculate the average? Any help is appreciated.
My data looks like:
Dept #: 10
folder#: 123
enter date: 9/1/2005 10:00 am
approve date: 9/1/2005 11:00 am
hr update date: 9/2/2005 9:00 am
pay update date: 9/2/2005 1:30 PM
Pension update date: 9/3/2005 9:00 AM
My MINdate is 9/1/2005 10:00 am and my MAXdate 9/3/2005 9:00 am (MaxDate - MinDate = 2 days 23 hours)
My data looks like:
Dept #: 10
folder#: 123
enter date: 9/1/2005 10:00 am
approve date: 9/1/2005 11:00 am
hr update date: 9/2/2005 9:00 am
pay update date: 9/2/2005 1:30 PM
Pension update date: 9/3/2005 9:00 AM
My MINdate is 9/1/2005 10:00 am and my MAXdate 9/3/2005 9:00 am (MaxDate - MinDate = 2 days 23 hours)