mirde
asked on
PHP Script that will graph CSV data?
Hello,
I am looking for a decent php script (or any other type) that I can configure to create a graph out of a CSV file that is constantly appended with new data feeds?
The sample CSV data is also attached.
Anyone know of anything out there that will do what i am trying to do here?
I am looking for a decent php script (or any other type) that I can configure to create a graph out of a CSV file that is constantly appended with new data feeds?
The sample CSV data is also attached.
Anyone know of anything out there that will do what i am trying to do here?
Date,DB Writes,BI Reads,Record Reads,BI Writes,Record Updates,AI Writes,Record Creates,Record Deletes,Record Locks,Index operations,Record operations,Total OS IO,Total OS Reads,Total OS Writes
0416-0705,2536,14,21347764,2292,31265,1651,3316,1812,217497,21337670,21383891,132231,125758,6473
0416-0735,1134,26,16994036,427,1509,379,1721,813,263958,16915886,17006076,123150,121210,1940
0416-0805,2262,24,18030918,1139,23082,992,1655,1024,121704,17983683,18035586,163953,159564,4389
Also, if your site uses the jQuery JavaScript library there are various graphing plugins for it, e.g. http://code.google.com/p/flot/
ASKER
Not sure if anyone knows, but I have seen a very nice "timeline" like line chart, i think it was an open source project somewhere..
Maybe i'm thinking of a plugin available to Perl.. anyone able to read my mind?
It was a very interactive timeline like chart that you could pan left/right, etc..
Maybe i'm thinking of a plugin available to Perl.. anyone able to read my mind?
It was a very interactive timeline like chart that you could pan left/right, etc..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I guess for graphing csv data which would create "many" data points (currently generating 30 data points per day, and trying to graph a month worth).
What is the best way to do this?
Annotated time-line might not be the best for this, maybe just a line graph?
What is the best way to do this?
Annotated time-line might not be the best for this, maybe just a line graph?
Sure, line graph sounds best. The annotation is just an example of what it can do, for me the best feature there is the ability to zoom in and scroll along. For ~900 points per graph that'll probably be very useful.
ASKER
Never really played with API stuff, more of a tech admin here..
Any idea on how to pass many csv datapoints to google API and have it graphed?
I would imagine this would need to be done programatically.. any examples of that? or references to some good reads to get started on?
Any idea on how to pass many csv datapoints to google API and have it graphed?
I would imagine this would need to be done programatically.. any examples of that? or references to some good reads to get started on?
ASKER
Just the type of graph I am looking for.
Or GraPHPite http://graphpite.sourceforge.net/