I also think I may be confused. So, I am measuring outside temperatures every 5 minutes and updating the temperatures.rrd every 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 DS:in:GAUGE:600:-50:50 RRA:AVERAGE:
0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MIN:0.5:1:600 RRA:MIN:0.5:6:700 RRA:MIN:0.5:24:775 RRA:MIN:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 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 pixel on the graph is ok. What I want is daily, weekly, monthly and yearly average temperature graphs. That is, graphing the average temperature for the period of the graph (GPRINT:Inside:AVERAGE:"\t%6.2lf °C"). I hope this helps.
<br><br>cheers,<br><br> Petteri<br><br><div><span class="gmail_quote">On 11/21/07, <b class="gmail_sendername">Dan Cech</b> <<a href="mailto:dcech@phpwerx.net">dcech@phpwerx.net</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">
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 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></blockquote>
</div><br>