Forum Discussion

mpmsltd's avatar
mpmsltd
Helper I
6 years ago
Solved

Daily Occupancy Average

Hi everybody,   I have a table that shows the Start Date, End Date and Customer ID. What I want to do is to see the daily occupancy average per period of time (year for example and be able to drill...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my solution file from here.

    Hope this helps.

mpmsltd's avatar
mpmsltd
Helper I
6 years ago

Ashish_Mathur sorry but again you are just counting the number of ids, this is not what I'm looking for. Please see my example previously showing my expected result, it considers the start and end date to define the daily occupancy.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

That is exactly what I am doing.  My answers matches what you have shown in the yeloow highlighted section of your previous message.