I’m storing my values in an influxdb:
Fields: sensorname and humidity (note: each sensor is logged with its humidity value at the same time)
With InfluxQL it was easy to gather the data of each sensor and display the values in grafana:
"SELECT mean("DeviceName") FROM "autogen"."humidty" WHERE ("DeviceName"::field = ‘Office’) AND $timeFilter GROUP BY time($__interval) fill(null)
While trying to achieve the same with Flux, I never succeed. I can either show the sensor names or the values, but never select all values which belong to a sensor.
Or should I end up using an individual measurement for each sensor? (There was never a need for that in MySQL or so, but maybe I’m misunderstanding the idea of NoSQL).
Any help here would appreciated!