How handle null influx data

Grafana InfluxDB
1

I have five measurements in my InfluxDB: ups1, ups2, ups3, ups4, and ups5. These measurements show up in my Grafana table as the status of each UPS. However, if one of the UPS devices goes offline or loses communication, it disappears from the table, and only four UPS devices are displayed. How can I handle this situation? I want to ensure that if one measurement stops sending data, it still appears in the Grafana table as ‘offline’ instead of disappearing."

How to handle this empty query from grafana and show offline in a table

2

I am using dummy data for that.

See this post for an example.

It is also possible to join query that explores schema (this will always return all measurements - ups1, ups2 etc.) with query that returns data

3

image
image1879×512 100 KB

as seen on table" LeedervilleServerUPS" is offline but it disappear in table, I have no idea to to handle this situation showing offline in table cells , I tried lot of ways still i’m helpless.