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 ;) Steven Staples > -----Original Message----- > From: Bryan Cantwell [mailto:bcantw...@firescope.com] > 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 > limit > > > 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 > with > > > 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 > charts? > > > 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 > it. > > > 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: jang...@yahoo.com > > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > > > > > 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 > 02:35:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
