Average of values

[Villain]

One thing I would like to see is an average of the values reported by Zabbix. For example, I would like to know what the average processor load on a server was last monday from noon to 4:00 pm.

Or, I would like an average of the amount of traffic through my routers/switches/etc. during a specified time.

Is something like this possible in Zabbix? If not, is this something that can be added to a features request list?

Thanks.

[Villain]

Since I hadn't seen anything on this, I wanted to bump it back towards the front page.

Does the feature I'm thinking of make sense? If not, what kind of graphing options would be available.

My ideal graph would be one where I don't see all the individual spikes. Instead, I see an average of the entire timespan in one line. I don't need to know that when process abc.exe started that the processor spiked for a milisecond. However, I do need to know that on average from 3:30pm to 5:30pm, I have a higher load.

Is there a way to do this now? If so, how would I accomplish it?

Thanks.

[nelsonab]

I could see this being potentially processor intensive for delta per second items as you might have to iterate through a list of items in a time period and add up the total time delta in that query. Would it be faster if it were added as a stored procedure in MySQL? However would it be easier to generate an average from using trend data? What is the granularity for the trend data? Hour, 1/2 hour?

[Villain]

hard to say what the granularity would be. Depending on what type of data we're looking at, this could be down to the second. Take an average of processor load, which tends to not last very long, and you would want an average of seconds or at most a minute.

However, some items, you might only want a granularity of an hour or even a half hour. It all depends on the data you're looking to collect, I guess.