<div dir="ltr"><div><div><div><div>:)<br></div>my bad (make not for self -- do not calculate epoch dates by hand)<br><br>rrdtool create pymeter-weekdata.rrd \<br> --start 1419184800 \<br> --step 604800 \<br> DS:qtotal:COUNTER:907200:0:100000 \<br> RRA:AVERAGE:0.5:1: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></div>still not the expected numbers...<br><br></div>Please explain how I convert the above example to an hourly database without recalculating the values <br><br></div>JJ<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 4, 2015 at 10:50 PM, 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">I guess the problem may have to do with the fact that your time stamps are not a whole multiple of your step size.<br>
<br>
Not as a solution, but as a means to investigate the problem: try to populate an RRD with a step size of an hour, and plenty of room in a couple of RRAs. See if your data makes it into the database and is as expected.<br>
<br>
----- Original Message ----- From: "_ JvG _" <<a href="mailto:jj@knowzone.org" target="_blank">jj@knowzone.org</a>><br>
To: <<a href="mailto:rrd-users@lists.oetiker.ch" target="_blank">rrd-users@lists.oetiker.ch</a>><br>
Sent: Monday, May 04, 2015 4:24 PM<br>
Subject: [rrd-users] Strange issue with large step value<div><div class="h5"><br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I'm trying to import some old data (collected once every week at 19.00 hour<br>
on Sunday)<br>
<br>
This is what I did:<br>
<br>
rrdtool create pymeter-weekdata.rrd \<br>
--start 1419184800 \<br>
--step 604800 \<br>
DS:qtotal:COUNTER:907200:0:100000 \<br>
RRA:AVERAGE:0.5:1:53<br>
<br>
rrdtool update pymeter-weekdata.rrd 1419789600:50628<br>
rrdtool update pymeter-weekdata.rrd 1420398000:50803<br>
rrdtool update pymeter-weekdata.rrd 1421002800:50959<br>
rrdtool update pymeter-weekdata.rrd 1421607600: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>
and I get this:<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.6573076923e+00</v></row><br>
<row><t>1421280000</t><v>1.5829166667e+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>
while I would expect these results:<br>
<br>
508.03 - 506.28 = 1,75<br>
<a href="tel:509.59%20-%20508.03" value="+15095950803" target="_blank">509.59 - 508.03</a> = 1.56<br>
511.20 - 509.59 = 1.61<br>
<br>
What did I do wrong or what do I need to correct to get the expected<br>
results?<br>
<br>
JJ<br>
<br>
--<br>
<br>
</blockquote>
<br>
<br></div></div>
--------------------------------------------------------------------------------<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
_______________________________________________<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>
<br>
</blockquote>
<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>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><div>_ JvG _<br></div></div></div></div>
</div>