NEXT LEVEL STATISTICS - Home Assistant InfluxDB and Grafana

In this video we take a look at Installing InfluxDB and Grafana with Home Assistant, giving you access to next level data logging, statistics and analytics so that you can retain your Home Assistant sensor data for longer, allowing you to do long term visualization and graphing of your data to view trends. We go through how to install InfluxDB and Grafana, the difference between InfluxDB and MariaDB and we also create a couple of basic graphs inside Grafana.

If you'd like to support me and future projects:
Patreon:

Buy Me a Coffee:

Written Article:

EVERYWHERE YOU CAN FIND ME:
Everything Smart Home Community Discord:

#homeassistant #smarthome
________________________

Some of the links above are affiliate links, where I earn a small commission if you click on the link and purchase an item. You are not obligated to do so, but it does help fund these videos in hopes of bringing value to you!

0:00 - Intro
1:06 - Pre-warning
1:24 - What do InfluxDB and Grafana do?
2:56 - Practical application of what you can use it for
3:32 - InfluxDB vs MariaDB
4:52 - InfluxDB Installation and Configuration
8:13 - Grafana Installation and Configuration
10:15 - Using Grafana, creating a systems monitoring dashboard with 4 Graphs.
34:33 - Outro

[Bijstandskoning]

Dude! Thank you. This is the best vid on grafana, influx and home assistant on youtube.

[pavolholes]

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!

[tatersaladfpv]

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.

[Gambriman]

Thank you for the tutorial, so much faster to watch an easy to follow work-through than trying to figure it on my own!

[Dorff_Meister]

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.

[matharu]

Thank You.. very informative Have watched a few of your other videos too recently and subscribed! Keep up the good work!

[JamieVids]

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.

[johndoudar]

Another great video, now have it fully working. Enjoy your coffee.

[danielkrzyzak]

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…

[maheonpieri]

Thank you so much!! Your videos are so good an helpful :D

[WRW]

Hi! how can I delete data I not longer need from influx?

[baldoibs]

Great video! Thank you.
Can I do a query to measure how long time a switch was "on"?

[mateussilva]

Is it possible to change the time range directly from the dashboard? I mean, change the graphics interactively in real time.

[DanieleInaudi]

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

[sandryseibert]

Which version of Grafana you used in this video?

[justincooper]

I don't seem to have access to memory or CPU. Am I missing something?

[praannetwork]

How to add glances data to influx and visualize it using grafana?

[LeivHendrickx]

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

[thepyropc_]

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

[soumynonareverse]

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?