We have a dataset of 911 calls by unit and are trying to calculate a response order for the unit by call. The dataset contains the fields ReportNumber(Unique Call ID), Unit, UnitType, UnitDispatch(Date/Time), UnitEnroute(Date/Time), UnitOnscean(Date/Time), and ArrivalOrder(Numeric).
My goal is to calculate a field ArrivalOrder so that if 3 units are assigned to the same ReportNumber I can tell which unit was the first on scene, second, ETC. The dispatch database only gives me the first unit but doesn't give me the running order if multiple units are involved. I've gotten to the point that I need to group them by ReportNumber and now I'm stuck.
Has anyone tried to calculate something silitar and had any success? I thought maybe StaticsCalculator might work but wasn't giving me the order per line. Thanks.