Plot Existence of data

[davidhy]

• What Grafana version and what operating system are you using?
  9.2.3

• What are you trying to achieve?
  In a general overview dashboard, I want to see if the data for the selected period of time exists or doesn’t. Not the value itself, but a True/False kind of time series graph.
  So I have a couple of devices that connect sometimes and write data to influxDB, and I would like to have a graph just to see who was connected and when.
  Note: I write the data myself.
  It sounds like something quite simple, but I miss how it can be done.

[grant2]

Are you using InfluxQL or Flux?

[davidhy]

@grant2

I’m using Flux.
I can generate a 0/1 signal using map() and “No Value”, but as a time series it doesn’t look as nice as I would like.

[grant2]

Hmmmm…If you are looking for a graph showing On/Off, would something like this work? (shown in Influx…it would be prettier in Grafana).

[davidhy]

I realized I should’ve just used the state timeline panel with a combination of a “No Value”.
Something like that:

Thanks for the help