Get last 20 minutes average value of object

[idhe]

Hi,

I would like to make a script to get the last 20 minutes average value of the solar brightness, I don't know if it is possible and how to do it.
 thinks it's possbile by getting the database datas but i don't know

If someone have the solution it will be helpfull  

Thanks,

[Daniel]

Log object you want the average from and use this script

Code:

logaddress = '1/2/0'
pastTime   = 1200  --in seconds


addr = grp.find(logaddress)
time= os.time() - pastTime

objects = db:getall('SELECT dataraw, logtime, datahex FROM objectlog WHERE address =' .. addr.id .. ' AND logtime >'.. time )

local result, count, value = 0, 0

    for _, objvalue in ipairs(objects) do
  value = busdatatype.decode(objvalue.datahex, addr.datatype)
      result = result + value
    count = count + 1
    end


  if count > 0 then
    result = math.floor(result / count + 0.5)
      log(result)
  end

Just make sure not to log too many objects as oldest logs are deleted periodically.

[idhe]

Thank you Daniel !

It's look like it doesn't return the average...

My object's datatype is a 2 byte floating point.

any idea ?

[Daniel]

I updated the script to work with 2 byte float, You have to write value to the object after you start to log it.

[Odd Egil Aasheim]

I updated the script to work with 2 byte float, You have to write value to the object after you start to log it.

I've tried to make this script to calculate average within the current hour, but is unable to make it work.

Have tried to substitute  time= os.time() - pastTime  with  time= os.time() - os.time("%H") and a couple of other formats
but get the following error 
User script:5: bad argument #1 to 'time' (table expected, got string)
stack traceback:
[C]: in function 'time'
User script:5: in main chunk

Also tried to use a GA as a local reference for this where the value at is updated at every new hour.

How can it calculate values from say when time is 22:48, back towards 22:00

[Daniel]

I would just calculate how many seconds are in current hour and use it for pastTime like this

Code:

now = os.date('*t')
pastTime = now.min*60 +now.sec

[Odd Egil Aasheim]

I would just calculate how many seconds are in current hour and use it for pastTime like this

Code:

now = os.date('*t')
pastTime = now.min*60 +now.sec

That seems to be doing what I wanted, I only had to speed up polling rate to get more accurate values.
Thanks again Daniel