Hello all,
I am trying to calculate the count of equipment per 1 hour time intervals at a shipper.
AP = Arrival time at the shipper
ReleaseEmpty = Released time
If we use the below snip as an example, 1 shipment arrived on 4/16 and 0 shipments left, making my count at the facility = 1.
4 shipments arrived on 4/17 and 0 left making my count at the facility = 5.
On 4/18, 2 of the trailers were released so now my count is down to 3 at the facility.
I found the below workflow that helped me get started. However, this assumes that all shipments arrived and left on the same day. Any help with this would be appreciated!
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-count-employees-by-hour-with-only-a-start-and-end-time/td-p/342343
