Gauge with dynamic thresholds based on name or query?

I am trying to create a dashoard that has a dynamic gauge and threshold, but im drawing a blank on how to do this.
You can see my metrics i am compiling in the below screenshots

store_tank_inventory=current fuel volume
tank_capacity=total tank capacity
max_fill_capacity=the most it should be filled
delivery_needed=when store_tank_inventory gets close to here trigger an alert for auto fuel dispatching
high_alert_level=triggers alert that the tank was overfilled
low_alert_level=triggers alert that the tank is running low, and going to run out soon.

I have the alerts figured out with some recording rules i think. i am just not being very creative i guess today and having a hard time designing a dashboard around this data, and need to figure out the dynamic thresholds