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

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.

      • mpmsltd's avatar
        mpmsltd
        Helper I
        6 years ago

        In the sample file that you uploaded it does not have a start and end date, there's only one date on the Data table. Please check, my example has two different columns, start and end date.