Statistics in Home Assistant with InfluxDB and Grafana

  Рет қаралды 63,128

Smart Home Addict

Smart Home Addict

Күн бұрын

Thank you for watching. In this video we will set up statistics monitoring using the InfluxDB database engine and the Grafana dashboard.
Home Assistant by default only retains 10 days of statistical data, it is recommended not to increase this. If you need to access statistical data beyond this, it can be recorded in a separate database. InfluxDB is ideal for this. You can host this on a database internal to your Home Assistant installation, or on a separate database server. To keep things simple, we are using the InfluxDB addon from the addon store.
Code from the video:
influxdb:
host: yo.u.r.ip
port: 8086
database: homeassistant
username: homeassistant
password: Password123
max_retries: 3
default_measurement: state
Change the above as appropriate, replacing your own IP address and the credentials that you set.
Please like and subscribe, and click on the notification bell so you can be alerted to new videos.
If you would like us to create videos on a particular topic, technology or product, please leave a comment below.
When browsing to your Home Assistant instance, this is usually - homeassistant.local:8123. If this does not work, try homeassistant:8123. If all else fails, check your router's device listing for the IP address.
Chapter links:
0:00​​​​ - Intro
1:10 - Installing InfluxDB
2:28 - Create database
4:11 - Configuration changes
6:24 - Install Grafana
9:02 - Creating Dashboards
15:36 - Outro
The below is completely optional but this will help us to purchase kit for review, and to keep up with channel expenses (studio equipment, etc).
Amazon link (no cost to you but buying through the link helps my channel) - amzn.to/3fj2S8a
Ko-Fi - ko-fi.com/smarthomeaddict
Buymeacoffee - www.buymeacoffee.com/smarthom...
Patreon - / smarthomeaddict
Finally, please visit our website at smarthomeaddict.co.uk

Пікірлер: 49
@CarAudioInc
@CarAudioInc 4 ай бұрын
one of the rare instances where the addons are harder to configure than the docker containers, lol thank you
@OleBrinch
@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.
@dereksedunary1341
@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.
@MarkSnop
@MarkSnop 4 ай бұрын
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.
@skragh77
@skragh77 6 ай бұрын
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
@rrschmid
@rrschmid 2 жыл бұрын
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!!
@sethreeder4264
@sethreeder4264 Жыл бұрын
A well paced tutorial, many are too fast, thank you.
@johnbrisbin3626
@johnbrisbin3626 11 ай бұрын
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.
@jachencarl
@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.
@tony113000
@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)
@reverseesrever675
@reverseesrever675 Жыл бұрын
Thank you so much, tutorial easy to follow ......Setup on HA now ...working beautiful..
@darcymac7754
@darcymac7754 11 ай бұрын
A great help, thanks for sharing, your time is appreciated!
@RicardoSantos-zh5uz
@RicardoSantos-zh5uz Жыл бұрын
Really nice and easy to follow. Many thanks!
@endelight
@endelight Жыл бұрын
Quick and easy to understand. Helped me a lot :) Thanks.
@gonzalonietomorales1350
@gonzalonietomorales1350 Жыл бұрын
Very good video to the starter people, thanks so much.
@dougbas3980
@dougbas3980 7 ай бұрын
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.
@fritzx720
@fritzx720 Жыл бұрын
You made my day! Tnx for the intructions.
@mickegullberg574
@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 ?
@iotprojecthindi
@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
@norienor4658
@norienor4658 Жыл бұрын
thank you for the help. thumbs up and subscribed
@akashsivasubramanian4067
@akashsivasubramanian4067 11 ай бұрын
Thank you so much for the wonderful video
@Zbyszekakaduk
@Zbyszekakaduk Жыл бұрын
Greetings from Poland and thank you for your help. Great tutorial.
@LookatBowen
@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?
@larryn9536
@larryn9536 2 жыл бұрын
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.
@user-oi2xo8ve8q
@user-oi2xo8ve8q 5 ай бұрын
Very good instruction man! Thx
@fanat802
@fanat802 Жыл бұрын
Спасибо! Благодаря твоим настройкам смог перенести график на панель и избавиться от localhost в адресе url.
@lsismeiro
@lsismeiro 2 жыл бұрын
Well explained, my suggestion would be to create some Grafana graphs of energy per hour, day and month.
@SmartHomeAddict
@SmartHomeAddict 2 жыл бұрын
Thank you. I will add this to a follow up video covering other graphs.
@skeldon66
@skeldon66 Жыл бұрын
Thanks for your help
@jitendrasonavane82
@jitendrasonavane82 2 жыл бұрын
nice and easy tutorial
@indianpolish5297
@indianpolish5297 6 ай бұрын
Thanks 👍
@wilhelmmagnus9205
@wilhelmmagnus9205 9 ай бұрын
Super tutorial !
@tjk031
@tjk031 2 жыл бұрын
thanks great video
@cedricdelecole3964
@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 !
@Lonestar101
@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.
@peterl1771
@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
@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.
@mateussilva3756
@mateussilva3756 Жыл бұрын
Is it possible to change the panels in real time, interactively directly from the dashboard?
@pajikcz
@pajikcz 8 ай бұрын
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?
@artyb7696
@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?
@longngo2418
@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
@Herd_of_Worms 2 жыл бұрын
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
@SmartHomeAddict 2 жыл бұрын
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
@Maaatiii Жыл бұрын
How to migrate existing HA data to Influx ?
@Szymonccc
@Szymonccc 2 жыл бұрын
I cant remove panels from Home Dashboard i dont have save button. Do you have any idea ?
@MazenS
@MazenS 3 ай бұрын
I've got the same problem - did you ever figure out how to do this?
@davidwalker5726
@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
@talhatheoptimist8153 Ай бұрын
the configuration.yaml code is different for me The entries under homeassistant.autogen dont show up
@drug8007
@drug8007 Жыл бұрын
СУПЕР
NEXT LEVEL STATISTICS - Home Assistant InfluxDB and Grafana
36:08
Everything Smart Home
Рет қаралды 125 М.
INSANE STATISTICS In Home Assistant With Grafana! - TUTORIAL
20:15
Smart Home Junkie
Рет қаралды 74 М.
لقد سرقت حلوى القطن بشكل خفي لأصنع مصاصة🤫😎
00:33
Cool Tool SHORTS Arabic
Рет қаралды 22 МЛН
Inside Out Babies (Inside Out Animation)
00:21
FASH
Рет қаралды 22 МЛН
НРАВИТСЯ ЭТОТ ФОРМАТ??
00:37
МЯТНАЯ ФАНТА
Рет қаралды 8 МЛН
Meet Spook. A new toolbox for Home Assistant. It's SCARY!
30:46
mostlychris
Рет қаралды 47 М.
Home Assistant Remote Access using NGINX
9:31
Smart Home Addict
Рет қаралды 37 М.
15 Home Assistant Tips You MUST Do
14:28
Everything Smart Home
Рет қаралды 357 М.
Wait... PostgreSQL can do WHAT?
20:33
The Art Of The Terminal
Рет қаралды 191 М.
My new Proxmox Monitoring Tools: InfluxDB2 + Grafana
19:46
Christian Lempa
Рет қаралды 111 М.
This is SO Much Better! Getting Started with ESPHome 2021
29:42
Everything Smart Home
Рет қаралды 328 М.
5 Home Assistant Automations For Better Smart Lights!
15:58
Everything Smart Home
Рет қаралды 130 М.
I've been using Redis wrong this whole time...
20:53
Dreams of Code
Рет қаралды 346 М.
Jason made a fun pool in the Truck
0:21
Jason Vlogs
Рет қаралды 7 МЛН
Istanbul havuz keyfi #filizkemal
0:25
Filiz Kemal
Рет қаралды 24 МЛН
Пёс - Парашютист 😍
0:42
ДоброShorts
Рет қаралды 1,8 МЛН
Nika loves to eat chicken #cat #cats
0:17
Princess Nika cat
Рет қаралды 79 МЛН
Someone hit my RV with mud. #rv
0:30
campingWorld
Рет қаралды 3,1 МЛН