By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Graph database

P: 8
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 x-axis and 'c' on y-axis. 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
Dec 1 '08 #1
Share this Question
Share on Google+
1 Reply


P: 8
I forgot to attach my sample graphs.
Here they are.

Corresponding IDs are:

1-2
3
Attached Images
File Type: jpg sample1.jpg (11.0 KB, 108 views)
File Type: jpg sample2.jpg (13.6 KB, 125 views)
File Type: jpg sample3.jpg (10.7 KB, 96 views)
Dec 1 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.