[prev in list] [next in list] [prev in thread] [next in thread]
List: rrd-users
Subject: [rrd-users] Re: Excluding UNKN or NAN from CDEF
From: sh () abovenet ! de (Stephan Harren)
Date: 2004-09-27 16:03:09
Message-ID: 415839BD.4030303 () abovenet ! de
[Download RAW message or body]
Hi Alex,
yes you're right, but in this case, 1,0,0,unknown will result in 33% as
the calculation is made like:
count all values > -1
add all values
divide counted/added
CDEF:ResponseSum=PREV,UN,0,PREV,IF,Cleaned,+
CDEF:One=Cleaned,-1,GT
CDEF:OneSum=PREV,UN,0,PREV,IF,One,+
CDEF:Uptime=ResponseSum,OneSum,/
which means, when counting, nans are ignored, when adding nans are
ignored so you'll find 1/3. But I hope that this is exactly what Eric
wants to achieve.
Cheers,
Stephan
>AFAIK unknowns are ignored when averaging.
>
>In other words: 1,1,1,unknown,1 will result in 100%, 1,0,0,unknown
>will result in 25%
>
>Easy to check, when you run a script on a database with known content.
>Just build a test-rrd, put some data in it and create some graphs.
>
>HTH
>Alex
>
>
--
Stephan Harren
Head of Engineering
AboveNet Deutschland GmbH
-------------------------
Phone +49 69 90554 153
Fax +49 69 90554 111
Cell +49 173 7011126
--
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic