INSANE STATISTICS In Home Assistant With Grafana! - TUTORIAL

[@jasonstation]

Great to see at the start of the video how we need to wait for things to start up. I've been thinking my HA has been crashing and not working all this time when installing things. HA could really do with a status bar just as in Microsoft etc to show progress of install.

[@ArieMoret]

Thanks! I dislike youtube movies with explanation on how to get things working. Mostly there boring or the maker loves himself more then the audience. Not to speak about how rapid there talking and like to here themselves. This is the first video i like, It has noting to do with my previous comment about other youtube tutorials. I succeeded to set up my HA with InfluxDb and Grafana after pausing this movie every now and awhile and got it working. Thanks again

[@SmartHomeJunkie]

Thank you for the compliment!

[@miguelhurtado3873]

Great thankyou! I make it all work I followed your tutorials videos. I got a Esprimo Q956 running continuously.

[@SmartHomeJunkie]

Great that it helped!

[@matejfoltyn]

Thank you for the explanation. For the life of me I couldn't get the database to work but I finally did when following your steps ;)

[@SmartHomeJunkie]

Oh, great to hear that you managed to do it using this video. Cool!

[@kobedde]

Another very interesting tutorial. Thanks for sharing 👍

[@thedarkknight76uk]

Absolutely brilliant guide. I now have a temperature dashboard for my heating system :0)

[@SmartHomeJunkie]

Thanks!

[@82kitas]

really great, clear voice, very patient! thx a lot!!

[@SmartHomeJunkie]

Thanks!

[@calgarraway9509]

Thank you for the tutorial. Very well done and much appreciated.

[@csteinbeck]

Thanks again for this great video. Helped me to setup my first Grafana dashboard. It also made me realise that the naming of entities in my home assistant is all over the place, and it is really hard for me to find the right thing in the grafana visualisation dialogue. Did you ever have some advice on a proper naming scheme to adopt for home assistant? I could not find anything in your video list.

[@SmartHomeJunkie]

Yes, in this video: Five Best Practices in Home Assistant - Use this now! kzbin.info/www/bejne/baDSk4l-gsx_ZpY

[@csteinbeck]

@@SmartHomeJunkie Brilliant, thanks! I‘ll have a look.

[@mohamadallif2997]

You are good teacher, keep it up.

[@SmartHomeJunkie]

Thank you for this wonderful compliment! 🙏🏻

[@leonpotgieter1133]

Thank you , got it going first time still much to learn

[@SmartHomeJunkie]

Great to hear

[@leighbellote2546]

Great video, sets you up and running so you can really explore. thank you

[@SmartHomeJunkie]

You are very welcome.

[@ErikvanTrijffel]

TOP! gelijk weer inspiratie om wat uit te proberen.

[@SmartHomeJunkie]

Graag gedaan Erik! Hier kan je je ook helemaal in verliezen.

[@1977marcomarcolli]

Great video! Thanks, your explanations are always really clear

[@SmartHomeJunkie]

Great to hear!

[@wallysteadman8327]

I am not seeing any data when I go to the explore icon. Is there a way to validate I am connected?

[@SmartHomeJunkie]

You mean in Influxdb? Maybe you can check the logs. You probably have an error in your configuration.yaml of no data occurs in Influxdb.

[@eta2001carl]

Nice, just what i was looking for :)

[@SmartHomeJunkie]

Great to hear that it helps!

[@fotogeekbrix]

Thanks for the video :-) I'd be very interested to see how you do some og the more advanced panels. The barometer gauge and rise/fall thing :-) but also how to have the 0°C in the temperature panel. Cheers!

[@SmartHomeJunkie]

That's a nice suggestion.

[@nicoladellino8124]

Very nice video, TNX.

[@Stile30]

Question: how to add states history bar in Grafana? I tried almost all options but I failed. Like it has no data to display. What should be query and process? Thanks.

[@techaditya2894]

Really Good Explanation, keep it up sir...

[@SmartHomeJunkie]

Thank you so much for your kind words!!!

[@techaditya2894]

@@SmartHomeJunkie always like your video, Good Night From India, Sir....

[@SmartHomeJunkie]

Good night to you too!

[@rgrf]

Well done, thank you

[@SmartHomeJunkie]

Thank you for your kind words.

[@btrigaux]

Hello, thanks for this great video : very clear and precise. I conducted the setup without any trouble. Question: what about backups of this influxdb ? Note that currently I have my HA platforms backed-up to Google Drive with the great add-on Google Drive backup that works like a charm.Thanks, Bernard.

[@SmartHomeJunkie]

I believe that the Influxdb is also in that backup. Didn't test it though, but it should be.

[@btrigaux]

Thanks for prompt reply. Indeed full backup should take it. But I guess I need to proceed with creating a snapshot of the influxdb before the actual backup of HA. I will keep searching in that direction. Thanks again for the excellent knowledge you share with the community !

[@GarethHowell]

Thanks for this video. How did you put the Barometer panel together? I can see how to do a Stat visualization, but not how to get the bottom graph with the annotations and trend.

[@pjkindt7683]

Awesome video! One question: how do you make the dropdown menu in the right upper corner to choose between your dashboards? Dankuwel!

[@SmartHomeJunkie]

I think it's in the dashboard settings of Grafana. Not near a computer now, but I'm pretty sure it's somewhere in that area.

[@koenboom9959]

Worked perfectly, thanks. Is it maybe an idea to make a video about how to convert the total energy consumption to a daily measured one? Now for the DSMR you only log the total amount, but not what is daily used. I think you mentioned it in your video that you also had some graphs for daily use of energy?

[@SmartHomeJunkie]

Yes, actually I log the daily amount and in Grafana I create a query that shoes the total amount, weekly amount and so on.

[@koenboom9959]

@@SmartHomeJunkie you log the daily amount with a sensor in home assistant? In the configuration.yaml I presume? Can you show the code for such sensor?

[@SmartHomeJunkie]

I use the DSMR integration for that.

[@koenboom9959]

@@SmartHomeJunkie ok.. from my meter I didn't got daily/weekly/monthly numbers... Only usage per hour, which is not always reliable. I use now utility meter integration as well on top of the same with a daily cycle, but doesn't seem to work. Maybe I am doing things wrong...

[@SmartHomeJunkie]

Well, I created some helpers and custom sensors to calculate done values.

[@STAXza]

Great tutorial! Can you tell us how to add a graph to a lovelace card. I get 401 Unauthorized.

[@SmartHomeJunkie]

That can only be done with an I think, but you can also use the custom mini graph card.

[@stives466]

Thanks for the video. What is the query to display the consumption for each day for a month (non-rolling days)?

[@carralf]

Followed every step.... thanks...

[@SmartHomeJunkie]

Great!

[@photelegy]

Is it possible to show this Grafana graphs in the Dashboard/Lovelace?

[@SmartHomeJunkie]

You can, but you have to use an for this I believe.

[@cxgamer9680]

Thanks!

[@philippebezie1331]

Just perfect !

[@SmartHomeJunkie]

Thanks for your kind words!

[@Alain9-1]

thank you for the explanation, please can you tell me how to identify the peaks in a graph

[@SmartHomeJunkie]

Hi, I am not sure what you mean.

[@Alain9-1]

@@SmartHomeJunkie don't mind i've resolved the problem, thank you anyway

[@SmartHomeJunkie]

Great!

[@metalhead5858]

Hoi, ik heb je tutorial gevolgd en er komt data in mijn database alleen het veld gebied dat ik bij een sensor kan aangeven lijkt niet in de database aanwezig. Ik kan het niet vinden.

[@SmartHomeJunkie]

Geen idee. Dan is er toch iets anders bij jou dan bij mij.

[@valuecreator33]

Thank you for a great video! After following all the steps I'm getting success messages that everything is working, but I am not able to add anything or see states of my entities. What can I have missed? Using latest version of everything

[@SmartHomeJunkie]

I'm sorry to hear that. Not sure what's going on.

[@Marco-gv3pr]

Bedankt

[@SmartHomeJunkie]

Dank je wel voor je support! Echt top!

[@50sidu]

is it possible to download the log data of any connected switches status and also is it possible to create a graph to see the status change of the connected switch

[@thepyropc_]

my entities and sensors rnt loading and im not sure whats wrong with it my code looks the same and everything is really the same just wont populate any ideas?

[@SmartHomeJunkie]

I'm sorry, but it's difficult to say because it might be in your specific installation.

[@miguelhurtado3873]

Wow video! thankyou for your time and all the information. I still have a question... du you have to be connected with computer continuously to get that information display in Grafana? I mean I have a Shelly EM and a Shelly1pm continuously connected. Or only display Grafana graphics just what you saved and so on. I like to test the Shelly EM in Grafana dashbord a full month when I returned home, possible? Thanks

[@SmartHomeJunkie]

Home assistant will log the data automatically. You do not have to do anything for this.

[@djjmtimmermans]

Hi, I love your videos. Just installed Influx and Grafana. But I have a different outcome in Influx as you have. At Measurements & Tags I do not see the entities as in shown in your video. I see a list of all possible characteristics. For instance: m2, KM/h, state, steps, Hz, Kwh. Any idea? Thanks

[@SmartHomeJunkie]

Oeh, I'd have to investigate that. It's quite some time ago that I've created this video. Maybe something changed in the meantime.

[@djjmtimmermans]

@@SmartHomeJunkie I will reinstall influx later tonight. Maybe that changes something. Ill let you know

[@SmartHomeJunkie]

@@djjmtimmermans Great. Let me know indeed!

[@StefanWolfrum]

I have the exact same problem. Obviously something changed from back when you made this fine video. Any help much appreciated! 😳

[@SmartHomeJunkie]

@@StefanWolfrum That might be the case. At my side it still works the same though. I must say that I do not use Grafana that much anymore since the Energy Dashboard is available in Home Assistant. I used Grafana mostly for getting insights in energy usage myself.

[@rolandpeeters8332]

Thanx for de Video. I want to group the kwh data from the airco by month. Is it possible to group data in a bar chart by week, month, year. I can't find that.

[@SmartHomeJunkie]

Hi Roland, I think it should be possible. I didn't use Grafana that much lately, so I would have to look into it closer. Will check it.

[@bertvanlit4042]

Very nice and helpfull video. I have a question, does dis not worn out the memory card on a Raspberry Pi. The database from Grafana writes many time and could the memory card worn out

[@SmartHomeJunkie]

I suggest you use an SSD drive instead of an SD card. SD cards always die eventually because of HA.

[@rickz6006]

Do you know of a way to relocate data from one HA install to another? I have over a year of propane tank level information I would like to not loose?

[@SmartHomeJunkie]

I never did this. But backup and restore within HA might work.

[@52_Blue]

Fantastic Tutorial! I've enjoyed this and several other tutorials from you. I am very new to HA, and I appreciate your step-by-step tutorials!! In my case I had some concern about creating a local database inside Home Assistant, since I am running HA on an ODROID N2+ and I worry about the reliability of EMMC memory. I already have a dedicated PC with Influx (+ Grafana) collecting data from a different Hub (Hubitat), and that is working well. So, with the Influx DB add-on in HA I've configured the local address of this PC. I edited my config.yaml file to reflect this domain and port with Influx. However, in the Influx Add-On in HA, while I see "Measurements and Tags" and "Fields", from HA, Influx shows "No Data" for DB Home_Assistant. For my other database, I can see data, so I think my issue is that my HA Influx Add-On is not writing data from HA. (Yes, I've waited a few hours.) Of course, in Grafana ( HA Add-On) can see the tags and fields from HA, but Grafana also reports "No Data." If you can, please point me to some resource where I can learn how to push data from HA to an Influx DB on a different computer on my local network. 😃

[@asulanonim666]

hi. nice video. what's the trick of having the graph refreshed in web card view ? i made some graphs, put in a separate dashboard, tried to set current range to 30 days, but seems that the card is not updating and remains on that first interval i haven chosen. Tried also to remove &from....to...& but have succeeded only in showing without borders with this.

[@SmartHomeJunkie]

Not sure what's going on on your side. You should be able to change the interval and save the dashboard after that. When you save the dashboard you can tick a box to save the time range that you have chosen.

[@horrorsapiens6414]

great tutorial! but the noise your scroll wheel makes is horrid.

[@SmartHomeJunkie]

Whoops. Will work on that.

[@tomokokazumi769]

thank you

[@SmartHomeJunkie]

You're very welcome.

[@eduardoherrera4762]

hello. How can I get a PDF file of some graphic?

[@SmartHomeJunkie]

Not sure if this is HA related.

[@tonyknors672]

Geweldige, duidelijke to the point video alweer ! Heb dit geinstalleerd op 2 verschillende HA machines. Echter ... Ik krijg op geen van beiden bij de homeassistant.autogen de domeinen en entities te zien. Ik zie daar enkel een lijst van "units of measurement" zoals "V", "%", "W", "hPa" .... m.a.w. the unit of measurement van allerlei entiteiten. Logfile geeft geen fouten. Ik kan dus ook geen entitei selecteren ... Enig idee wat er fout is ?

[@SmartHomeJunkie]

Klopt, soms kan je een andere measurement kiezen en daarna de entity. In de video zie je dat bijvoorbeeld vanaf 16:05

[@tonyknors672]

@@SmartHomeJunkie Thanks !!! Btw .. werd er al ooit een goede methode gevonden om de panels in HA te gebruiken wanneer je Nabu Casa gebruikt ? URL issue dus ... Prettig weekend !

[@mijnnet99]

Hoi, dank je voor de instructie. Installatie liep voorspoedig alleen op de een of andere manier krijg ik geen resultaat meer uit de queries. De query definitie wordt goed bevonden maar het resultaat is leeg. Heb je een idee wat ik kan checken om dit op te lossen?

[@mijnnet99]

...issue solved by removing InfluxDB and re-install it in HACS.

[@JoseBerruezo]

Nice video. How to put two graphics in the same panel?

[@SmartHomeJunkie]

By creating two queries in the same panel.

[@JoseBerruezo]

@@SmartHomeJunkie Ok, Thank you.

[@SmartHomeJunkie]

You're welcome!

[@highcel]

Would these be much too resource intensive to run on an old thin client for example (raspberry pi 3 equivalent)

[@SmartHomeJunkie]

That might be the case. I had HA running on a Pi3b before and it was struggling to run smoothly. Not sure if it was because of Grafana though. I had loads of addons running. You can just try it. If it's too resource heavy you can just uninstall it again.

[@sharp0630]

Hi, thank you for this video and for your channel ! Could you please explain how did you set up your Barometer and the Barometer Trend (to get this scale, color, etc) ?

[@sharp0630]

I mnaged to do the barometer thanks to the Field column and thresholds but don't know how to set up the trend...

[@SmartHomeJunkie]

You can do this using the value mappings in the field tab of your barometer panel. For instance: If range is between -100 and -0,00001then show a down-arrow icon in the text field.

[@VERMA0007]

Is it possible to reboot Rpi from home assistant

[@SmartHomeJunkie]

Yes, in the supervisor is an option to reboot the host.

[@merlin_V2]

I'm not geting any data to influx DB. Where can i find debug information? Could it have to do with duckdns and/or https?

[@SmartHomeJunkie]

I am not sure tbh.

[@Gladers.]

Thanks for guide. Do Grafana read all history from InfluxDB? Because when I reinstalled Grafana (but not InfluxDB) I only had the data from when I reinstalled Grafana.. even though InfluxDB had data more days back. Is this how it works?

[@SmartHomeJunkie]

Not sure. Grafana should read all the data in InfluxDB as far as I know.

[@Gladers.]

@@SmartHomeJunkie doesnt seems so. It like it start recording the moment you install it? Because I even remade the database and it behave the same.

[@SmartHomeJunkie]

@@Gladers. Hmmm, that's unfortunate 😢

[@JasperTielen]

Hi, how do I get buienradar outdoor temperature in here. I added buienradar and buienradar sensors and do see the weather on my dashboard though it is not a entity I think because in graphana it does not show up.

[@SmartHomeJunkie]

Hi, Buienradar definately has entities. You can check the entities in Home Assistant and use them in Grafana.

[@kack1000]

Good video! Question, is it possible to add grafana grafs in the lovelace dashboard?

[@SmartHomeJunkie]

Sort off. You can use an for that but it's a suboptimal solution

[@dannygerardi7829]

Is it possible in Influxdb to store only the temperature or energy of sensors ? Now we have a lot of info that we don't use.

[@SmartHomeJunkie]

Yes, you can add an include setting in the configuration.yaml to only include the entities that you need.

[@Designsecrets]

Your videos are great. My issue today is at 6 mins 32, after installing everything, and editing the config file.....then restarting, I don't see domains, I don't see any entities

[@SmartHomeJunkie]

Thank you. It was quite some time ago when I created this video, but I believe that rebooting the host might solve this. It's worth a shot.

[@Designsecrets]

@@SmartHomeJunkie Thank you for the reply. I clicked on log viewer and it says, the selected database does not have a syslog measurement...try changing the selected database or source.

[@SmartHomeJunkie]

@@Designsecrets Sounds like Grafana is pointing to the wrong database. Maybe the address of Influxdb is not correctly set in Grafana? 🤷🏼

[@Designsecrets]

Under the influxdb admin icon is a wrench for the configuration menu.......this was empty, I've tried adding the database details and it now says connected......are you able to write out what your details are, so I can double check I have my config right in influxdb please.

[@Designsecrets]

Just a comment: And this is why home assistant is amazing, yet frustrating for new users at the same time. Something that takes a teacher in a video, 2 seconds to do, doesn't work. (No fault of the teacher), and you end up spending hours trying to fix something that took someone else no time at all. After spending hours / days trying to fix it....you do get that satisfaction of having achieved something. But what a waste of time, when as silly as it sounds, for a new user it should just work.

[@beerkekjoer8642]

thx was lookin for this. can I integrate grafana graphs in lovelace cards or in hadasboard?

[@SmartHomeJunkie]

It's a separate dashboard, so not on a lovelace dashboard. Maybe with an .

[@stephentittel4742]

@@SmartHomeJunkie i used an , and it works

[@SmartHomeJunkie]

@@stephentittel4742 That's just perfect! 🤘🏻

[@ed8widge88]

I am not seeing influxdb on home assistant

[@SmartHomeJunkie]

Do you have advanced mode enabled in your profile. Maybe that's the issue? 🤷🏼

[@michiel2797]

Hi hi dat klinkt Nederlands 😉 en daarmee vroeg ik me af of u bekend bent met iungo?

[@SmartHomeJunkie]

Nope

[@lidbergtech]

Nice tutorial! But please show all of the coding you are making... feels incomplete and even when following it is not working for my Xiaomi products.

[@SmartHomeJunkie]

You can follow the link to the code in the description. For Grafana you have to fiddle with the queries yourself. Everybody has different entities.

[@laurensvanderdrift3412]

433mhz transmitter tutorial voor de volgende keer? haha

[@SmartHomeJunkie]

Nope, er staan al wat andere videos gepland. 😉 Maar, ik zal er eens naar kijken...

[@laurensvanderdrift3412]

@@SmartHomeJunkie oeh ben benieuwd, ga zo door!

[@healeydave]

I have everything setup and I can do the same query as you to see my temperatures in my living room but when I click create new dashboard in Grafana and then click add panel, I end up with a blank working space. No query section, no panel section, its driving me mad. I think I've clicked every possible button and menu to try and get the same screens up as you.

[@SmartHomeJunkie]

Hmmm, that is really weird. What system are you running HA on? Maybe a reboot of HA will help?

[@healeydave]

@@SmartHomeJunkie RPi 4

[@SmartHomeJunkie]

Okay. Not sure what is going on on your side. Never had the issue of a blank screen before. Maybe the log of Grafana can give you a hint.

[@healeydave]

@@SmartHomeJunkie It's Safari, I loaded up Home Assistant in Firefox and everything just popped right up as it should. In Safari, I can do queries in explorer and everything fine but as soon as I try to design dashboards, nothing appears, all I see is the top bar saying "Discard", "Save", "Apply". The graph panel, query panels below that bar and the settings panels on the right of them are all missing in Safari.

[@MaxGoddur]

I am a bit confused. I started out by downloading and installing Grafana and InfluxDB during the sequence of updates 2021.4x if I am correct there was mention of no longer needing to install InfluxDB as there would be DB by default in Home Assistant. Was I correct in this assumption? If I am then will Grafama work with the default DB?

[@SmartHomeJunkie]

I really recommend you to use Influxdb for Grafana because it's made especially for storing large amounts of data and is really efficient for Grafana. The default database is not that efficient.

[@MaxGoddur]

@@SmartHomeJunkie reinstalled Influxdb. Now to search for videos on how to use Influxdb failed when I tried to use it with Grafana.

[@SmartHomeJunkie]

Not sure what you mean, you should be able to get it to work if you follow the instructions in the video.

[@stephentittel4742]

I have 20 entities under OpenWeatherMap. I can't find the entity_id you used for the rain measurement. How come?

[@stephentittel4742]

In your example you used the feed from Buienradar, that's why. Leuke video!

[@SmartHomeJunkie]

Indeed. But it works with Openweathermap too. I am also working on a video to show how you can trigger something based on the total amount of rainfall during the day. Buienradar has better sensors for that, but cannot be used in all countries.

[@andrewelliott7830]

@@SmartHomeJunkie Goed bezig. Ik heb er zin in ;-)

[@SmartHomeJunkie]

You'll get hooked...

[@matejfoltyn]

@@SmartHomeJunkie really looking forward to that one! :)

[@dablet]

can it do stocks? $GME for life baby!!!

[@SmartHomeJunkie]

If you have an integration that provides the stock figures, sure!

[@michaelmolter6180]

Oh Geez, I hope your not actually using 812 kW, lol.

[@SmartHomeJunkie]

Haha, might be a rounding issue here that I didn't look at tbh.

[@binauchich]

U say u will show how will do for Grafana and then must watch one more video and in these video then again some more. Crap

[@PeaJayProduction]

Great tutorial, thank you. I wonder what the use case for the bathroom pressure is :).

[@SmartHomeJunkie]

There's none to be honest 😂