Simon,<div>I'm still working on the problem of SUM aggregations and have few questions - below<br><br><div class="gmail_quote">On Mon, May 21, 2012 at 12:22 PM, Simon Hobson <span dir="ltr"><<a href="mailto:linux@thehobsons.co.uk" target="_blank">linux@thehobsons.co.uk</a>></span> wrote:</div>
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
(...)
</div>Well I only have four consolidations in my databases - designed to<br>
for for day, week, month, year graphs. Thus it's simple to<br>
pre-caculate the optimum resolution and timespan values for each<br>
graph. I just use a case statement to pick one of four sets of values<br>
and plug them into the graph generation script.<br>
I carefully choose the timespan of the graph so that each pixel on<br>
the graph exactly matches on consolidated data point.<br></blockquote><div><br></div><div>- How do you calculate monthly statistics? That is, how do you deal with months having different numbers of days?</div><div>- Does it mean the rrd file needs to start at the boundary of the largest consolidation period, in your case at the beginning of a year? This way your consolidation period is aligned to calendar and spans exactly a calendar </div>
<div> </div><div>R</div></div></div>