It seems silly that we are unable to dynamically assign limits via SQL queries / questions in an application that is designed to display SQL data. Having to hard-code these values makes these gauges significantly less useful
I couldn’t see anything on GitHub that would help, you could add your own issue as a feature request.
For anyone else, here’s the equivalent in MS PowerBI:
The dashboard allows you to select a property or all, number of bookings and number of available rooms both come from SQL.
Only workaround is to do percentages up to 100.