[rrd-users] Re: Filling in NaN's?

[Alex van den Bogaerdt]

Adam Rothschild wrote:

> Has anyone written a script to fill in gaps of NaN's in a RRD with
> either the last recorded value, or perhaps something else more
> meaningful and aesthetically pleasing when graphed out?

First of all you need to set proper heartbeat and xff settings.
It is at your discretion how many NaNs may be masked out when
entering the data.

This of course doesn't help you for already processed records.

I see three possible paths:

1) write a script that dumps, edits and restores the database
2) write a program that does similarly, on the raw file
3) patch the old data in your grapher script

(1) and (2) are left as an excersize for the reader, (3) could
be something like:
   CDEF:modified=original,UN,PREV,original,IF
This will check if the original is unknown, if so it will use
the previous value from "modified", else it will use the value
from "original".  This CDEF will not modify a series of unknown
at the beginning of the graph interval but it will work more
like the old MRTG way of handling unknown data.

HTH
-- 
   __________________________________________________________________
 / alex at slot.hollandcasino.nl                  alex at ergens.op.het.net \
| work                                                         private |
| My employer is capable of speaking therefore I speak only for myself |
+----------------------------------------------------------------------+
| Technical questions sent directly to me will be nuked. Use the list. | 
+----------------------------------------------------------------------+
| http://faq.mrtg.org/                                                 |
| http://rrdtool.eu.org  --> tutorial                                  |
+----------------------------------------------------------------------+

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi