Trends average by Schedule (month,year)

[batistacaceres]

Hi,

Is there anyway to trend data excluding some hour of the day?

For example, if in a day I don´t write data in the object at night, I don´t want to include on daily, monthly, yearly... average

In this average, I only want to include data from 7:00 to 20:00.

Thanks

[admin]

Create a virtual object with the same data type as the object you want to log. Then attach an event script to the source object that will write the real value between 7:00 and 19:59, and 0 otherwise. Trend log must be attached to the virtual object.

Event script, change virtual object address (32/1/1) as needed:

Code:

hour = os.date('*t').hour
if hour >= 7 and hour < 20 then
  value = event.getvalue()
else
  value = 0
end

grp.checkupdate('32/1/1', value)