<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span>Chris,</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span>You're probably talking to yourself; but I'll reply anyway. :-)</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica,
sans-serif; background-color: transparent; font-style: normal;">In order to get the 'first' you have to read all the data in ... there's no function for it. Think of it this way, it's a round robin database, so let's pretend you have a 3 month RRA. What's the first record? If you've been writing for 4 months; the oldest is 3 months ago, if you've been writing for 1 month it would be 1 month ago. RRD doesn't keep track of that, it keeps track of offsets into the RRA for efficient updates/reads. It's not a useful feature for it to keep track of a 'first' since most RRDs will exist longer than a true first.</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span style="background-color: transparent;"><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color:
transparent; font-style: normal;"><span style="background-color: transparent;">I've never heard of anyone wanting a view like you describe, most data views are expected to be fixed time-spans so each is visually(or xported) comparable to </span><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;">Since it would be inefficient even on your part to scan the set for the 'supposed first' my suggestion is you have a database ( or simple flat file ) keep track of when you created the datafile and always use that. It'll look weird (blank) on your graphs as the RRA ages past the point of it rolling over ( round robin ) but you would get your feature.</div><div style="color: rgb(0, 0, 0);
font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;">HTH,</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;">-Ryan</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: arial, helvetica, sans-serif; background-color: transparent; font-style: normal;"><br></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Chris Mason <chris@netnix.org><br> <b><span style="font-weight: bold;">To:</span></b>
"rrd-users@lists.oetiker.ch" <rrd-users@lists.oetiker.ch> <br> <b><span style="font-weight: bold;">Sent:</span></b> Monday, July 1, 2013 3:27 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [rrd-users] Time Shift on Trend Graph<br> </font> </div> <div class="y_msg_container"><br><div id="yiv2423668938"><div dir="ltr">Hi,<div><br></div><div style="">I am assuming "rrdtool last" returns the actual last time because when you add new data to the RRD, it rotates the RRD and the stuff that was previously at the beginning interval is pushed out - to always maintain the same length and size of an RRD - you are always adding to the end?</div>
<div style=""><br></div><div style="">I am starting to conclude, after getting the feeling that I am talking to myself, that I can't obtain the point in my RRD when I first entered data? Would it not be the first non-unknown value in the data source and can I obtain this easily to use this to determine the start time of my graph?</div>
<div style=""><br></div><div style="">Thanks,</div><div style="">Chris</div><div style=""><br></div><div style=""><br></div><div style=""><br></div></div><div class="yiv2423668938gmail_extra"><br><br><div class="yiv2423668938gmail_quote">On 28 June 2013 14:45, Chris Mason <span dir="ltr"><<a rel="nofollow" ymailto="mailto:chris@netnix.org" target="_blank" href="mailto:chris@netnix.org">chris@netnix.org</a>></span> wrote:<br>
<blockquote class="yiv2423668938gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">Hi,<div><br></div><div>I have been through the documentation and I can't seem to find a way for the graph to grow from the left instead of the right.</div>
<div>So, I thought I might try and do it manually by fetching the "first" entry from the rrd - similar to the "last" function.</div>
<div><br></div><div>However, as I should have expected, although last returns the last input into the rrd, first is returning the first entry for the RRA, not the first time that I inserted data.</div><div>
<br></div><div>Is there any way to determine the first time I inserted data into the RRA as opposed to the start of the RRA period?</div><div><br></div><div>Thanks,</div><div>Chris</div></div><div class="yiv2423668938HOEnZb"><div class="yiv2423668938h5">
<div class="yiv2423668938gmail_extra">
<br><br><div class="yiv2423668938gmail_quote">On 25 June 2013 16:05, Chris Mason <span dir="ltr"><<a rel="nofollow" ymailto="mailto:chris@netnix.org" target="_blank" href="mailto:chris@netnix.org">chris@netnix.org</a>></span> wrote:<br><blockquote class="yiv2423668938gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div dir="ltr">Hi,<div><div><br></div><div>I suppose the other option, if I am unable to achieve what I wanted, is to only draw the trend line from the start of the actual data.</div><div>I use the following logic to draw a trend line for data source "DS1":</div>
<div><br></div><div><div>VDEF:DS1Slope=DS1,LSLSLOPE</div><div>VDEF:DS1Int=DS1,LSLINT</div><div>CDEF:DS1Trend=DS1,POP,COUNT,DS1Slope,*,DS1Int,+,0,INF,LIMIT<br></div><div>LINE1:DS1Trend#808080::dashes';<br></div>
<div><br></div><div>Is it possible to restrict the trend line to start when my data started instead of at the beginning of the graph?</div><div>I would assume that any value within DS1 that was before my data would be classified as unknown - is my DS1Trend CDEF removing the unknowns?</div>
<div><br></div></div><div class="yiv2423668938gmail_extra">Thanks,</div><div class="yiv2423668938gmail_extra">Chris<div><div><br><br><div class="yiv2423668938gmail_quote">On 23 June 2013 13:17, Chris Mason <span dir="ltr"><<a rel="nofollow" ymailto="mailto:chris@netnix.org" target="_blank" href="mailto:chris@netnix.org">chris@netnix.org</a>></span> wrote:<br>
<blockquote class="yiv2423668938gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">Hi,<div><br></div><div>I have the following graph which displays daily maximums over a period of a year:</div>
<div><br></div><div><a rel="nofollow" target="_blank" href="http://netnix.org/graph.png">http://netnix.org/graph.png</a><br>
</div><div><br></div><div>I have added a trend line to the graph using the Least Square Lines method. I am currently shifting the graph by 3 months using the following method:</div><div><br></div><div>
<div>-s -1y+3months -e now+3months</div></div><div><br></div><div>This works fine, but I wanted to try and shift the graph so the start of the graph is at the left most point and the graph is only ever displayed in the first 9 month period. It is easy if I only ever had more than 9 months worth of data, but if I only had 3 months worth of data, then I am looking for the graph to still start from the left with only the left 3 months being used?</div>
<div><br></div><div><div>I am looking to try and do something similar to the "Filesystem Utilization and Predicted Trends" graph in the RRDTOOL gallery where in the picture, the graph is using the left hand side and the trends go into the right hand side.</div>
<div><br></div><div>Any pointers?</div><div><br></div><div>Thanks,</div><div>Chris</div></div></div>
</blockquote></div><br></div></div></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div><br>_______________________________________________<br>rrd-users mailing list<br><a ymailto="mailto:rrd-users@lists.oetiker.ch" 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" target="_blank">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a><br><br><br></div> </div> </div> </div></body></html>