Forum Discussion
Calculate Occupancy (%)
Hi all, I'm trying to come up with a measure to help measure the occupancy of a particular loading location (A & B). Ships go to these locations and they remain docked for a certain time until loa...
Hi,
Based on that data that you have shared, please let us know the exact result that you are expecting.
Hi Ashish,
An example of the results I'm expecting is listed below. Note that some events span over 2 days (and could be more so occupancy needs to be calculated/split based on calendar date.
Below I'm only showing location A for Aug 14 below but the reports needs to be able to do this per location (A and B) and per day (and week/month etc).
Location A Occupancy
Aug 14: 8%
Aug 15: 43%
Explanation: ship arrives Aug 14 22:09 and leaves Aug 15 at 10:13 (total 12 hours 4 minutes). Occupancy is apportioned to Aug 14 (1h 51m/ 24h) and Aug 15 (10h 14m/24h).
Thanks in advance!