Home Assistant: 10$ WiFi Energy plug meters with ESPhome (Grafana) part - 3

hey guys welcome back to another video in the previous videos in this series we took a look at converting these to year based energy smart metering plugs using esp home to create a native API connection to home assistant and although that works great and I showed you in the last video how you can take a look at some real time graphs and statistics from a thin home assistant I wanted more but I'm actually really interested in is the usage over time and how much that power usage is costing me per device or at least per plug I've plugged in now for this I'm using crow fauna and her fauna is a standalone package in combined with influx TB but this isn't going to be a tutorial about how you install influx to be Orca fauna in your home assistant environment both in flux DB and her fauna are available in haseo add-on store and are made by Frank Frank is another great youtuber who's made a lot of Awesome plugins for home assistance including no tread and he doesn't maybe make the software but he makes the plugins so you can install them with one click so check that out I'll have his youtube channel in the description and you should be able to find tons of guide which explain easily how you can link home assistant to influx to be and how you can unlink core fauna to influx to be and that kevanna can use the data at home assistant sensed influx to be to create beautiful graphs so slight word of warning I'm no expert in her fauna either I'm just gonna show you what I've been able to create relating to these energy metering plugs and a data we get from them ok now that we have that all set up I want to create a few graphs first I want to mount it to a real time energy usage but I also want to see energy usage over time so how many kilowatt hours has a certain device used in X period of time and then third I want to convert that so that it shows how much euros I live in the Netherlands it the device used over that x period of time and preferably I would like X period of time to be a variable so I could set it to a day or a week or a month or whatever I'd like so let's take a look at that to start let's make it graph that shows the real-time power usage over time to start we are going to use energy meters one two three four and five for this one two three are connected to my LED lighting for azar dryer and five is the washing machine this should give you a good impression of how this works to start Enver fana click the little graph plus icon and select choose visualization oh and as a quick note I've just updated my graph on a plug-in version to version six so things might look a little bit different than it did before good now that we have this new graph we need to fill it with data to do that on the left hand side select the three stacked circles called queries there we are going to select our energy meter which home assistant has added to our database the easiest way to do this is by selecting select measurement and choosing for watt or W then select the plus icon to the right of that and select entity ID a you should see a list of all available energy meters or other sensors that register in one if you don't see the watt or W or the entity IDs your a link to influx to B and our home assistant isn't functional yet so I have to check that first now you can see the first part of the graph we want to see is starting to appear the next thing we edit is that we've changed time dollar underscore interval to 10 seconds since our energy meters also sent every 10 seconds then we're going to remove the filled null by clicking on the left side of that box and choosing remove the last thing is to give the measurement name some calling it LED central wiring closet but you can give it any name that's appropriate for your situation next we're going to add the other measurements in the same way we can do this easily by copying the current line and then just changing the wattage meter and the name for that source [Music] once done we hit the Save icon in the top right so we don't lose what we've already made then on the left side we go to the second icon visualization we're going to change a few things to make the graph look a bit nicer the first thing we're going to change is no value we want to change that to connect it so that even when there is no measurement at that time it will show a continuous light then since we are measuring in what we want the graph to also show this to do this we scroll down a little bit to the axis and there we select left Y and change the unit to energy W scrolling down some more we can also make some changes to the legend first we turn on as a table and then to the right then over add values we enable average current and Max minimum works but isn't very useful and total can't be used in this case and that's it first graph is done it save again and then hit the back arrow in the top left corner now we can play around with two date ranges to see how much power was generated by what device and web [Music] [Music] [Music] okay looks cool but now that we have this graph let's make another one one that instead of shows you how much power was used at what time it shows you how much power it was used in total over a period so in kilowatt hours let's do that we start off very similar can create a new visualization graph there we go two queries again and start by adding a sensor in W again or what just like we did last time but now we need to do a bit of math to show what we want to know to do this we start with removing mean and adding the following we go to aggregations and choose integral then we go to transformations and choose cumulative sum and then we do a math division and divided by 3600 to finish off we again remove the fill null and add a name [Music] now we can just add our other energy meters by copying this rule again and selecting the correct energy meters and giving each copy and name [Music] once that is done hit the safe icon again and we go to the visualizations tab and change some parameters over there for left Y we now select what hours as the unit to see the graph correctly we again change the legend options to show as a table and to the right and then for the values we select only current and again another graph is complete and as you can see we can change around the time ranges in the top right and the graph will scale with that so if you wanted to see a few hours a day or a week we can do so using the same graph and it will recalculate each time but let's make this graph a little bit more fancy to make the graph a bit more fancy we go back into the graph and give the graph a name we also enable sorting for the values [Music] in the general overview where you see all your graphs you can also click on the current min max etc that you have listed there and sort those to get a good overview okay well this graph is cool too but what we really all want to know is where we bought these things they costed money are they going to save us money or what is costing us this money so let's make another graph and make it graph money to start off we're going to duplicate our total power used graph and edit that copy first we changed the name [Music] and then we're going to change the math that are used in the formula in the queries part in my case one kilowatt hour of power costs about 25 cents so that is what a 0.25 is in the formula if your power costs a different amount it doesn't matter if it's euro dollar just fill in what it costs for you to buy a kilowatt hour of power [Music] next we need to change the graph to a stacked graph and change the units because it's not kilowatt hour now but euro row in my case it's safe and back out of the graph and there you have it you can now see real time power usage power usage over time and actually how much that power costs at you during that time it was used and as I showed before you can change the date range in the top right to whatever you'd like and it'll show you all these graphs in that time period now if you build this out if if you're stupid enough as me like to buy 18 of these things and I still have the urge to buy more I shouldn't buy more but I want to I want to measure all the things anyway if you look at my situation my graphs you see about 16 of them because I don't have all of them in use yet and well let's take a look so in the last seven days it seems the dryer was the main culprit of costing me all my money it used a whopping three euros which isn't that much but that's still good to know looking at the graphs I have of all these measurements in them they can become a bit messy and I'm sure there's better ways to do this in Gore fana I just don't know about it yet but what you can do is you can select individual pre resources or in this case energy plugs and view those individually or a few of them so that if you have one device that's spiking very big you can actually filter it out and look at the devices you want to see at that time so that's it for this video hopefully you found it informative let me know in the comments as always if you have any questions you're welcome in the comments and if you like my channel maybe subscribe and consider joining our discord server and we always have fun discussions there so you're certainly welcome and then the last video in this series which is probably going to be the last video in this series for a while and we'll take a look at some energy savings eyes being able to realize through the by the insight these plugs provided and also we'll take a look at node-red and show you some animations which might save you quite a lot of well euros dollars energy kilowatt hours whatever overtime and maybe actually have these plugs pay for themselves because well that's the initial goal I guess so thank you for watching and I hope to see you back in the next video [Music] [Applause] [Music]

Channel: Intermit.Tech

Views: 12,489

Rating: 4.9361024 out of 5

Keywords: tuya-convert, blitzwolf, shp-2, gosund, tuya, tuya ota, smartlife ota, flash tuya, convert smart plug, home assistant, how to measure power, how to measure wattage, grafana, grafana dashboard, grafana energy monitor, energy meter, esp8266, cheap, 10$, flash smart switch, over the air, ESPhome, esphomelib, esphomeyaml, WiFi power meter, tasmota, hassio, intermit.tech, firmware, nice graphs, real-time power graphs, energy meter graphs, power meter graphs, power usage

Id: U1D-7efjIyA

Length: 13min 15sec (795 seconds)

Published: Sat Mar 02 2019