FYI to hover over any part of the graph and see the displayed data (instead of hovering over each point) Panel > Display > tooltip mode > all Took me a while but I finally found it. That also bugged me before.
Thanks. Over a year ago, I installed Grafana and influxdb and did a partial setup, but never finished. I got caught up with other stuff and other stuff happened. Decided that I need to get back on track and get it going. Removed my installs ans followed your video. I now have it running and will keep at it.
Hey Lewis, really great content. I like the speed you cut the videos to so I can follow along quickly (or pause and rewind a lot!). Appreciate the time you take.
Hi Lewis, honestly? I installed InfluxDB about two months ago and I got stuck on something and I didn’t get back to it it. But thanks to this video I’m going to finish that up now and I’m sure it will take me no time thanks to you. Thanks so much for amazing content!
Thanks! Tonight, I used this and your related video to setup both influxdb and mariadb with 372 day retention. I guess I'll have to use them to watch my free disk space, now ;) I figured out how to embed Grafana graphs directly in a Lovelace dashboard, but tonight I also found the Plotly Graph Card (HACS) which I think I'll love. I've been using the apexcharts-card (HACS) and like it a lot.
@@josebatalha2804 Grafana has a way to get a URL for a graph. I used this. It worked fine but I think would stop displaying (authentication reasons, I think) and IIRC they didn't display in the app or maybe when I wasn't home. So I didn't find them useful and quit using almost immediately. I tend to use ApexCharts for all my charts although I've played with Grafana and Plotly (I think I still have stats so I can view them in Grafana, I just don't).
Thank you for another great video! It will be good if you can cover the positive and negative sides of different installations ways of Home Assistant. For example image on a virtual machine, RPI with Home Assistant Operating System, RPI with Home Assistant Container etc.
I have finally taken the plunge, energy prices and all (and uncontrollable geek traits). Great tutorial once again. Will be interesting to see how my dashboards turn out in a few months. One thing I have done from the start is used the Include parameter so I can control exactly what goes into the db and keep it small. A lot of work initially but probably worth it.
Just FYI influx is now pushing stuff over to 2.x from 1.x version. 2.x will use different querying language and different way to handle databases (buckets and organisations) and using tokens for authentication. I’d look into having a different video about having 2.x as it will be much more future proof.
Click to share the dashboard or the panel and copy the url. Create a webpage widget in your lovelace dashboard and paste in the url. Add &kiosk at the end of the url to remove menus.
Really interesting video, for those people using a pi with an SD Card, is there a way of mounting say, an external HDD/USB HDD or a network share to use for the DB? - or would we have to look to migrating the machine over to a VM/setup with more reliable storage medium?
If you have a Pi with an SD card then I would recommend moving to a cheap SSD that you can use on the USB port, that should help you along a good bit! Hopefully it's a Pi 4 you have
To get the graph cursor working like you want and to avoid making multiple queries for the same measure, set visualisation to graph and then select measurement from domain, group by tag and fill linearly, i.e. FROM default % WHERE domain = sensor SELECT field (value) max () GROUP BY time ($__interval) tag (entity_id) fill (linear) then add $tag_entity_id in the alias box. You may have lots of percentages in the db, so filter the graph of unwanted percentages using the transform tab function "filter by name". Finally use overrides to clean up the legend naming. Voila!
@@EverythingSmartHome I can imagine! The "next level" on top of the inbuilt variables that are auto-generated in the db are the ones you define yourself in the variables tab of the dashboard settings. For example, make a query variable called PercentSelector that does select entity_id, value from "home_assistant"."autogen"."%" This then produces a drop down list at the top of the page that you can incorporate into your queries: SELECT mean("value") FROM "%" WHERE ("domain" = 'sensor' AND "entity_id" =~ /^$PercentSelector$/) AND $timeFilter GROUP BY time($__interval), "entity_id" fill(linear)
Thanks I'll look into it, some good tips! Then we can take it to the even next level and do an Elasticsearch guide 🤣 little bit overkill for this though!
Thanks for this guide. It's very useful. When writing the database, username and password strings in Studio Code Server they appear as red and not as blue like in your video. I'm guessing that's why I'm not getting any data in the explore tab in InfluxDB. I've triple checked spelling. What could be the issue? EDIT: I solved the issue by writing host: localhost instead of the IP adress of my Home Assistant server. Hope someone might find the useful.
I have seen this question on a Node-RED forum post and the answer there was to use iFrames. Not sure whether Home Assistant supports iFrames but that could be an avenue to explore
A way should be selecting "share" from the panel menu, copying the link and pasting it into a web url lovelace tab. What is still unclear to me is how to make graphs visible both from local and external access with the same link. Can you help me on that@@EverythingSmartHome ?
Is this still the best way to do it in 2024? I have Home Assistant in a VM and would like to grab the data and view it in Grafana in a separate docker container, but not quite sure how to do it.
Awesome Video! just missed how on the end when you are on the dashboard and the buttons to change the time periods appear form nowhere.. how did you do that magic?
Help needed: I am looking for dummies instructions how to efficiently downsample the data within the home assistant influxdb to avoid ever increasing data consumption without loosing the long-term data analytics capabilities. Is there anywhere a dummies guide?
I‘ld like to store long term data in influx and more temporarily datas in sqlite or mariadb. There is no way to do so, cause ha just knows record: and store them parallel into both, right?
Hi, great video. Across the top towards the left, there is the icon for grafana next to that moving to the right, from the grafan icon, in your video is HOME but on mine, I see General/Home does that make any difference in the setup procedure?
I found this very useful. It's just a pity the interface of things like Grafana keep changing, making the instruction a little outdated or harder to follow. They have moved some things around in the edit area, but it is still very useful. Now I just have to work out the chron settings so my graphs of daily data re-zero at midnight my time and not GMT!
Great Tutorial ! - @17:05 My panel does not show option to auto select data refresh period. Not sure if they removed this option in my release of Grafana or do I have to do something else to get that option to be availlable?
Great Video, but I am running HA on a Raspberry PI with a SD card which is not ideal for storing this kind of data. Therefore have I installed InfluxDB 2.0 in a docker container on my Synology NAS, but am strugling to get this working. Perhaps you can give guidance on how to connect to an external influxdb 2.0 database as well.
I would like to plot the status and target temperature of a thermostat, but it looks like those entities are not exported to influx. Is there a way to add them? Thanks
i see one problem with influxdb: as i keep putting information into the database, it keeps growing until it fills up the hard disk and crashes the computer. how can i prevent that?
Lewis, I se this upmonths ago but didn't build the dashboards. Trying today but I don't see any of the OS performance counters. Only HA entities. Is there something else that needs to be on>? FWIW, I have the HA Blue Odroid. Thanks for another good walkthrough
Could you please create a video to explain how delete specific entries in Influx DB? After 6 months the DB is now 700mb. I discover now that I can exclude measurements (Using Exclude in configuration yaml), but i don't know how to delete old data. Thanks
Hey there. I'm trying to get this to work but I'm stuck at the 7:52 mark of the video. I don't see any data coming in. I've triple checked the settings and used the IP, localhost, and even the address mentioned in the "Documentation" tab for the add on influx. None seem to work. Any ideas?
log after restart says "Failed to to call / store" and "/store return code 500". It looks like I had a typo in the password for the user, but this error still shows in the log. Data is not coming through.
Awesome videos @Everything Smart Home! Just one question, I just now followed these instructions and it seems as though I dont have any autorefresh options when editing the panel... any tips? I am using Grafana v8.1.2
Looks nice. Is it possible to make a magic mirror using grafana or a similar way? And to display basic things like time, temp and humidity for example and to get some controls like lights switches with a swipe or a double tap?
Thanks Luis! You can 100% use your domain name if you have that configured! Only reason I didn't say to use that here was for people who haven't followed that guide so as not to confused them 😅
@@EverythingSmartHome Using the domain name wasn't populating the influxdb, so I use my IP and now is working. I also change the Home dashboard to the System Monitor, there is an option on Grafana preferences to do this.
Thanks for all the videos! without your help I would still bee looking at a blank home assistant. One thing I would like to do if you could work it in is put the marieaDB and influx DB on a NAS so that I can keep the SSD on my Pi 4 as clean as I can and keep all the data. Could you help out with that?
Really great video👍 When trying to add let's say temperature sensor data the entities from HA shows up as expected what would your advice be to manage this (I have many temp sensors and the entity ID is hard to read which is why I use friendly names in HA Lovelace cards). Would you recommend going back to HA and customize each entity ID to be more userfriendly in Grafana and what would the implications in HA be?
Thanks Carl! I always recommend changing the entity-ids as soon as you get them into HA so it'd a bit of a tricky one! You could change them for sure but be aware that any automations you have will also need their entity IDs changing to match as well as in Lovelace cards.
@@EverythingSmartHome Thanks a lot for your swift response! I was afraid that might be the case but since I'm fairly early on I might just bite the bullet and customize the entity IDs of all sensors to have a solid base to build from.
@@EverythingSmartHome I'm at it right now. I seem to remember that you had recommendations on the naming standard of entities, is that correct? In what video was that? domain.AREA_sensorname_property eg sensor.livingroom_lumi_xxx_humidity or would that potentially put me at a dead end down the road?
Good morning! So I've got Grafana/Influx setup monitoring my UniFi network (using Unifi-Poller in Docker) and wondering if there is a way to create/import a sensor into HA using the data from Grafana/Influx? I've got quite high level stats on everything in my UniFi network and want to get those into HA somehow! At the moment I'm having to use an iFrame with a custom Grafana dashboard on my 'Network' dashboard/panel in HA and it doesn't look or work correctly (if not on the same local network).
Hey Samuel, hmm that's a good question, that's not necessarily the approach I would take to solve the problem but I'm sure there might be a way to do it that way, I'd need to look into it as I'm not sure from the top of my head
I was wondering how you feel about 'flux'.. I really liked the 'querry selecter' like you are using it. But 'Flux' kinda broke this - I hope influxdb will fix this or grafana will come out with an update to integrate better with 'flux' or am I missing something and using it wrong? I would like to see a video about how you are using influx 2.x and your opinion.
I would like to know how to get the influxdb integration if influx will be running on another machine in the network. Would you still install influxdb but just not start it? That way you get the integration? Or can you send data to an external influxdb from home assistant without installing the add-on?
Hey Frank, you would just install influxDB on the machine you want and change the Home Assistant config to point towards the IP address. Hope that helps!
@@EverythingSmartHome right, but can you have an "influxdb" block in the home assistant config without the integration installed? i guess i'm not sure if the integration installs the product and the support to talk to influx, or if it just installs the product and the ability to talk to influx is always there in HASS. Hope that makes sense.
I'm pointing my grafana to my mariadb recorder db and it graphs it just fine. You have to know your SQL though. A wish I have for my InfluxDB is to reduce resolution over time like I had with my RRD-based graphs. Say keep a 5 second dataset for 7 days, a 5 minute dataset for 30 days and an hour dataset for a year. Influx can do this but grafana cannot automatically switch between them when you zoom out etc.
You might consider something like Elasticsearch and Kibana! Man I havent used RRD graphs for a few years now (maybe 5?!) But I do remember that feature 😂
FYI to hover over any part of the graph and see the displayed data (instead of hovering over each point)
Panel > Display > tooltip mode > all
Took me a while but I finally found it. That also bugged me before.
Thanks Taylor, that should definitely be turned on by default, I have no idea why anyone would want the other behaviour!
Thanks. Over a year ago, I installed Grafana and influxdb and did a partial setup, but never finished. I got caught up with other stuff and other stuff happened. Decided that I need to get back on track and get it going. Removed my installs ans followed your video. I now have it running and will keep at it.
Hey Lewis, really great content. I like the speed you cut the videos to so I can follow along quickly (or pause and rewind a lot!). Appreciate the time you take.
Thanks Darren! Glad it's useful and appreciate the support!
Dude! Thank you. This is the best vid on grafana, influx and home assistant on youtube.
Hi Lewis, honestly? I installed InfluxDB about two months ago and I got stuck on something and I didn’t get back to it it. But thanks to this video I’m going to finish that up now and I’m sure it will take me no time thanks to you. Thanks so much for amazing content!
Awesome glad it helped!!
Great video. Used it today to install both products. Thanks for taking the time to create this content.
Great video, thanks.
Would like to see more about the biomass boiler and optimizations mentioned at the beginning...
Thanks appreciate it!
Thank you for the tutorial, so much faster to watch an easy to follow work-through than trying to figure it on my own!
Thank You.. very informative Have watched a few of your other videos too recently and subscribed! Keep up the good work!
Thanks, appreciate it! 🙏
Thanks! Tonight, I used this and your related video to setup both influxdb and mariadb with 372 day retention. I guess I'll have to use them to watch my free disk space, now ;) I figured out how to embed Grafana graphs directly in a Lovelace dashboard, but tonight I also found the Plotly Graph Card (HACS) which I think I'll love. I've been using the apexcharts-card (HACS) and like it a lot.
Hi, Could you please explain how did you do the embeding of Grafana graphs in the lovelace dashbord ?
@@josebatalha2804 Grafana has a way to get a URL for a graph. I used this. It worked fine but I think would stop displaying (authentication reasons, I think) and IIRC they didn't display in the app or maybe when I wasn't home. So I didn't find them useful and quit using almost immediately. I tend to use ApexCharts for all my charts although I've played with Grafana and Plotly (I think I still have stats so I can view them in Grafana, I just don't).
Thank you for another great video!
It will be good if you can cover the positive and negative sides of different installations ways of Home Assistant. For example image on a virtual machine, RPI with Home Assistant Operating System, RPI with Home Assistant Container etc.
Thanks Maksym! I will add it to the list!
@@EverythingSmartHome I wish I knew this. There's so much in HA as a n00b that I have had to learn after the fact.
I have finally taken the plunge, energy prices and all (and uncontrollable geek traits). Great tutorial once again. Will be interesting to see how my dashboards turn out in a few months. One thing I have done from the start is used the Include parameter so I can control exactly what goes into the db and keep it small. A lot of work initially but probably worth it.
Just FYI influx is now pushing stuff over to 2.x from 1.x version. 2.x will use different querying language and different way to handle databases (buckets and organisations) and using tokens for authentication.
I’d look into having a different video about having 2.x as it will be much more future proof.
Thanks for the update, appreciate it!
@@EverythingSmartHome so....
Is there any way to integrate the graphs from grafana into the lovelace ui, ie so they can be displayed amongst the usual home assistant overview?
I'm not sure at the moment but will investigate!
Click to share the dashboard or the panel and copy the url. Create a webpage widget in your lovelace dashboard and paste in the url. Add &kiosk at the end of the url to remove menus.
@@paulbateman3287 Godsend 🙏
Hi and welcome to me testing which chart I like the most
Another great video, now have it fully working. Enjoy your coffee.
Thanks John, glad you found it useful!
Did you notice that CPU stopped recording once you added the alias? I have the same problem and not yet worked out what the problem is…
Very timely. I have been wanting to setup this type of monitoring and dashboards.
Let me know how it goes! 🙏
Hey Lewis. Would you be able to share a link to the video where you show off the biomass boiler controls?
As usual, an understandable and useful Tuesday. Thanks! 👍
Thank you as always for commenting and supporting!
This was a great video. Thanks for putting it together!
Thanks Ronnie!
Really interesting video, for those people using a pi with an SD Card, is there a way of mounting say, an external HDD/USB HDD or a network share to use for the DB? - or would we have to look to migrating the machine over to a VM/setup with more reliable storage medium?
If you have a Pi with an SD card then I would recommend moving to a cheap SSD that you can use on the USB port, that should help you along a good bit! Hopefully it's a Pi 4 you have
@@EverythingSmartHome Great! it is indeed! thanks for the advice! will look into it!
Hi! how can I delete data I not longer need from influx?
Thank you for this! Such a great, clear & concise tutorial.
Thank you Lewis! Great step by step tutorial.
Your welcome!
Informative video as always, end the video knowing more than i did at the start. Starting to enjoy tuesdays :-) Thanks
Thanks appreciate the support and thanks for commenting for the algorithm! 😅
To get the graph cursor working like you want and to avoid making multiple queries for the same measure, set visualisation to graph and then select measurement from domain, group by tag and fill linearly,
i.e. FROM default % WHERE domain = sensor
SELECT field (value) max ()
GROUP BY time ($__interval) tag (entity_id) fill (linear)
then add $tag_entity_id in the alias box. You may have lots of percentages in the db, so filter the graph of unwanted percentages using the transform tab function "filter by name". Finally use overrides to clean up the legend naming. Voila!
Thanks Benedict! This was a difficult transition coming from Elasticsearch, the way things are done are very different so appreciate the pointers!
@@EverythingSmartHome I can imagine! The "next level" on top of the inbuilt variables that are auto-generated in the db are the ones you define yourself in the variables tab of the dashboard settings. For example, make a query variable called PercentSelector that does
select entity_id, value from "home_assistant"."autogen"."%"
This then produces a drop down list at the top of the page that you can incorporate into your queries:
SELECT mean("value") FROM "%" WHERE ("domain" = 'sensor' AND "entity_id" =~ /^$PercentSelector$/) AND $timeFilter GROUP BY time($__interval), "entity_id" fill(linear)
then the "next level" is using variables to do drill downs.... ;-)
Thanks I'll look into it, some good tips!
Then we can take it to the even next level and do an Elasticsearch guide 🤣 little bit overkill for this though!
🤪
Thank you so much!! Your videos are so good an helpful :D
Again a very helpful video! Many thanks ...
Thanks, appreciate the comment!
Thanks for this guide. It's very useful. When writing the database, username and password strings in Studio Code Server they appear as red and not as blue like in your video. I'm guessing that's why I'm not getting any data in the explore tab in InfluxDB. I've triple checked spelling. What could be the issue? EDIT: I solved the issue by writing host: localhost instead of the IP adress of my Home Assistant server. Hope someone might find the useful.
Hi, another great video ! Do you by chance know how can I embed Grafana graphs directly in a Lovelace dashboard ? Cheers
Thanks for the tutorial,
Is it possible to display these graphs at the main HA dashboard?
Thanks for watching! Good question, I'm not sure at the moment but I'll try and get back to you!
@@EverythingSmartHome thanks
I have seen this question on a Node-RED forum post and the answer there was to use iFrames. Not sure whether Home Assistant supports iFrames but that could be an avenue to explore
A way should be selecting "share" from the panel menu, copying the link and pasting it into a web url lovelace tab. What is still unclear to me is how to make graphs visible both from local and external access with the same link. Can you help me on that@@EverythingSmartHome ?
Thanks for the guide, very helpful.
Is there a way of mounting the database to external storage, like a NAS?
Great work! Thanks for the valuable info 😊
Thanks Jamie!!
Is this still the best way to do it in 2024? I have Home Assistant in a VM and would like to grab the data and view it in Grafana in a separate docker container, but not quite sure how to do it.
Excellent video (again), thank you so much!
Thanks!
Hi , I would like to compute the average of the sensor (I.e power consumption kw) but from 8am to 8pm for the last 30 day. How to to do this ?
Great video! Thank you.
Can I do a query to measure how long time a switch was "on"?
Awesome Video! just missed how on the end when you are on the dashboard and the buttons to change the time periods appear form nowhere.. how did you do that magic?
Thanks Paulo! If you click on the dashboard settings button in the too right hand side and then untick "hide time picker" that should help!
Is there a way to select which sensors InfluxDB monitors to keep storage size low?
Great video 👍
If I want to add a new data source, I get the notifications: "origin not allowed" and "unexpected error". Any idea?
Very well explained.
Cheers Steve!
This was excellent, thank you.
Thanks for watching!
Help needed: I am looking for dummies instructions how to efficiently downsample the data within the home assistant influxdb to avoid ever increasing data consumption without loosing the long-term data analytics capabilities.
Is there anywhere a dummies guide?
Loving the videos! Keep it up!
Thanks Taylor! 🙏
Great video Lewis very interesting
Thanks Dale, appreciate the support!
I‘ld like to store long term data in influx and more temporarily datas in sqlite or mariadb. There is no way to do so, cause ha just knows record: and store them parallel into both, right?
Hi, great video. Across the top towards the left, there is the icon for grafana next to that moving to the right, from the grafan icon, in your video is HOME but on mine, I see General/Home does that make any difference in the setup procedure?
I found this very useful. It's just a pity the interface of things like Grafana keep changing, making the instruction a little outdated or harder to follow. They have moved some things around in the edit area, but it is still very useful.
Now I just have to work out the chron settings so my graphs of daily data re-zero at midnight my time and not GMT!
excellent video
easy if you know what you are doing 😊
Thanks!
As always great content!
And as always, thanks for commenting and for the support!
I would like to add that Grafana can use MariaDB as datasource. Data there is different, sure.
nice and clear Thank you very much
Thanks my friend!
Is it possible to change the time range directly from the dashboard? I mean, change the graphics interactively in real time.
Restart. Pro tip. Spent way to long troubleshooting to realize I just needed to restart my core...
Do i need Grafana? Can't HA read the InfluxDB Data ?
How to add glances data to influx and visualize it using grafana?
great tutorial! Thanks!
I don't seem to have access to memory or CPU. Am I missing something?
Great Tutorial ! - @17:05 My panel does not show option to auto select data refresh period. Not sure if they removed this option in my release of Grafana or do I have to do something else to get that option to be availlable?
What kind of hardware configuration do you suggest to run a full power HA with all the features that you explain/will explain in your video?
Great question! It depends if you consider the object detection stuff?
@@EverythingSmartHome yes, the haviest one 😆
Great Video, but I am running HA on a Raspberry PI with a SD card which is not ideal for storing this kind of data. Therefore have I installed InfluxDB 2.0 in a docker container on my Synology NAS, but am strugling to get this working. Perhaps you can give guidance on how to connect to an external influxdb 2.0 database as well.
so awesome!
what do i do if my sensors dont appear in grafana? i have all system monitor entities available in my entities tab and they are enabled
what if i have MariaDB as primary DB (replacing inbuilt DB) , will Influx replace MariaDB as well?
How can I install infuxDB and grafana ?
Many thanks for the video what do you use maria vs influxdb for?
I would like to plot the status and target temperature of a thermostat, but it looks like those entities are not exported to influx. Is there a way to add them? Thanks
i see one problem with influxdb: as i keep putting information into the database, it keeps growing until it fills up the hard disk and crashes the computer. how can i prevent that?
Thank you very useful
Thank you! 🙏
does our database collect all data as of now? how can we make it only connect data from 1 device?
how do I avoid storing sensor data in both MariaDB and InfluxDB
What suggestions would you have for backing up the DB?
use this as your host
a0d7b954-influxdb
would not work for me with the ip of my home assistant. so if ur having failures to connect try this
Lewis, I se this upmonths ago but didn't build the dashboards. Trying today but I don't see any of the OS performance counters. Only HA entities. Is there something else that needs to be on>? FWIW, I have the HA Blue Odroid. Thanks for another good walkthrough
Ótimo vídeo, obrigado por disponibilizar seu conhecimento. Sucesso sempre!
superb! applied ;-)
Thanks!!
Which version of Grafana you used in this video?
Probably version 7. Let me guess, missing the Virtualization option?
Could you please create a video to explain how delete specific entries in Influx DB? After 6 months the DB is now 700mb. I discover now that I can exclude measurements (Using Exclude in configuration yaml), but i don't know how to delete old data. Thanks
I’m getting this error message in my log: ‘HTTPConnectionPool(host=‘a0d7b954-influxdb’, port=8086)
below configuration worked for me:
influxdb:
host: a0d7b954-influxdb
port: 8086
database: homeassistant
username: homeassistant
password: xxxx
max_retries: 3
ssl: false
verify_ssl: false
default_measurement: state
Hey there. I'm trying to get this to work but I'm stuck at the 7:52 mark of the video. I don't see any data coming in. I've triple checked the settings and used the IP, localhost, and even the address mentioned in the "Documentation" tab for the add on influx. None seem to work. Any ideas?
log after restart says "Failed to to call / store" and "/store return code 500". It looks like I had a typo in the password for the user, but this error still shows in the log. Data is not coming through.
Hello again ... I don't use a RasPi for HA (Ubuntu VM) but wondering if you can recommend a piece of software to check the health of a SD card?
Awesome videos @Everything Smart Home! Just one question, I just now followed these instructions and it seems as though I dont have any autorefresh options when editing the panel... any tips? I am using Grafana v8.1.2
ah, in my case, seems that the autorefresh is not in the query, but on the dashboard itself. So guess that answers that one....
24:30 Ans: may be Panel-Display-Tooltip mode-All
Is it going to store a big volume of data? I'm very undecided for what time set the retention policy.
Very dependent on how big your install is but the good thing is you can configure it to store less or more
Looks nice. Is it possible to make a magic mirror using grafana or a similar way? And to display basic things like time, temp and humidity for example and to get some controls like lights switches with a swipe or a double tap?
Thanks! I'm sure it would be possible yes! I haven't done it yet though 😅
@@EverythingSmartHome maybe worth it for your next video
Great video. Why we are using IP in the configuration instead of the single url?
Thanks Luis! You can 100% use your domain name if you have that configured! Only reason I didn't say to use that here was for people who haven't followed that guide so as not to confused them 😅
@@EverythingSmartHome Using the domain name wasn't populating the influxdb, so I use my IP and now is working. I also change the Home dashboard to the System Monitor, there is an option on Grafana preferences to do this.
@@luisabanto7563 are you able to enter your HA locally using IP and have HTTPS for single url? After using HTTPS my local IP address stopped working.
It will work but you'll get a cert error which is normal. Make sure you are using HTTPS when using the IP address
@@tomekhekin914 I use the https for the single url.
Thanks for all the videos! without your help I would still bee looking at a blank home assistant. One thing I would like to do if you could work it in is put the marieaDB and influx DB on a NAS so that I can keep the SSD on my Pi 4 as clean as I can and keep all the data. Could you help out with that?
Thanks Jeff! Will try and add it to the list at some point!
Really great video👍 When trying to add let's say temperature sensor data the entities from HA shows up as expected what would your advice be to manage this (I have many temp sensors and the entity ID is hard to read which is why I use friendly names in HA Lovelace cards). Would you recommend going back to HA and customize each entity ID to be more userfriendly in Grafana and what would the implications in HA be?
Thanks Carl! I always recommend changing the entity-ids as soon as you get them into HA so it'd a bit of a tricky one! You could change them for sure but be aware that any automations you have will also need their entity IDs changing to match as well as in Lovelace cards.
@@EverythingSmartHome Thanks a lot for your swift response! I was afraid that might be the case but since I'm fairly early on I might just bite the bullet and customize the entity IDs of all sensors to have a solid base to build from.
I think that's a good way if you aren't too deep in, it will save you a lot of hassle in the future!
@@EverythingSmartHome I'm at it right now. I seem to remember that you had recommendations on the naming standard of entities, is that correct? In what video was that? domain.AREA_sensorname_property eg sensor.livingroom_lumi_xxx_humidity or would that potentially put me at a dead end down the road?
Thank you for getting me going! :) Wouldn't it be great to be able to add Grafana panels directly into the HA dashboard?
That would be nice, I'm sure a method exists somewhere! 😅
@@EverythingSmartHome been looking, seems like a pain in the butt. Hopefully it'll come sometime 🙂
I need to get in touch ASAP and will be!
Thanks for helping the algorithm as always! 😅
@@EverythingSmartHome hahaha!!! I am not a robot.
Haha appreciate you commenting every video my friend! 🙏
@@EverythingSmartHome credit where its deserved. 👏
@@EverythingSmartHome should have an email 😁
Good morning! So I've got Grafana/Influx setup monitoring my UniFi network (using Unifi-Poller in Docker) and wondering if there is a way to create/import a sensor into HA using the data from Grafana/Influx? I've got quite high level stats on everything in my UniFi network and want to get those into HA somehow! At the moment I'm having to use an iFrame with a custom Grafana dashboard on my 'Network' dashboard/panel in HA and it doesn't look or work correctly (if not on the same local network).
Hey Samuel, hmm that's a good question, that's not necessarily the approach I would take to solve the problem but I'm sure there might be a way to do it that way, I'd need to look into it as I'm not sure from the top of my head
I was wondering how you feel about 'flux'.. I really liked the 'querry selecter' like you are using it. But 'Flux' kinda broke this - I hope influxdb will fix this or grafana will come out with an update to integrate better with 'flux' or am I missing something and using it wrong? I would like to see a video about how you are using influx 2.x and your opinion.
Any update on this
you are good
Thanks, you are awesome!
Sorry for a dumb question, but I don't have InfluxDB nor Grafana in the Add-on Store. How do I add them?
Do you have advanced mode turned on? (Click your user profile in the bottom left and enable advanced mode)
@@EverythingSmartHome Yes, 'Advanced Mode is on.
🎉
Morning!! You said the pi is not ideal for this. What hub would you recommend then? (Hopefully still relatively affordable)
Hey Peter, the Pi is acceptable for this just not with an SD card, a Pi with an SSD should be able to run this fine! Hope that helps
@@EverythingSmartHome thanks for the reply!! Is that what you're using?
No I use a dual Xeon enterprise server, wouldn't recommend that for just this alone 😂
@@EverythingSmartHome haha wow!! Didn't expect that!! What are you using all that horsepower on??
I run a lot of other projects that I dont discuss on this channel such as an Elasticsearch cluster and an NVR but also I use it for TrueNAS too!
I would like to know how to get the influxdb integration if influx will be running on another machine in the network. Would you still install influxdb but just not start it? That way you get the integration? Or can you send data to an external influxdb from home assistant without installing the add-on?
Hey Frank, you would just install influxDB on the machine you want and change the Home Assistant config to point towards the IP address. Hope that helps!
@@EverythingSmartHome right, but can you have an "influxdb" block in the home assistant config without the integration installed? i guess i'm not sure if the integration installs the product and the support to talk to influx, or if it just installs the product and the ability to talk to influx is always there in HASS. Hope that makes sense.
You can yes, they are completely unrelated to each other!
@@EverythingSmartHome fantastic. thanks.
I'm pointing my grafana to my mariadb recorder db and it graphs it just fine. You have to know your SQL though.
A wish I have for my InfluxDB is to reduce resolution over time like I had with my RRD-based graphs. Say keep a 5 second dataset for 7 days, a 5 minute dataset for 30 days and an hour dataset for a year. Influx can do this but grafana cannot automatically switch between them when you zoom out etc.
You might consider something like Elasticsearch and Kibana! Man I havent used RRD graphs for a few years now (maybe 5?!) But I do remember that feature 😂