Outside compensation curve

[jerryhenke]

KB doc needs updating. It's possible to fetch data for the given period if start/end is a not a table but a timestamp number.

Fetch data for the last hour:

Code:

date = os.date('*t') -- current date as a table
time = os.time(date, true) -- convert UTC timestamp

-- fetch data for the last hour (3600 seconds)
datarange = {
  ['start'] = time - 3600,
  ['end'] = time,
}

data = trends.fetch('trend name', datarange)
log(data)

Amazing. Now it seems to work. 

I ended up with this script for a damped outdoor temperatur that i later use for my control of floor heating.
Thougts?

Also - do I have to define the resolution of the trend log that I use? Now mine is 5 minutes, but I am also starting a 1 hour-resolution trend log of outside temperature. I imagine less work for LM to calculate the average if I have a table with less values?

require('trends')

-- Function to calculate time range based on hours and days
local function get_time_range(start_hours, start_days, end_hours, end_days)
    local date = os.date('*t') -- current date and time as a table
    local current_time = os.time(date, true) -- convert to UTC timestamp
    local start_time = current_time - (3600 * start_hours + 86400 * start_days) -- calculate start time
    local end_time = current_time - (3600 * end_hours + 86400 * end_days) -- calculate end time

    return {
        ['start'] = start_time,
        ['end'] = end_time
    }
end

-- Define time range (replace the number of hours and days with your values)
local start_hours_back = 0 -- hours back from current time for start time
local start_days_back = 1 -- days back from current time for start time
local end_hours_back = 0 -- hours back from current time for end time
local end_days_back = 0 -- days back from current time for end time
local time_range = get_time_range(start_hours_back, start_days_back, end_hours_back, end_days_back)

-- Specify resolution for 5-minute data (360 seconds)
local resolution = 360

-- Fetch average temperature for the time period with specified resolution
local periodaverage = trends.fetchone('Utetemp', time_range, resolution)

-- Fetch the current temperature from KNX address 0/3/0
local currenttemperature = grp.getvalue('0/3/0') -- Assuming grp.getvalue function is used

if periodaverage and currenttemperature then
    -- Calculate the highest value between the average temperature and the current temperature
    local highesttemperature = math.max(periodaverage, currenttemperature)

    -- Send the highest value to KNX address 5/5/20
    grp.write('5/5/20', highesttemperature)

    -- Log both the average temperature and the temperature sent
    log("Average temperature for selected period: " .. tostring(periodaverage))
    log("Temperature sent to 5/5/20: " .. tostring(highesttemperature))
    log("Current temperature at 0/3/0: " .. tostring(currenttemperature))
else
    log("Could not fetch the average temperature or the current temperature.")
end