I have 32 sensors. Whenever the value of a sensor changes, the new value it put into an InfluxDB2 table. What I would like to do is plot those 32 sensors in one graph with the x-axis being the time and the y-axis being the value of the sensor. The issue is,
a) the timestamps are not at a fixed interval because data is only written into the DB when a value changes.
b) For a particular timestamp, I only have data for one sensor. So for the other 31 sensors there should just be some interpolation (linear is fine) between the last reading and next reading.
Can this be achieved with Grafana? If not, I have to write a new program that just reads all 32 values at constant intervals and store all 32 values to the DB, even if the values didn’t change.