Using grafana 10.2.2 and Grafana Status panel 2.0.0
I do realize that postgresql is not among the listed data sources for the Grafana status panel, so it might be that is the reason it is not working.
I have a postgresql query that gives me three fields: A service name (string) a parameter for the service(float) and a timestamp. When I try to set this up for a Grafana Status Panel, I just get a green field with the annotation “A - invalid number” I would expect to be able to set it up to have one square per service that could be set up to display different colors depending on the value of the parameter.
Grafana works with data frames and is pretty abstract from datasources, so this should not be the reason.
What do you have in a Table view of this panel, i.e. what data does your query return?
if you are getting a numeric field back from your query, you can use a transformation, convert field type, to tell grafana this a numeric field
It turned out I had not understood properly how the status panel is working. One status panel is just showing one status.
So
Rather than having one query returning all the status information, I have to set up a variable with a list of all the sites I want the status for, then I adjust the query to just fetch the information for one site, using the $variable syntax, then I repeat by variable and get one status panel for each site.
It can show several statuses as well (Value options - Show - All values):
