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

Thanks Ashish_Mathur  but this is not what I need. 

 

What I need is the daily occupancy average - which is a calculation of: customers that were staying on that day + customers that arrived on that day - customers that left on that day

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.