In SmartThings, I had set up a google sheets integration that worked to pull points I wanted into Sheets. From there, I could use basic spreadsheet capabilities to analyze and graph data offline.
I'm finally looking to do the same for Hubitat. I found some database solutions (which I have yet to find a tutorial that I'm capable of succeeding on!), as well as this thread for google sheets (also struggling, I think it's outdated a bit), and also the WebCore graphing/trending that saves stuff locally (I've got it working but it is buggy and breaks a lot, I'd consider it barely functional right now).
Is there anyone working on a solution that is simple and works for the masses for something like this? I would gladly pay for this capability, personally.
If anyone knows of a really nice tutorial for graphana and influxDB, please pass my way. I've been trying to figure out how to install a docker on QNAP and use that with Hubitat, I've just had zero success because nothing is specific enough for this use case I believe.
unsure if you want to go all in or not - but the use of Influx with grafana has become so simple - people are trading templates!
Even I could do it. Oh. and bonus - you can implement your own Echo Speaks while you're at it.
something I wrote around here somewhere - last I looked it was no longer accurate as Grafana had a major version change. on your qnap, load influxdb 2, then use HPM to install Influx logger - pick some devices to connect and push out data. On the influx side, create a DB, be careful the name you use, case sensitive - and the user token. Put the token into the HE influx logger with the URL (the instructions will give some help) and finally load Grafana on your qnap and hook it too Influx as the source. then play play play. Grafana is great - but initially it isn't easily intuitive until you start playing.
