Query Generated limits on goal / gauge widgets

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

1 Like

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:
image
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.

There’s a couple of issues about this - more or less the same - upvote by clicking :+1: on the first post of each:
https://github.com/metabase/metabase/issues/6514
https://github.com/metabase/metabase/issues/4412