Showing the value of a field in the graph but using the value of another field for colors in a Stat panel

I am trying to create a Stat panel while using Grafana 8.4.1 that shows the result of a field in the center of the panel but uses another field to color the panel.


Using the following query:

SELECT 'test' as text, 1 as metric

I want to show:

Test being the field “Text” and the field “metrics” used to color the background of the stat panel green.