I’m still curious if anyone get’s missing entries here and there? I am using a custom DTH. The blank row is where I had a rogue low Power reading I blanked out.
In your HEM DH settings are you using time or change in watts? I was using time but recently switched to watt change, I think that is causing my chart to stop updating as well (just did this in last couple days). Put it back to time based, see if that keeps the chart using all data to last row.
What reporting interval are u using?
I’m using time and always have.
In the HEM Thing I have Power updating every 15 seconds and Energy every 60 seconds.
In the SmartApp that sends to Google Sheets I have it set to send every 5 minutes.
In the smartapp for logging, what do you have for reset the state values?
I have that set to ‘no.’
Is this something you are manually doing each week? Or is there a way to have it always just show the last week/month?
Well, it was working to show only the past week without me changing it. However, in the past week or more Google Sheets has been flaky for me. Even though I have ‘in the past week’ selected, it is showing 1/30 to now 
Maybe you turned filter view off?
@diehllane do you have any tips on keeping the chart to only pull the filter view?
All I can suggest is to make a new tab in the document and output the data using the =filter() function, then make your chart with that data.
I can’t say for sure that will work though.
I have tried turning the filter off and back on a couple times and it still goes back to 1/30 
My notes are at home (working today). I think you can filter the output to a second sheet by select variables.
I know I had it making an automatic copy to a second sheet, and filtering the output to a second sheet by a specific number. I got stuck trying to filter by a specific text value.
I was playing with it several weeks ago so I don’t remember exactly how I was doing it. Was using filter function in 1st box of sheet somehow.
If things slack off at work I might be able to pull it up and look here in a little bit.
1 Like
As an additional note:
As mentioned before if you let your Google sheet get too large. Things will start to glitch. When I was playing with the filter stuff my sheet was in the 30K to 40K range. At times Google would just give up, or take a VERY long time crunching the filter. It wasn’t happy.
That’s where I went in and set my limit in the app lower. I’m going to try and keep lowering it to get close to a week’s worth of data before it does a backup.
Is there a way to specify a specific time interval to log data then perform the backup. Say like every Sunday at 12:00am? I can’t remember?
I was wondering if mine was getting too large; it has about four months of data in it. I just made a copy and deleted out Sept through January. Unfortunately filter still not working I had previously tried use a second sheet to filter. Trying that again… this seems to work, create another sheet (I called it RecentData, and put this in first cell:
=filter(FullData!A:R,FullData!A:A>minus(now(),7))
Adjust FullData!A:R for your sheet and all columns. Adjust 7 for number of days. Then in my chart I just changed the sheet name to RecentData for each range. See how it works for a couple weeks 
1 Like
I know you can also put this in the first cell of a new document and it will automatically copy any entries in your main sheet to a second sheet.
=IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1Xkmg_kdvOCvqSb6xQ2L5qmt77Gz9A-lN-hlWKASlh3fQ/edit?usp=sharing","Sheet1!A:E”)
You will need to change the hook to your sheet by editing url that points to it. You can grab that from the browser. Each sheet has a unique string of characters that identifies it. Which follows the spreadsheets/d/???-??? In your url.
You can also filter data this way but I have not had time to look at my notes. It was flaky and VERY particular to how the function was formatted. I’m off tomorrow and will try to find my notes and share.
Hopefully someone will be able to take what I’ve figured out and help me filter by a text value.
This was my intent also, at first I just made a active copy of my sheet then I applied a filter to it (say temperatures) and the date fix from further up the thread. Then using pivot tables was plotting that data.
I then moved on to trying to import and filter just that data I wanted into a new sheet from the master sheet. I got numerical values to work (I think). I got stuck at text.
I’ll try to get back to it tomorrow. We’ll see what the day brings.
Okay had a few minutes slack time today and figured out these 2 additional ways to move data in Google sheets from your main sheet that is getting the data written by this great app.
This way will grab the data from your main sheet based on the text value between the quotes. Say for example “motion” in column C. It takes a while to gather the data so might throw an error, if you got it right it will after a little bit populate your new sheet with what it found.
=Filter(IMPORTRANGE(ʺhttps://docs.google.com/spreadsheets/d/@@##??OCvvcLoQ2L5qmt77Gz9A-lN-hlWKASlh3fQ/edit?usp=sharingʺ,ʺSheet1!A:Eʺ),(IMPORTRANGE(ʺhttps://docs.google.com/spreadsheets/d/@@##$$%%lN-hlWKASlh3fQʺ,ʺSheet1!C1:Cʺ) =ʺmotionʺ))
This one will filter the data from your main sheet based on the number values reported in Column D. Again it could take a while to gather the data so might throw an error, if you got it right it will after a little bit populate your new sheet with what it found.
=Filter(IMPORTRANGE(ʺhttps://docs.google.com/spreadsheets/d/$$$%%###@@@???cLoQ2L5qmt77Gz9A-lN-hlWKASlh3fQ/edit?usp=sharingʺ,ʺSheet1!A:Eʺ),(IMPORTRANGE(ʺhttps://docs.google.com/spreadsheets/d/???###$$$$%%%%@@@@LoQ2L5qmt77Gz9A-lN-hlWKASlh3fQʺ,ʺSheet1!D1:Dʺ) <90))
Remember if your working with a good sized original sheet Google WILL get LAGGY. You might have to wait a little bit to do edits and adjustments while it is trying to crunch your formula. It also can throw a range error (or something like that) about the cells or something while it’s filtering the data.
Also remember you have to use the url to YOUR sheet in the filter. I have messed the example up.
Also remember the sheet your filtering the data from MUST be shared, this shouldn’t be an issue if your filtering the data from your master sheet the app is using.
These get entered into the first cell of the sheet, in case that wasn’t obvious.
I’m sure there is other ways to manipulate the filter. By doing this you could control the data on a sheet, generate your pivot table and chart off only that data. I haven’t gotten that far. Maybe tomorrow I’ll have time to play a little more. should probably get back to work???
I am soooo sorry I just realized I was putting this information in the wrong thread. I meant it to go to SimpleEventLogger.
I’m just going to leave it hear, It might be helpful for someone else.
I’ll repost it over there.
This seems to be working well the past week, updated first post to recommend this way rather than using the column header to filter.
2 Likes
So my Aeon HEM v2, reports the total kWh used, its a continually increasing value. If i wanted to display the amount of kWh used during a given month, or from Date X to Date Y… how do?? ive been playing around with the EOMONTH function and looking at the filter function, but this stuff is above me. I differ to your greater skill and knowledge.
Thanks,
Scott