For turning on and off the lines, would either of these work for you?
http://jsfiddle.net/asgallant/WaUu2/
http://jsfiddle.net/asgallant/6gz2Q/
If you can't change the format of the CSV, then you'll have to manually
parse it, but your structure is simple enough that this shouldn't present a
problem. Once it is loaded in the browser, this should suffice to
transform it into a DataTable for the charts:
function csvToDataTable (csv) {
// split the csv on line breaks
var csvRows = csv.split(/\r{0,1}\n/g);
var rawData = [], row, match, year, month, day, hours, minutes, seconds;
for (var i = 0; i < csvRows.length; i++) {
row = csvRows[i].split(',');
if (i != 0) {
// assumes dates are in the format "MM/dd/yyyy HH:mm:ss"
match = row[0].match(/(\d{2})\/(\d{2})\/(\d{4})
(\d{2}):(\d{2}):(\d{2})/);
year = parseInt(match[3], 10);
month = parseInt(match[1], 10) - 1; // convert to javascript's
zero-indexed months
day = parseInt(match[2], 10);
hours = parseInt(match[4], 10);
minutes = parseInt(match[5], 10);
seconds = parseInt(match[6], 10);
row[0] = new Date(year, month, day, hours, minutes, seconds);
for (var j = 1; j < row.length; j++) {
// convert the strings to numbers
// change to parseFloat if your numbers can be floats
row[j] = parseInt(row[j]);
}
}
rawData.push(row);
}
return google.visualization.arrayToDataTable(rawData);
}
Loading the data might be a bit tricky; is this going to be hosted on your
local PC or on a website? Do you have the choice of where the CSV gets
stored?
On Saturday, July 26, 2014 2:40:51 PM UTC-4, 66spl...@gmail.com wrote:
>
> Well Im certainly willing to try. I've looked a bunch of examples but
> just cant seem to get my data loaded,at least if I include the date field.
> I manually put a ' ' around date and that worked except I have no control
> over the format of the csv to actually include those ' '
>
> But sure, lets give this a shot.
>
> By turning off / isolate values I have 10 temperatures, I'd like to be
> able to display just one or two of them or all 10. Having 10 lines gets a
> bit messy, plus this might grow to more in the future.
>
> Both of those zooms are brilliant. I was checking out the google example
> when I was researching this the last couple weeks, thats exactly what I was
> envisioning.
>
> Thanks for offering to help out!
>
>
> On Friday, July 25, 2014 6:36:49 PM UTC-7, Andrew Gallant wrote:
>>
>> This is probably easy to do, and if you're feeling adventurous, we can
>> help you save a bit of cash and do this yourself.
>>
>> A few key questions:'
>>
>> What do you mean by "turn off / isolate certain values"?
>>
>> Would something like this
>> <https://developers.google.com/chart/interactive/docs/gallery/controls#chartrangefilter>
>> or
>> this <http://jsfiddle.net/asgallant/fgM4V/> work for you to zoom your
>> data?
>>
>> On Friday, July 25, 2014 2:26:08 PM UTC-4, 66spl...@gmail.com wrote:
>>>
>>> I have a few bucks to pay someone to write a fairly basic chart for me.
>>> I have a csv file on the local machine that will be serving the chart web
>>> page. The file is updated every few minutes recording temperature values
>>> and a time stamp. All the chart needs to do is load the data and display
>>> it. I would like the ability to turn off / isolate certain values and also
>>> zoom into a section of the chart.
>>> Every couple months the data is reset so the max is going to be 3 months
>>> of data. Here is what the .csv looks like.
>>>
>>> Time,Temp1,Temp2,Temp3,Temp4,Temp5,Temp6,Temp7,Temp8,Temp9,Temp10
>>> 03/03/2014 00:26:37,52,77,79,66,63,66,86,72,66,57
>>> 03/03/2014 00:27:37,52,78,80,66,63,66,87,72,67,57
>>> 03/03/2014 00:28:38,52,79,84,67,64,69,86,72,68,52
>>> 03/03/2014 00:29:39,52,77,88,68,66,76,83,72,68,51
>>>
>>>
>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
