Show panel with data and no data in response

Grafana InfluxDB
1

Hello
I want to create an UP / DOWN pannel.
So i have a stat panel with same influxDB querry for check the uptime of many server.
I show uptime value in green color if UP
If no data, (server down), i want to show a DOWN message and red collor.

My problem is, if the query has NO DATA, the query is hidden. Only result with data are shown in the pannel
If no data i want to force my host to show DOWN, or 0 value. Any idea how do it ?
Value mapping don’t change anything

SELECT last("uptime") FROM "system" WHERE ("host"::tag = 'HOSTNAME') AND $timeFilter GROUP BY time($__interval) fill(null)

1 Like
2

See this example. It is in Flux, but idea should be clear and may work for your case as well.