I am not too good with charting (even though I would like to be), but what about getting
the max, min and avg, if the max/min is greater than x% of the avg, show that... ?
Just throwing out ideas... prolly not useful... but may cause a better idea ;)
> -----Original Message-----
> From: Bryan Cantwell [mailto:bcantwell@stripped]
> Sent: August 20, 2010 11:24 AM
> To: mysql
> Subject: Re: Reduce dataset but still show anomalies
> Yes, but I DON'T want eh spikes smoothed out
> On Fri, 2010-08-20 at 17:16 +0200, Jangita wrote:
> > On 20/08/2010 5:12 p, Bryan Cantwell wrote:
> > > I am trying to produce charts for large amounts of data. I already
> > > the user to a smaller time frame in order to reduce the possible data
> > > points, but still can end up with far more data points than are clearly
> > > plottable on a chart. Does anyone have an idea of how I can drop
> > > insignificant points, or average the data or do something to end up
> > > no more than about 3k points and still show spikes and dips in the
> > > charts so my users can still clearly identify anomalies in their
> > > I don't want to smooth out the spikes and dips if at all possible.
> > > I considered running through the dataset and doing a compare of point 2
> > > to point 1 and if it is close in value throw it away, otherwise keep
> > > That probably would not work on a 'noisy' chart however...
> > >
> > >
> > > THanks,
> > > Bryancan
> > >
> > Have you tried instead of showing per minute, show the average per hour,
> > or per day; this will generally smoothen the points out a little; In my
> > case if i show registrations per day i get dips every Saturday and
> > Sunday so it looks all jagged, But per week doesn't show the
> > Saturday/Sunday dips...
> > --
> > Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
> > Skype: jangita | GTalk: jangita.nyagudi@stripped
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.851 / Virus Database: 271.1.1/3023 - Release Date: 08/20/10