You can create this ind of view with some calculations.
I understand your general purpose of date range avail, but it's difficult to understand exact logic to understand avail or not.
ie. 4/4 avail, 4/5 occupied, 4/6 avail, 4/7 occupied ==> What do you want to show?
RoomUsage_SM_10.5.twbx 42.2 KB
Hi Shinichiro: Thank you for this.
Ideally, I would like to see something similar to this:
If I pick a date (via filter) say April 7, I would to be able to show
Total of rooms Available = 4 with the list of the room available
Total of room Used = 2
Which means a percentage of usage of 33%
Does it make sense?