Trend Logs (Max, Min Average)

[sjfp]

Hi, is it possible to get the Max, Min and Average values ( all stored data) from each trend name so that they can be added to vis.
Trend Logs
1) Power DB1 : max 2/3/10 min 2/4/10 average 2/5/10
2) Power DB2 : max 3/3/10 min 3/4/10 average 3/5/10
3) Power DB3 : max 4/3/10 min 4/4/10 average 4/5/10
4) Lighting DB1 : max 5/3/10 min 5/4/10 average 5/5/10

[admin]

This example will calculate min/max/average for the past year data. Keep in mind that this is rather CPU and memory intensive calculation so it's not recommended to run it too often.

Code:

12345678910111213141516171819202122232425

require('trends') trends.NaN = 0 / 0 dates = {} dates['start'] = os.date('*t') dates['start'].year = dates['start'].year - 1 dates['end'] = os.date('*t') values = trends.fetch('TREND_NAME_HERE', dates) min, max, sum, cnt = math.huge, -math.huge, 0, 0 for _, value in ipairs(values) do   if value == value then     min = math.min(min, value)     max = math.max(max, value)     sum = sum + value     cnt = cnt + 1   end end avg = sum / math.max(1, cnt) log(min, max, avg)

[sjfp]

This example will calculate min/max/average for the past year data. Keep in mind that this is rather CPU and memory intensive calculation so it's not recommended to run it too often.

Code:

12345678910111213141516171819202122232425

require('trends') trends.NaN = 0 / 0 dates = {} dates['start'] = os.date('*t') dates['start'].year = dates['start'].year - 1 dates['end'] = os.date('*t') values = trends.fetch('TREND_NAME_HERE', dates) min, max, sum, cnt = math.huge, -math.huge, 0, 0 for _, value in ipairs(values) do   if value == value then     min = math.min(min, value)     max = math.max(max, value)     sum = sum + value     cnt = cnt + 1   end end avg = sum / math.max(1, cnt) log(min, max, avg)

Thank you once again.