I’m pretty new with InfluxDB, and I am sorry to say that I am experiencing some troubles trying to understand how it works (as I work everyday with Oracle and SQL).
So I’m using InfluxDB for storing data from HomeAssistant sensors (and showing them with Grafana)
Everything works quite well except for some smart plugs with energy monitoring.
Energy isn’t captured by InfluxDB (maybe it’s not event exposed by the sensor) but, as I can read it from the original smart plug app (i.e. Ewelink, or MiHome, or Tuya) I would like to manually insert it in InfluxDB, or better: I would like to insert daily kwh consumed.
So it should be something like:
INSERT kwh, entity_id=plug1 value=10
INSERT kwh, entity_id=plug2 values 5
but I am missing how to insert a date, so the value 10 for plug1 is for example for the 1st of november 2018
Can someone help me?
And moreover, I’ve not installed the command line tool, is it possibile to make insert from the web interface?
Thansk in advance!