In the graph above, how can I exclude anything below the red line and get the graph only for anything above the line and so the statistics below (see the yellow highlighted total Wh for the selected period) ?

Is it possible using the graphs section or I have to do it using some other tool ?

Thank you both for the reply, I really appreciate your prompt response!

Well to make the long story short, what I want to achieve is to find “approximately” the consumption of a specific load (let’s say a washing machine, a boiler e.t.c.) for a given period of time in the graph.

@Robert.Wall yes let’s say that in the case I described above, the “static” consumption (those 400W) of my home is just “noise” and I want to get rid of it and get only the additional consumption (and the average of it in KWh).

This looks to work but it creates a problem. If I do that in my current input (Power1) then real time consumption shows 0 (since it’s below the threshold). Can I do it in the Power1+Power2 input and get the result in a separate graph alone ?

I did what you suggested in your initial response and when I saw that the real time power was affected I just removed the processing steps. Should I add them again ?

nothing except the default feeds/input/graphs of the emoncms (I’m not sure what you ask…it’s probably because it’s 2 AM here and my brain is sleeping already )

Guys thank you very much for your replies. You really make a difference in this forum by helping people like me.

Well, solution by @Timbones works better indeed. It gives me all the big loads using historical data as well. To be honest this works better for what I have in my mind to use these data for.

The solution by @Robert.Wall works as well meaning that it filters the big loads but it doesn’t process the historical data.

Now I have a new question which arises by comparing the two solutions.

If you look at the statistics tab you will notice that the same load for the same period of time has different Wh values depending on how I have implement the post-processing. Any clues and which one has the correct value ?

The only thing I can notice immediately by looking at the stats is the quality difference in the measurement.

In the context you have, Quality is meaningless. It refers to the number of data points (not counting NULL values) as a proportion of the possible number plotted across the visible width of the graph.
Notice “the possible number plotted” because the graph algorithm, if there are too many points requested to plot across the width, selects individual points to plot - so if it happens to pick several missing (NULL) values, the Quality is no longer representative of the quality of the original data.

What you need to do to properly compare values is look at the original data in enough detail to be able to manually calculate the energy (Wh) in that spike, then compare it with the number that each method gives you.

Note ‘my’ method includes the base load in the value passed on. To exclude it (as a fixed value - you can’t do any better) you must obviously subtract it (add “+ [value] -500” between “Reset to zero” and “Log to feed”.

I used the Watt Real time Feed which is the default and measures all the loads as reference. Using the zoom in function of the graphs I have isolated the part where I did the measurements. I used as a load a microwave oven which is about 1500W and fired it up for 1 min. So taking the Watt Real Time graph we can see that during this 1 min the difference is 1548 Watts which is very close to the nominal power of the oven.
So we have, 1548 Watts x 0.0167 Hours (1min) = 25.85Wh which looks very close to both yours and @Timbones solution.

But as I said, Tim’s solution serves better my needs as I wanted to know historically the big loads in order to size a PV system which I’m considering as a solution in order to save money from energy bills and provide an alternative power source during grid outages.

Well thank you both for your precious contribution especially you Robert because you have helped me in the past so many times.

Well, If I decide to install the PV I will come back here to ask about integration in the emoncms.

P.S.

One more question to @Timbones , how can I do the same for small loads ?

Have you looked at the histogram feature? Here’s my consumption for today, showing how long was spent (seconds) at each wattage level. Maybe that has the information you’re looking for?

Yep! It’s just fine. Sorry for my obvious ignorance of the functionality of emoncms but I hope this will drastically change in the future especially if I install the PV.