Hi everyone - question here.
I run a hostel that has different types of rooms. I have a table set up with a realtime feed of new bookings coming in. I have another table set up with room specs.
I want to use the second table to analyse data in the first, for instance revenue per room type, which I can then combine with the SQM of the room for example, to see what room type works best.
How do I filter and display revenue per room type (or avg stay, or whatever else) from one table into another?
Free hostel night in the center of Prague, Czech Republic for anyone that helps me out here!