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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You are welcome.  Show me your exact expected result.

mpmsltd's avatar
mpmsltd
Helper I
6 years ago

hi Ash in yellow is my expected result, the daily occupancy by day. Plus I'd like to be able to see the daily average occupancy in a month as well. The column "counted on dates" shows which dates the id is being counted as occupant.


Please let me know if any questions. Thanks

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    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.