Hello new to the grafana world and super impressed!
I try to follow this tutorial but on my VPS (influx, grafana) and a RPi/esp32 (local)
I have esp32[humidity,temperature]—> MQTT —> Raspberry Broker —> Raspberry NodeRed —> THE INTERNET —> VPS InfluxDB —> VPS Grafana
My database has just two measurements
> show measurements
name: measurements
name
----
humidity
temperature
The humidity format:
> select * from humidity limit 10
name: humidity
time value
---- -----
1611612999195034492 43.00
The temperature format:
> select * from temperature limit 10
name: temperature
time value
---- -----
1611612999183790945 26.00
This is what I sent to the DB from nodered.
1/26/2021, 12:59:08 AM[node: cc79021b.9a751](http://mosquitto:1880/#)esp32/temperature : msg.payload : string[5]
"27.00"
1/26/2021, 12:59:08 AM[node: 22efa7b7.544a28](http://mosquitto:1880/#)esp32/humidity : msg.payload : string[5]
"42.00"
InfluxDB connected no errors.
When I try to add a panel and select humidity or temperature I get an error
If I delete the
GROUP BY
time ($__interval)
fill (null)
which is the default I get the graph on the panel but the cursor do not show the values
I think I do the same as the guy in the video but I do not get the same results.
I was playing with a MySQL and had the same problem of not showing the values under cursor and I had to cast string to float.
In the video he pushes string to db though.
Any help is appreciated, thank you