I have a difficult time to average "minimum" times:
datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident}))
I have two incidents:
Incident I
Unit Time Assigned Time AtScene
A 00:05:00 00:06:00
B 00:01:00 00:10:00
Incident II
Unit Time Assigned Time AtScene
A 00:10:00 00:14:00
B 00:20:00 00:23:00
I needed to know what is the difference between the earliest time assigned and earliest time atscene for each incident separately (using formula datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident}))), but now I need to average both incidents.
datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident}))
I have two incidents:
Incident I
Unit Time Assigned Time AtScene
A 00:05:00 00:06:00
B 00:01:00 00:10:00
Incident II
Unit Time Assigned Time AtScene
A 00:10:00 00:14:00
B 00:20:00 00:23:00
I needed to know what is the difference between the earliest time assigned and earliest time atscene for each incident separately (using formula datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident}))), but now I need to average both incidents.