<div dir="ltr"><div>I did what you asked:<br><br>rrdtool create pymeter-weekdata.rrd \<br> --start 1419184800 \<br> --step 3600 \<br> DS:qtotal:COUNTER:604800:0:100000 \<br> RRA:AVERAGE:0.5:1:8904 \<br> RRA:AVERAGE:0.5:168:53<br><br>rrdtool update pymeter-weekdata.rrd 1419789600:50628<br>rrdtool update pymeter-weekdata.rrd 1420394400:50803<br>rrdtool update pymeter-weekdata.rrd 1420999200:50959<br>rrdtool update pymeter-weekdata.rrd 1421604000:51120<br><br>rrdtool xport \<br> --start 1419184800 \<br> --end 1425236400 \<br> --step 604800 \<br> DEF:Qtotal=pymeter-weekdata.rrd:qtotal:AVERAGE \<br> CDEF:QTot=Qtotal,604800,*,100,/ \<br> XPORT:QTot:"Usage\n"<br><br><?xml version="1.0" encoding="ISO-8859-1"?><br><br><xport><br> <meta><br> <start>1419465600</start><br> <step>604800</step><br> <end>1419465600</end><br> <rows>11</rows><br> <columns>1</columns><br> <legend><br> <entry>Usage\n</entry><br> </legend><br> </meta><br> <data><br> <row><t>1419465600</t><v>NaN</v></row><br> <row><t>1420070400</t><v>NaN</v></row><br> <row><t>1420675200</t><v>1.6617857143e+00</v></row><br> <row><t>1421280000</t><v>1.5832142857e+00</v></row><br> <row><t>1421884800</t><v>NaN</v></row><br> <row><t>1422489600</t><v>NaN</v></row><br> <row><t>1423094400</t><v>NaN</v></row><br> <row><t>1423699200</t><v>NaN</v></row><br> <row><t>1424304000</t><v>NaN</v></row><br> <row><t>1424908800</t><v>NaN</v></row><br> <row><t>1425513600</t><v>NaN</v></row><br> </data><br></xport><br><br><br></div><div>the data in the new table is even more off...<br><br><br> <row><t>1419804000</t><v>1.0416666667e-02</v></row><br> <row><t>1420380000</t><v>1.0416666667e-02</v></row><br>.<br>.<br>.<br> <row><t>1420398000</t><v>1.0190476190e-02</v></row><br> <row><t>1420416000</t><v>9.2857142857e-03</v></row><br>.<br>.<br>.<br> <row><t>1420992000</t><v>9.2857142857e-03</v></row><br> <row><t>1421010000</t><v>9.4642857143e-03</v></row><br> <row><t>1421028000</t><v>9.5833333333e-03</v></row><br>.<br>.<br>.<br> <row><t>1421604000</t><v>9.5833333333e-03</v></row><br><br></div><div><br></div><div>Ans the problem is still there.<br></div><div>I've did some more tests with different heartbeats with the same results.<br></div><div></div><div>I do not get your remark that my input is wrong...<br><br></div><div>Please help<br></div><div><br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, May 5, 2015 at 7:51 AM, Alex van den Bogaerdt <span dir="ltr"><<a href="mailto:alex@vandenbogaerdt.nl" target="_blank">alex@vandenbogaerdt.nl</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Please explain how I convert the above example to an hourly database<br>
without recalculating the values<br>
</blockquote>
<br></span>
Create a new database to test, investigate and learn.<br>
<br>
The step size should be divided by 168 (and then becomes 3600), the amount of rows should be multiplied by 168 (to store the same amount of time), and then feed the same data (rrdtool will update more than one row at a time, no problem).<br>
<br>
--step 3600<br>
RRA:AVERAGE:0.5:1:8904<br>
<br>
Now use "rrdtool dump" and open the resulting file with a text editor to get an idea what is inside this database.<br>
<br>
Repeat the excercise, now with two RRAs:<br>
<br>
--step 3600<br>
RRA:AVERAGE:0.5:1:8904<br>
RRA:AVERAGE:0.5:168:53<br>
<br>
This second RRA should be very much the same as what you get now: one entry for every week, 53 times.<br>
<br>
Depending on the results you can test further. Still no data? Perhaps there's something wrong with your heartbeat settings, or your min/max settings. Data, but not what you expect? Then the input is not what you expect.<br>
<br>
After looking at this, do your "rrdtool xport" again and compare against the "rrdtool dump" results. Does it do what you think it should do.<div class="HOEnZb"><div class="h5"><br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
rrd-users mailing list<br>
<a href="mailto:rrd-users@lists.oetiker.ch" target="_blank">rrd-users@lists.oetiker.ch</a><br>
<a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users" target="_blank">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><div>_ JvG _<br></div></div></div></div>
</div>