If I'm reading your graphs correctly, you don't graph the average temperature at all. You only display it on the 'avg.' column. I specifically need to graph the average over 24 hrs, 1 week, 1 month and 1 year. I have read your 'how to do this' and it has been very useful. Here's a sample image of what I've managed to graph so far:
<a href="http://www.kotikone.fi/pmatil/out_day.png">http://www.kotikone.fi/pmatil/out_day.png</a>. On the picture there is also the gap I mentioned. The average curve is plotted the way I described it on my earlier posts.
<br><br>cheers,<br><br>Petteri<br><br><div><span class="gmail_quote">On 11/21/07, <b class="gmail_sendername">Paul Rimmer</b> <<a href="mailto:paul-rimmer@ronin-tech.com">paul-rimmer@ronin-tech.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
I think I'm doing what you want and I detailed how I set everything up<br>under the 'how to do this' link:<br><br><a href="http://ronin-tech.com/Content/pid=18.html">http://ronin-tech.com/Content/pid=18.html</a>
<br><br>Cheers,<br>Paul<br><br>> I also think I may be confused. So, I am measuring outside temperatures<br>> every 5 minutes and updating the temperatures.rrd every<br>> time. Data is simply 23.56, -1.98 etc.<br>
><br>> temperatures.rrd:<br>><br>> rrdtool create /var/digitemp/temperature.rrd DS:out:GAUGE:600:-50:50<br>> DS:in:GAUGE:600:-50:50 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700<br>> RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:
0.5:288:797 RRA:MIN:0.5:1:600<br>> RRA:MIN:0.5:6:700<br>> RRA:MIN:0.5:24:775 RRA:MIN:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700<br>> RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797<br>><br>> So far graphing average values for the time period represented by each
<br>> pixel<br>> on the graph is ok. What I want is daily, weekly, monthly and yearly<br>> average<br>> temperature graphs. That is, graphing the average temperature for the<br>> period<br>> of the graph (GPRINT:Inside:AVERAGE:"\t%6.2lf °C"). I hope this helps.
<br>><br>> cheers,<br>><br>> Petteri<br>><br>> On 11/21/07, Dan Cech <<a href="mailto:dcech@phpwerx.net">dcech@phpwerx.net</a>> wrote:<br>>><br>>> Petteri Matilainen wrote:<br>>> > On 11/21/07, Simon Hobson <
<a href="mailto:linux@thehobsons.co.uk">linux@thehobsons.co.uk</a>> wrote:<br>>> >> Petteri Matilainen wrote:<br>>> >><br>>> >>> I'm currently graphing daily, weekly, monthly and yearly inside and
<br>>> >>> outside temperatures. The temperature values are fetched from SQL<br>>> >>> database and then put into temperatures.rrd. I have a cron job that<br>>> >>> runs this every 5 minutes. Then I wanted to graph average
<br>>> >>> temperatures too. I didn't think of any other way but to read<br>>> >>> average temps from temperatures.rrd and them into a new rrd,<br>>> >>> averages.rrd. Then I graph
averages.rrd as usual.<br>>> ><br>>> >> Why don't you just graph the averages you already have in<br>>> temperatures.rrd?<br>>> ><br>>> > How? I have<br>>><br>>> On re-reading your post I think you may be confused.
<br>>><br>>> > DEF:Inside=/var/digitemp/temperature.rrd:in:AVERAGE<br>>> > LINE1:Inside#3333CC:"Inside"<br>>><br>>> This line will plot the average temperature for the time period
<br>>> represented by each pixel on your graph.<br>>><br>>> > GPRINT:Inside:AVERAGE:"\t%6.2lf °C" <- this is the average I want to<br>>> > plot which give me the "ordinary" graph. If I have
<br>>><br>>> This figure is a single number representing the average temperature for<br>>> the period of the graph.<br>>><br>>> > VDEF:avg=Inside,AVERAGE<br>>> > LINE1:avg#3333CC:"Average"
<br>>> ><br>>> > I get a straight horizontal line.<br>>><br>>> This is correct. If you plot the average temperature for the graph<br>>> period, you will get a line straight across, because it is the same for
<br>>> the entire graph period.<br>>><br>>> You will probably get more useful feedback if you post some more details<br>>> about the structure of your temperatures.rrd, the data you are<br>>> inserting, and what you are trying to achieve.
<br>>><br>>> Dan<br>>><br>>><br>> _______________________________________________<br>> rrd-users mailing list<br>> <a href="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</a>
<br>> <a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a><br>><br><br><br></blockquote></div><br>