I’m using influxdb and grafana and was curious whats best practice if i get sensordata like moisture from a soil sensor every 5 minutes but also want to save the location and plant it is measuring. Location and plant are not changed often, like every month or so.
Should i write this to the measurement Sensor1 every 5 minutes when there’s a new value? Or do i have to create another measurement and link it through an id or something? Or is it even possible to ask for f.e. WHERE location = Outdoor “and all following” so i just have to enter it once in the same measurement.
The goal is to create a dynamic graph that automatically shows all moisture values of all sensors located in the same room. In addition it should show the name of the plant in the legend for every sensor (like tomato).
A hint to the right direction would be awesome, searched several days with different answers.
For 2 measurements:
for adding it to every value: