Quote:
Originally Posted by NoSparks
This would indicate the end point for cases to be the first TASKCOMP in column D for each case.
Is this assumption correct and applicable to every case ?
|
Hmm, very nearly, but no I don't think that would always be the case.
The data I'm working with is a snapshot of all tasks completed between Jan and I think October. The data is then displayed by reference number with the first recorded task starting things off. In that circumstance it might mean that somewhere within the data a case doesn't start with a TASKCOMP.
I would also need to measure the time taken between other task stages, so these would not always end with a TASKCOMP either. My limited knowledge of these things suggests that column E is the driver, so I would want to select one type of audit note to start and then another to end.
For example on Line 37, we start with a NEWCASE but end on Line 46 with ONHOLD as there are a couple of extra tasks carried out.
Hope this makes sense.
Ballst