Beautiful Data in Home Assistant with Apex Charts and Built In Graphs

[@PatrickBulteel]

Very cool initial view at the Apex charts. Definitely makes me want to explore them more. I had it set up but didn't think of any good use for them and they were sort of complicated since it was all in yaml. Seeing the different graphs has given me a few ideas to try out. (by the way - you might want to clear out some of the spam)

[@mostlychris]

Thanks! If you are referring to the YT comment spam, I have removed what I see so far. Too bad I have to waste time dealing with that.

[@fibranijevidra]

Fantastic substitution. Thanks for the video.

[@mostlychris]

Yw. Thanks for watching!

[@bat3332]

yet another informative in depth video thank you chris

[@mostlychris]

Thanks and you're welcome!

[@antoniodecrisci2369]

Awesome video showing Apex charts, i'm using it already BUT not as advanced as this! The humidity increases because your fridge is cold compared to the outside temperature so water vapour becomes like dew and condenses inside your fridge. Then you close it, and it stays in there. Try refreshing/ or adding some arm&hammer, it should help with scrubbing the water vapour/humidity.

[@mostlychris]

Interesting. I need to put some absorbent material in there. It gets quite wet as much as the family opens and closes the doors.

[@horstvogel6896]

Where i can found the Code?

[@magnusblomqvist4571]

Great video! I've been looking for something like the Apex-card. I also really like to compare with yesterdays temperature. type: custom:apexcharts-card graph_span: 1d span: start: day header: show: true title: Temperature today & yesterday series: - entity: sensor.outdoor_temperature name: Today - entity: sensor.outdoor_temperature offset: '-1d' name: Yesterday

[@mostlychris]

Excellent! I might add that to mine as well.

[@flyingmtb2874]

where is the code ?

[@c3adkins]

Hey Chris, which sensor(s) are you using to capture your temp/humidity data inside your fridge? Is the device mounted inside or are you just running a probe inside to mitigate signal loss through the walls of a metal box?

[@mostlychris]

In the fridge it was a Xiaomi BLE sensor but I wanted to play around with the Aqara stuff so it is now a tiny little Aqara sensor running to their hub (although it will do Zigbee direct to HA if you have a hub).

[@CarlosRuiz-nx3vm]

Great video! thanks.

[@mostlychris]

Thanks for watching!

[@dretwav]

Can you point me to an example of graphing non time series data. i.e. a basic x,y plot where you define x and y but x is not time. I can do it in node-red but it isn't very pretty.

[@magicker8052]

is there any way to have quick drop down to select time as you can in grafana? eg last 3 day / from sept1 to sept30 etc

[@antoniodecrisci2369]

Also, since you are not using Grafana but rather the direct entity, how do you get history more than say what your default retention time is for your HA database? I know Grafana can take data out from InfuxDB. Can any of these graphing integrations take data out of InfluxDB?

[@mostlychris]

Great question and I don't immediately know the answer. I guess that's a pro for using Grafana with Influx.

[@chrisbklein]

Hello Is there any way to reset the energy database? The values for the price per KwH were not correct. Is it possible to have a fresh start and flush the old database entries?

[@davebareham1075]

Oh Chris - what have you started :) Not sure how I am going to explain this without being able to add screen shots but I have created a 3 entity graph showing (approx) hot water temp, how much solar we are generating and the draw of the solar powered radiator (which only kicks in when the hot water is up to temp). The challenge I now have is that because I have had to use a transform to "play" with the values to get them to show on the same graph the legends don't read correctly (so at the moment solar generation is showing as 10.9 W when it should be 1900w. I'm off to google!

[@mostlychris]

This sounds like a perfect use for putting those screen shots in my Discord server for others to see as well. Good luck with the transform on that solar.

[@sausage5849]

Nice!

[@ThomasLarsen01]

Thanks

[@mostlychris]

No problem

[@Joseph-ko2kl]

You need to flip the option to stop the spammers. Great Vid man thanks I was very curious about the Apex charts! Is it possible to change the wind direction from degrees to cardinal direction?

[@mostlychris]

I guess I came late and didn't see as much spam as everyone else did considering the notes ya'll are leaving about it. I suppose much of it got removed by YT already from other reports. You can probably change the unit using a template or even a transform. I'd have to dig into transform a bit more but it sounds like that is what the feature is for.

[@robertdalga128]

Chris, did u see in the radial chart that all 3 indices had % for the units of measurement (rather than degrees F or C for the outside temp)?

[@mostlychris]

Probably missed that. Thanks for pointing it out.

[@kenneth001976]

I cant seem to find the link to the blog post, with the code?

[@mostlychris]

Apologies. I didn't have it up in time. College football in the US this weekend and we had a family trip. www.mostlychris.com/should-i-use-grafana-still/

[@kenneth001976]

@@mostlychris Thank you for the reply. I always look forward to your videos, to get great inspiration on home automatisation.

[@mostlychris]

Thanks for watching!

[@rickz6006]

Thanks for this, I implemented the apex charts without knowing what I was doing and obviously have not done all I can with them. One question on the HVAC States, are those template sensors? entities: - entity: sensor.downstairs_hvac_state - entity: sensor.upstairs_hvac_state

[@mostlychris]

Yes. - platform: template sensors: upstairs_hvac_state: friendly_name: "Upstairs HVAC State" value_template: "{{ state_attr('climate.upstairs','hvac_action') }}"

[@rickz6006]

@@mostlychris Thanks, I tried just entering the climate.home_1 and got a 3 pen graph. Will play tomorrow.

[@rodrigostamaria]

where's the code?

[@alexsimmons1803]

I just created my first Apex Chart after watching this. Boy was that nearly a HUGE mistake. The system resource use by Apex Charts is ridiculous, rendering Home Assistant all but completely unusable. I was only just able to remove it and get control back. I warn other to try this out in a test environment first. Something is very wrong with this add on. When I search on this problem I found a lot of comments from others having the exact same problem with no resolution. I'm looking into it but be very careful with these charts!

[@j.h.4570]

Same here, when I tried out apexcharts a while back. They gnaw at your system and left my Raspi4/4GB almost unresponsive. But actually I think that in many cases one doesn't really need that much data visualistion anyways and in many cases it's rather done because people think "Hey, I have so much data, now I must use it" ;-)

[@alexsimmons1803]

@@j.h.4570 I'm with you and am all for focusing on what matters and I have some important visualisations for energy management automations I wish to view. Sometimes however you do need to view a lot of different sets of data to work through what matters, and then pare back. My HA is running on a mini PC (way faster/more powerful than an RPi4), but it still ground to a halt. There is clearly some set up code required for charts to ensure they don't ruin your system, but what exactly? When I searched on this issue it seems I am not alone, it's a common problem with these charts but no one was able to articulate why they are complete dogs.

[@RJMaker]

You lost me at YAML... 🙂

[@mostlychris]

Lol. It's really not that scary. It's just a config file if you think of it that way.

[@klaneos666]

I would like to add a ‘go to #### dashboard’ button on or below my apex chart. Is this possible? And what would the code look like?

[@DuckDDD]

ApexCharts installed, but can not create element: "Custom element doesn't exist: apexcharts-card."

[@mostlychris]

Probably a caching issue in the browser. It seems to me that caching is getting more aggressive in some cases and it's hard to flush it. Could just be perception on my part though.

[@j.h.4570]

In most cases deleting the browser cache should help already. But that's actually a quite common phenomenon in HA, play around with cards and you will sooner or later run into this and become an expert on flushing cache ;-)