Those initial values are not ignored and are used in the least squares calculation. The problem is that all the data is taken into consideration, the initial few values near zero and the final values near 3000. To get to the 3000 the slope is great enough that the line needs to start in the basement. You can put the limit back on and it will stop at zero. Unless your slope is zero every line will eventually have a negative y. When your trend is "downhill" you will have a negative slope and the values will go negative at some point in the future. Bogus data, such as when you first start monitoring, can also skew your trend. There are graphs that show the same trend line but common sense will tell you LSL is only accurate on the first. [http://reference.wolfram.com/applications/eda/NBMLImages/FittingDataToLinearModelsByLeast-SquaresTechniques/FittingDataToLinearModelsByLeast-SquaresTechniques_54.gif] FYI with your date range you are using in the graph of 30 days on graph 1900 pixels large I'm guessing the step used in your calculations is more like 1 hour.
As your data looks like it is in flux right now. I would change your date range to trend only the last 48 hours and you will get a much different trend line. On some of my graphs I use three trend lines that are hardcoded for immediate (1 day), longer (2 days), and even longer (a week) and they rarely agree. The link below shows how to hardcode this. http://hints.jeb.be/2009/12/04/trend-prediction-with-rrdtool/ BTW, if this is a WAN port shouldn't the label be megabits/sec or some other rate and not total megabytes. The graph below you can see that the bogus data from last week is skewing the trend down [cid:image001.png@01D0D527.06260460] The one week trend here is bogus due to an equipment change. From: Ondrej [via RRD Mailinglists] [mailto:ml-node+s937164n7583085...@n2.nabble.com] Sent: Wednesday, August 12, 2015 3:52 PM To: Robert C. Seiwert <r...@vcaglobal.com> Subject: [GRAYMAIL] RE: RE: Question about trend line OK, this is clear how LSL should work, but since graph very beginning there as positive values (i double checked now using rrd dump) and there are never any negative values, so i'd still assume LSL will take these first two days into consideration. Now it looks to me that there are just ignored. In other words between 4-6 of august there are 5 minutes step always positive values. ________________________________ If you reply to this email, your message will be added to the discussion below: http://rrd-mailinglists.937164.n2.nabble.com/Question-about-trend-line-tp7583077p7583085.html To start a new topic under RRDtool Users Mailinglist, email ml-node+s937164n937053...@n2.nabble.com<mailto:ml-node+s937164n937053...@n2.nabble.com> To unsubscribe from RRD Mailinglists, click here<http://rrd-mailinglists.937164.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=937164&code=cm9iQHZjYWdsb2JhbC5jb218OTM3MTY0fC0yMTE0MzU4MzIz>. NAML<http://rrd-mailinglists.937164.n2.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> image001.png (166K) <http://rrd-mailinglists.937164.n2.nabble.com/attachment/7583086/0/image001.png> image002.gif (2K) <http://rrd-mailinglists.937164.n2.nabble.com/attachment/7583086/1/image002.gif> -- View this message in context: http://rrd-mailinglists.937164.n2.nabble.com/Question-about-trend-line-tp7583077p7583086.html Sent from the RRDtool Users Mailinglist mailing list archive at Nabble.com. _______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
