Hi,
I am trying to get more detailed insights by using Influx and Grafana. (by means of the Homey influx app)
But it is not as user friendly as I was hoping.
I already installed the programs and they are linked to my Homey and to each other.
Could somebody explain how to make nice graphs and statistics?
For example a bars view with daily power usage (from a Smart switch with Power by the Hour), etc.
Thanks!
That’s a bit offtopic here, since you’re basically looking for a Grafana tutorial.
I’ve gone through the learning myself recently. Using InfluxDb v2 using both grafana and InfluxDb (v2) Web ui. Learn, read the manuals. Are you already able to see data in the db? Read on CLI access with InfluxDb for queries.
It is indeed of topic here unless you don’t get data from InfluxDb app in Homey to your DB. PM me if you stay stuck after reading and learning more on this matter.
@Pieterv123 my grafana dashbard is shared in the grafana community. it uses the prometheus app for gathering metrics though
I have data from InfluxDB Cloud and Grafana and for those they would like to follow, I created two very simple screen by screen guides. I hope you don´t mind if I share it here.
Hi. Sorry for bumping this up. I try to integrate a grafana dash to visualize power meter in my dashboard. I am using InfluxDB through Homey app, and i seem to receive all information to Influx, but it seems like there are some issues when implementing it to Grafana. I get connected and Grafana accept the bucket, but i cant seem to find any of the data stored in influxDB. I followed Michal_Stranik’s briliant how to guide, but it might be outdated? Any suggestions?
Hi, maybe you will not need this anymore. You can use Homey Dashboard (currently in BETA).
It seems there is a lot of knowledge here regarding InfluxDB and Grafana.
With the help of the information in this forum, I managed to set everything up.
So now, I have everything covered from now and into the future.
However, I am looking for historical data.
When I export the CSV from Homey, I cannot import it into InfluxDB.
I’ve spent two full evenings using ChatGPT and searching online, but I just can’t get it to work.
I also have data from before my Homey days, also in a CSV format, which InfluxDB doesn’t accept.
Additionally, I would really like to have all the accumulated data from Homey in InfluxDB.
Who can give me a push in the right direction or help me out?
Why not use this app?
Is MySQL a valid source for InfluxDB?
I am currently using InfluxDB. But can I also push Homey’s historical data into InfluxDB somehow? And is MySQL necessary if I am already using InfluxDB?
Hi,
Yes you can with the InfluxDb app I linked to:
MySQL app is not needed in this case.
Ok. But maybe I don’t have enough knowledge, but how to get the history from last as an example in influx.
It only updates since my installation.
That’s quite how things work.
Please ask in the InfluxDB topic I linked to, on how to export all insights data to InfluxDB.
