Looking for some advice on how to best handle this…
We have TRUE/FALSE sensors on a variety of equipment and are storing any change in state. See below.
The above is from Grafana and InfluxDB 1.8, where we store the boolean status info every minute, which to me seems ridiculous because the state only changes ~5% of the time.
We are currently planning our migration of all data to Influx 2.0 and re-writing our queries in Flux. It seems it would be better to store ONLY the changes in state. The goal here is to use Grafana to display only the changes in state. Surely someone has crossed this bridge before?