Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count of equipment at a shipper by hour

Dits
5 - Atom

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. 

 

Dits_1-1589833822696.png


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

 

 

2 REPLIES 2
T_Willins
14 - Magnetar
14 - Magnetar

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

 

Count Equipment.png

 

Dits
5 - Atom

This helps, thank you! 

Labels