Get last value of trend

[baggins]

Hi,

How do I fetch the last value of a trend?

I have a trend from which I would like periodically  get the last value as shown in the trend graph.

TIA

[Daniel]

Hi
Look here http://openrb.com/docs/trends-new.htm
BR

[baggins]

Hi
Look here  http://openrb.com/docs/trends-new.htm
BR

I did...
I have a test script but I cannot figure out how to get the last value...

Thanks

[Daniel]

Hi
Look here  http://openrb.com/docs/trends-new.htm
BR

I did...
I have a test script but I cannot figure out how to get the last value...

Thanks

In did, I couldn't get anything smaller than daily values.

[admin]

You have to specify correct resolution in seconds, by default it is set to 1 day - 86400 seconds.

[baggins]

You have to specify correct resolution in seconds, by default it is set to 1 day - 86400 seconds.

I'm still confused...
I took the example of the documentation and adapted where necessary:

Code:

123456789

require('trends') dates = { ['start'] = { year = 2018, month = 2, day = 5}, ['end'] = { year = 2018, month = 2, day = 6 }, } --fetch current value day = trends.fetch('CPU load', dates,300) for i, v in ipairs(day) do log(i,v) end

This gives me 4 results. If I compare those results with the data in the trend, they don't match.

Result from script: 0,19, 0,12, 0,28, 0,34
Last 4 results in trend graph: 0,38, 0,33, 0.41, 0.33

I want to obtain the last result (0.33)...
Edit: if I run "day = trends.fetchone('CPU load', dates)" it returns 0.31 when at the same time in the graph is shows 0.1 as the latest value

BR

[buuuudzik]

Here you have what you looking for

Code:

123456789101112131415161718192021222324

require('trends') -- get data for today function returnLastTrendValue(trendName)  dates = {}  dates['start'] = os.date('*t')  dates['start'].day = dates['start'].day - 1  dates['end'] = os.date('*t')  dates['end'].day = dates['end'].day + 1  trends.NaN = '*'  -- fetch previous value  daily = trends.fetch(trendName, dates, 1)  i = #daily  while i > 0 do    if daily[i] ~= '*' then return daily[i] end    i=i-1  end end lastValue = returnLastTrendValue('Your trend name') log(lastValue)

I've tested Trends API some time ago and I've found that to have some data from today you must type not today timestamp but tomorrow and also 1 day before. The last value is the last measured value before midnight e.g. for 5minute resolution 23:55. For taking your maximum resolution you can type instead 86400 only 1. And then you should define undefined value from RRD db and ylou should look from 00:00 to first data which will appear

[baggins]

Haha, I didn't realize it was that easy!    

Thanks a bunch!

BR

[buuuudzik]

Me too