Averaging out multiple runs

[tpe]

I have an external script that shows the DB query latency in the last 5 minutes. It's output is like this

count:2875 max:104.2 upper:41.9 average:9.2 lower:3.9 min:0.8

I want to smooth out the graph a bit (right now it's all over the place). I'd like to run this script 5 times and average the output for each field. Is that possible within cacti, or do I need to write it into the script?

[gandalf]

Averaging is automatically done by the consolidation function AVERAGE. Using default rra's this will be seen on the "weekly" graphs. But they consolidate 6 data points to one "consolidated data point" and cover 30 minutes each.
Reinhard

[Grand Master Wierdo]

Perhaps the RRDTool 1.2 Moving Average would do the job? Have a look at:
http://forums.cacti.net/viewtopic.php?p ... ght=#37874

Enjoy

GMW