Grafana Graph Help - Door Sensors

Hello Awesome Peeps

It hadn’t clicked until yesterday that all my sensor history is not kept in recorder. Luckily I had been running Influx from a previous implementation and have all the data. I have setup installed Grafana and have been trying to find a way to visualise my Door Sensor data.

IN an ideal world, I’d have my days on one axis and time on the other. The Door open (1) is displayed as green and door close (0) is displayed as red. I’d set thresholds for over say, 9PM and under say, 6AM. This allows me to see when kids breach their curfews at a glance.

Example; Imgur: The magic of the Internet

Is this possible in any way shape or form??

My HA lovelace data is Imgur: The magic of the Internet

My current Grafana is https://i.imgur.com/PwNiDHF.png

Provided my ideal is in no way possible, in the current state can I highlight/bold lines based on my time thresholds or group data by day?

Many many thanks in advance

The statusmap-panel plugin can do this:

Add this to the addon options to install it:

plugins:
  - flant-statusmap-panel
1 Like

I’ll check it out in the morning! Thanks!