Forum Discussion
Help needed - create metric based on 2 datasets. Use one total form DS1 and use 2 columns from DS2
And we want the time frame between 03:00-02:59 instead of 00:00-23:59 for a complete day. So we do'nt start with occupancy at 00:00 but at 03:00
Super UserPlease provide sample data that fully covers your issue. Multiple days of data.
Please show the expected outcome based on the sample data you provided.
Hi sir, many thanks for your effort. I put 2 spreadsheets online - I can't share that much data in this post https://drive.google.com/drive/folders/1-EY_l80W4QGKE90E-EYYPjtiJv_hUXz-?usp=drive_link
For the output, this is what I would like to present myself:
- red line is the OCCUPANCY based on ROOM PRESENCE from 03:00 and then use IN & OUT count on top of the ROOM OCCUPANCY to show real occupancy in hotel
THe purple and yellow bars shos the IN & OUT count in same graph
The tbael below I want to show the hourly heatmap of occuapncy per hour that day