Forum Discussion
Help needed - create metric based on 2 datasets. Use one total form DS1 and use 2 columns from DS2
Hi there, I am not getting it so I ask for help. I have 2 datasets. One is a dataset with room checkins on each day. So I can pick the TOTAL of one Day. So I have TOTAL GUEST IN for e.g. 28-03-20...
lbendlin
Super User
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