HI! I am very very new in influxdb and IOT.
I am getting data from 2 sensors (in the future will be more) and i am storing the data in 2 MEASUREMENTS, “temp” and “hum”.
In this measurements i have set 3 “columns” (sorry for the terminology i don’t quite understand influx 100%), timetag(automatically via influx), value and sensor_id.
I want to put all the sensors in the same graphic and i want to be dynamic, if i add a new sensor i want that the data appears automatically in the graph.
Like i said i am very new in influx and i have no problem in remaking the database if necessary.
I put some images to help explain.
In this image i have the 2 querys for both MEASUREMENTS in the same graph but i can chage that if is a problem. As you can see both sensors sand data at the same time (coincidence). I want to be group by the sensor_id.
Here are the data stored.
Thanks in advance! Happy new year!