Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Familiarize yourself with the "CROSSFILTER(,,NONE)"  pattern where you use a Dates/Calendar table against your occupancy table to fill in the gaps in your data. You may want to start small and do that for one location first to see how that works.

 

A sample result will be a list of dates (from your calendar table) with the number of minutes that location (from your occupancy table) had a ship present. 1440 for a full day, 0 for no occupancy.  You'll want to think about how to handle multiple ships per location and day.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks lbendlin - I'll look into your suggestion !