Hello, i have a sensor called “sensor.pzem_powermeter_watt” that measurse the power draw from the grid every second. This results in the database getting bigger and bigger. I don’t need to keep the data measured every second but I would like to keep record every 2-3 minutes. Is it possible to do so on the database?
So now I have 60 records every minute, is it possible to create a script and edit the database to keep only 1 record per minute of the old data?