[rrd-users] How to graph sparse data

[Dr. X]

I'm trying to graph the time something takes to run,
in whole seconds, and when it runs. It may only run a few
times per day or could possibly run every second.

I would like a graph showing the time to run, in this
case it's just 1 second, or it didn't run at all, and 
because there's a spike it'd also show me when it ran.

I just grab finished_time and finished_time -
start_time out of a database, and want to graph that
data.

I've tried filling in the data, for the missing
seconds, with 0 and have also tried graphing it with the
NaN values, using CDEF:undef=secs,UN,0,secs,IF LINE2
... I either get a flat line at 0 or, using a subset of the
date listed below, nothing at all.

So what am I missing?  How do you graph something that
has sparse data?

Thanks

Example follows..
------------

rrdtool create NEW.rrd \
--start 1067443799 \
--step 1 \
DS:secs:GAUGE:1:U:U \
RRA:AVERAGE:0.5:1:86400 \
RRA:AVERAGE:0.5:3600:168 \
RRA:MAX:0.5:1:86400 \
RRA:MAX:0.5:3600:168

rrdtool update NEW.rrd \
1067443812:1 \
1067447027:1 \
1067449357:1 \
1067449366:1 \
1067449375:1 \
1067449384:1 \
1067449393:1 \
1067449402:1 \
1067449411:1 \
1067449420:1 \
1067449429:1 \
1067449438:1 \
1067449447:1 \
1067449456:1 \
1067449465:1 \
1067449474:1 \
1067449483:1 \
1067449492:1 \
1067449501:1

rrdtool graph NEW.gif \
        --start 1067443800 \
        --end 1067449500 \
        --title "Time To Run" \
        DEF:secs=NEW.rrd:secs:AVERAGE \
        LINE1:secs#FF0000:Seconds \
        GPRINT:secs:MAX:"Max %3.1lf"

__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/

--
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