On 20/08/2010 5:24 p, Bryan Cantwell wrote:
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
Hmm, how do you reduce the number of points and average it out without
smoothing out the spikes? by its nature, the more you average the
smoother the spikes are or? eg
x,y
1,3
2,7
3,15 (spike)
4,4
5,3
6,3
averaged
range(x),y
1-2(1.5), 5 (3+7/2)
3-4(3.5), 9.5
5-6(5.5), 3
We have 3 points instead of 6, but also the u value spike from 7 to 15
has been smoothened from 5 to 9.5
OR, am I missing something? You may want to use another formula instead
of averaging.
--
Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com
Skype: jangita | GTalk: jangita.nyag...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
