Hi Everyone,
I have a data feed of trucks that make frequent stops. I need to have a field that tells me how long that they have been stationary. It could be as simple as a long integer field that holds this info - 'MinutesStationary'.
Some Facts about the feed:
- The feed has a 'Speed Field' that is populated by the GPS device in the Truck. Speed of '0' means the truck is not moving.
- The usual data update for each truck is one minute. The device will send a position every minute if connected to the cellular network.
Has anyone done this or has a potential idea how to acomplish? Let me know if you have any questions!
Thanks,
--Adam