Hi,
I am in need of graphing my database.
My data looks like the following. (which I created as a toy data)
ID t c s
1 1 50 Y
1 2 53 Y
1 3 49 Y
1 4 39 Y
1 5 42 Y
1 6 48 Y
1 7 60 Y
1 8 40 Y
1 9 20 N
1 10 5 N
1 11 1 N
1 12 8 N
2 27 62 Y
2 28 64 Y
2 29 61 Y
2 30 66 Y
2 31 40 Y
2 32 38 N
2 33 32 N
2 34 10 N
3 8 30 Y
3 9 33 Y
3 10 33 Y
3 11 29 Y
3 12 32 Y
3 13 30 Y
3 14 18 Y
3 15 33 Y
3 16 34 Y
3 17 30 Y
4 . .
. . .
. . .
. . .
To understand easily, t is time and c is a (numeric) time series and s is a (categorical) time serise.
I have more than 200K IDs. Now I want to graph each ID's time series with 't' on xaxis and 'c' on yaxis. Plus 's' only when it turns to N for the first time. (at most only one point with different color)
Furthermore, I want to plot one at a time when I press the enter key. Or I want it to be like a slide show with a slide per ID until I stop (there are too many IDs and so without 'stop' option, it might plot forever).
As you see, the purpose of these plots is just to demonstrate how series roughly look like and get more sense of the database.
The sample plots drawn in Excel but I hope it to be any program like Access.
Please help me out with this.
Thank you experts,
Joon
