Hi all .
I have easy project, make own electronics with sensors (temperature, water sensor, energy ). All this data are stored to spreadsheet .
I have two spreadsheet
1. record all data in all time
2. spreadsheet for last 48 hour .
Here is part of script :
var newRow_48 = sheet_48.getLastRow();
if (newRow_48 > 48) sheet_48.deleteRow(2);
newRow_48 = sheet_48.getLastRow() + 1;
var newRange_48 = sheet_48.getRange(newRow_48, 1, 1, rowData.length);
On first find last row , then if more then 48 , delete row 2 , then append data to last row .
All working perfect , for 100%
I create chart on new sheet ,
I set all what I want , and show me all data what I want .
1. I set range from 1:49
for example A1:A49
but after some time range change from 1:49 to 1:49 , then 1:47 etc ..
not only in A1:A49 , also all other range D1:D49 , S1:S49
what is problem??
I know I reload all data in my last 48 hour spreadsheet .
delete row 2 and then write new data to last row ..
what is problem ..