Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero

2012-08-03 Thread Derek Haynes
8:13 AM, Alex van den Bogaerdt wrote: > > - Original Message - > From: "Derek Haynes" > To: "Alex van den Bogaerdt" > Cc: > Sent: Wednesday, August 01, 2012 10:54 PM > Subject: Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero > >

Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero

2012-08-02 Thread Alex van den Bogaerdt
- Original Message - From: "Derek Haynes" To: "Alex van den Bogaerdt" Cc: Sent: Wednesday, August 01, 2012 10:54 PM Subject: Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero > Hi Simon/Alex, > >> use a CDEF like b=a,UNKN,0,a,IF >

Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero

2012-08-01 Thread Derek Haynes
Haynes" > To: > Sent: Monday, July 30, 2012 8:54 PM > Subject: [rrd-users] Calculating AVG, treating UNKNOWNs as zero > > >> The AVG consolidation function excludes UNKNOWN values. Instead of >> excluding them, I'd like to convert each UNKNOWN value to zero and >

Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero

2012-07-31 Thread Alex van den Bogaerdt
- Original Message - From: "Derek Haynes" To: Sent: Monday, July 30, 2012 8:54 PM Subject: [rrd-users] Calculating AVG, treating UNKNOWNs as zero > The AVG consolidation function excludes UNKNOWN values. Instead of > excluding them, I'd like to convert each UNKN

Re: [rrd-users] Calculating AVG, treating UNKNOWNs as zero

2012-07-31 Thread Simon Hobson
Derek Haynes wrote: >The AVG consolidation function excludes UNKNOWN values. Instead of >excluding them, I'd like to convert each UNKNOWN value to zero and >then generate the average. use a CDEF like b=a,UNKN,0,a,IF If I've got the syntax right (you'd best check !), that means : Compare a with un

[rrd-users] Calculating AVG, treating UNKNOWNs as zero

2012-07-30 Thread Derek Haynes
The AVG consolidation function excludes UNKNOWN values. Instead of excluding them, I'd like to convert each UNKNOWN value to zero and then generate the average. Example use case: recording visits to a URL, updating once-per minute (but only if any visits), and then calculating the throughput over