Statistics in Home Assistant with InfluxDB and Grafana

[@dereksedunary1341]

I had been doing a lot of reading trying to build up my confidence to install InfluxDB so I had more than 10 days of history. Following your simple, clear, step-by-step instructions I now have InfluxDB and Grafana installed and working without problems. Thanks very much, excellent tutorial.

[@CarAudioInc]

one of the rare instances where the addons are harder to configure than the docker containers, lol thank you

[@johnbrisbin3626]

As noted in other tutorials, you may need to visit the configuration for the InfluxDB addon to disable SSL, if you don't have the certs for it. Symptom of this is in the Explore stage where the Database autogen will appear but no data. Do the same for Grafana.

[@MarkSnop]

This was very well done thank you very much. I learned a lot. I guess the Grafana updated at some point because when we first started to say, (9:01) delete the panels that were on the screen, I wasn't able to do that and I kind of muddled around and created a new dashboard and then followed along with you.

[@rrschmid]

nice work! wasted half a day stuffing around with docker containers of influxdb and grafana when I came across this video and was up and running in 15min! legend!!

[@OleBrinch]

Thank you so much. After having been afraid of the influxDB+Grafana setup on HA for months, it was all over in 30 minutes and works beautifully. Very thorough and easy to follow tutorial.

[@skragh77]

This was EXACTLY what I needed.. thank you so much for making this.. I will be sure to follow for more learning in a pace I can follow

[@sethreeder4264]

A well paced tutorial, many are too fast, thank you.

[@jachencarl]

Thank you for this stupend Tutorial. Good speed, easy to follow and perfect Semantics and Didacticts. And your English is so well understandable even for me with a foreign mother tongue.

[@reverseesrever675]

Thank you so much, tutorial easy to follow ......Setup on HA now ...working beautiful..

[@dougbas3980]

I tried before to setup influxDB and Grafana and failed. Working along side this video playing, I got it. Took a little diddling because new version of Grafana has some differences. But pushed thru that and got it. Much appreciated; Thank you.

[@larryn9536]

Thank You so much. This was an excellent video, it was easy to follow and accurate. I'm new to home assistant and your video helped me quickly install influxdb and graphana. I am now a subscriber and will be watching you other videos.

[@Zbyszekakaduk]

Greetings from Poland and thank you for your help. Great tutorial.

[@iotprojecthindi]

Hello sir I am planning to develop a home automation system for my college project, which I also intend to implement in my own home. The system involves connecting multiple relays and sensors, and I have chosen to use NodeMCU devices for this purpose. Each NodeMCU board will contain several relays and sensors. To overcome the limited range of the router's signal, I have established a mesh network of NodeMCU devices, with each device connected to the router. Additionally, I plan to utilize the Home Assistant operating system to control the relays. To program the NodeMCU devices, I have opted for Node-RED, and for storing the sensor values and relay statuses, I have selected InfluxDB as the database. Furthermore, I plan to use Grafana as a data visualization tool to create an attractive dashboard for the system. In this home automation system, I aim to incorporate the following features: 1. Manual Control: If the home automation system fails, I want the system to function as normal, allowing manual control over the electric appliances. 2. App Control: I want to implement an application-based control system, enabling users to control the system and its connected devices remotely through a mobile app. 3. Automation of Electric Appliances: I intend to automate the operation of various electric appliances, such as lights, fans, and other devices, based on predefined schedules, triggers, or user preferences. Now, I have a couple of questions regarding the implementation of this system: 1. How can I effectively utilize the mesh network of NodeMCU devices to control all the relays and read sensor values? I would appreciate insights on managing communication and synchronization within the mesh network. 2. I would like to implement MQTT protocol in my home automation system. Could you provide guidance on integrating MQTT effectively, ensuring reliable communication and message exchange between the devices within the network? Thank you

[@gonzalonietomorales1350]

Very good video to the starter people, thanks so much.

[@darcymac7754]

A great help, thanks for sharing, your time is appreciated!

[@tony113000]

Thanks so much for this - well explained and to the point - keep up the good work !! Will look for more of your videos (and have subscribed)

[@lsismeiro]

Well explained, my suggestion would be to create some Grafana graphs of energy per hour, day and month.

[@SmartHomeAddict]

Thank you. I will add this to a follow up video covering other graphs.

[@endelight]

Quick and easy to understand. Helped me a lot :) Thanks.

[@fritzx720]

You made my day! Tnx for the intructions.

[@norienor4658]

thank you for the help. thumbs up and subscribed

[@RicardoSantos-zh5uz]

Really nice and easy to follow. Many thanks!

[@ИльяКаратаев]

Very good instruction man! Thx

[@akashsivasubramanian4067]

Thank you so much for the wonderful video

[@Lonestar101]

The IP address that you entered in both Influx DB and Grafana.. is that supposed to be the IP address of Home Assistant, I assume? Can't wait to try it.

[@LookatBowen]

Great video, great music background. You had my feet tapping while waiting for the installs to complete. Easy to follow instructions. I have a question though. Do you know how to export the history from the Energy Dashboard to InfluxDB/MariaDB?

[@jitendrasonavane82]

nice and easy tutorial

[@mickegullberg574]

Thank for a super tutorial. Easy and simple to follow. Love to see a tutorial on how to resize cards and stack them in a lovelace. 🙏🙂. And can u put this grafana graph on a lovelace card ?

[@wilhelmmagnus9205]

Super tutorial !

[@tjk031]

thanks great video

[@pajikcz]

so Influx acts as a secondary db tracking state changes and sensor data for Grafana, but HA still uses it's primary db for it's normal operations. So you run BOTH side by side. Am I understanding that correctly now?

[@fanat802]

Спасибо! Благодаря твоим настройкам смог перенести график на панель и избавиться от localhost в адресе url.

[@skeldon66]

Thanks for your help

[@indianpolish5297]

Thanks 👍

[@cedricdelecole3964]

Thanks a lot for this ... I was looking for the default retention period of HA, I see I could use Influx DB to increase it .... Question I have is like on the energy dashboard which gives LIVE data in power consumption (watts), you know, with the dots running on the lines .... based on my energy sensors ... is it possible in graphing to have such LIVE representations with real time data ? Many thanks !

[@peterl1771]

Thank you for the tutorial. I have tried MariaDB before but wasn't able to visualize in Grafana. Now with InfluxDB it works just as you showed it. I saw in your configuration.yaml that you have the MariaDB also installed. ( @ 4:12 ). Any good reason for running two databases? Or can I get rid of the MariaDB after installing InfluxDB?

[@SmartHomeAddict]

MariaDB in the video was for another video tutorial. I replaced my existing HA database with MariaDB. InfluxDB is more suited for statistics and therefore in conjunction with Grafana.

[@artyb7696]

I have a sensor that I created, so it does not have unique ID. This is the error message from Home Assistant when I click on the sensor - "This entity ('sensor.today_max_pv') does not have a unique ID". What do I use for entity ID?

[@mateussilva3756]

Is it possible to change the panels in real time, interactively directly from the dashboard?

[@longngo2418]

Thanks for useful Video about Homeassistant. I used Virtual box to build HomeAssistant. I configed the configuration.yaml follow your video. But, I cannot access the ip of HomeAssistant. I tried many time, it is not ok. Can you give me some advise to resolve this problem😭😭😭😭

[@Herd_of_Worms]

Nice video! I was going good up to when I click next to homeassistant auto gen i dont see any data. Only see data on the internal monitor any ideas? EDIT*** never mind i rechecked yaml config and had a typo in IP address. All's well now! thanks again!!

[@SmartHomeAddict]

I've lost count of the number of times I've made a typo and struggled to find it (usually ends up being an extra space making it impossible to find!). Glad you sorted it in the end.

[@Maaatiii]

How to migrate existing HA data to Influx ?

[@Szymonccc]

I cant remove panels from Home Dashboard i dont have save button. Do you have any idea ?

[@MazenS]

I've got the same problem - did you ever figure out how to do this?

[@davidwalker5726]

Thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you !

[@talhatheoptimist8153]

the configuration.yaml code is different for me The entries under homeassistant.autogen dont show up

[@drug8007]

СУПЕР