Hello everyone, new member and my first post.
I am working in a distribution centre mapping activity flows and movement of vehicles on and off loading bays.
Primary objective is to understand the utilisation of both each loading bay and each trailer.
I have a dataset of transactions detailing:
- transaction number
- Trailer ID
- Loading Bay ID
-Date and Time ON Bay
- Date and Time OFf Bay
- Calculated Total Time
What I want to demonstrate in the format of a motion chart, is the weekly activity by transaction for each loading Bay.
Ie - A moving illustration of activity across any given week for a specific loading Bay.
It is particularly important for me to be able to graphically demonstrate the the activity utilisation of each loading Bay representing two aspects -
1) Arepresentation of time each transaction entered and exited the loading Bay
2) A moving summary of individual movements across the week by time
Appreciate this sounds quite complex, in reality it is an activity tracker by time.
Any suggestions on how to proceed with the creation of a graphical display that will capture the imagination whilst modelling throughput would be greatly appreciated
Many thanks and kind regards
REDDOG
I am working in a distribution centre mapping activity flows and movement of vehicles on and off loading bays.
Primary objective is to understand the utilisation of both each loading bay and each trailer.
I have a dataset of transactions detailing:
- transaction number
- Trailer ID
- Loading Bay ID
-Date and Time ON Bay
- Date and Time OFf Bay
- Calculated Total Time
What I want to demonstrate in the format of a motion chart, is the weekly activity by transaction for each loading Bay.
Ie - A moving illustration of activity across any given week for a specific loading Bay.
It is particularly important for me to be able to graphically demonstrate the the activity utilisation of each loading Bay representing two aspects -
1) Arepresentation of time each transaction entered and exited the loading Bay
2) A moving summary of individual movements across the week by time
Appreciate this sounds quite complex, in reality it is an activity tracker by time.
Any suggestions on how to proceed with the creation of a graphical display that will capture the imagination whilst modelling throughput would be greatly appreciated
Many thanks and kind regards
REDDOG