Count of equipment at a shipper by hour

[Dits]

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-on...

[T_Willins · Accepted solution]

Hi @Dits,

I was unsure as to what you were looking for in your final output, but this gives a sum by each unique time signature (arriving or departing).

[Dits]

This helps, thank you!