Hi All,
Simplified data structure as described below
I have data about moves on a vessel. This shows a row for each move, a movedatetime and a VesselID.
I have a vessels table which shows a VesselID, its ATA (actual time arrived) and ATD (actual time departed).
I then have data around truck in a separate table, it shows truckdatetime and a TruckID.
What I want to be able to do is select a VesselID, use the ATA and ATD as my timeframe and show count of TruckID as bars over movedatetime and a count of Vesselover the same timeframe.
There is no canonical calendar.
Essentially I want something like the attached.
Any help would be great!
Thanks
