Glad to hear you got it working. You can use the parseInt() (or
parseFloat(), if you ever need floating point numbers) function to make
your conversion function a bit cleaner:
function convertonumber(data, rowNum) {
return parseInt(data.getValue(rowNum, 1));
}
On Friday, March 9, 2012 8:25:09 AM UTC-5, R22MPM wrote:
>
> Thanks for your help, i have now sorted it and the charts are displaying
> correctly
>
> for reference this is what i used
>
> var data = response.getDataTable();
>
> var view = new google.visualization.DataView(data);
>
> view.setColumns([0, {calc:converttonumber, type:'number', label:
> "TEST"}]);
> function converttonumber(data, rowNum){
> return Math.floor(data.getValue(rowNum, 1) / 1);
> }
>
> On Tuesday, March 6, 2012 5:13:45 PM UTC, R22MPM wrote:
>>
>> Ill check in Google Chrome this evening, i definately know there is data
>> in the datatable because i can populate a table with the data. i am also
>> navigate to the csv which returns the data in JSON format
>>
>> Thanks
>> Matt
>>
>> On Tuesday, March 6, 2012 4:39:00 PM UTC, asgallant wrote:
>>>
>>> Hmm...
>>>
>>> You can use Chrome's developer console to get information on any errors
>>> that may be occurring, and you can view the output from
>>> console.log(<variable>) there (use on your DataTable object to see what it
>>> contains).
>>>
>>> If there is no data in the DataTable or
>>> the handleCsvLicenseCount function is never called, then I suspect the
>>> problem is with the query. Is the java data source API located in the same
>>> directory as your HTML file? If not, you need to include the path to the
>>> java data source API in the query. I am also uncertain of the format the
>>> API expects for the URL; using 'localhost' in the URL would normally point
>>> to your own system, but in this case it probably refers to the server
>>> itself, so you should make sure the CSV is in the right place. Someone who
>>> is familiar with the java data source API would be able to help you more
>>> than I can here.
>>>
>>> On Tuesday, March 6, 2012 11:05:00 AM UTC-5, R22MPM wrote:
>>>>
>>>> Thanks for that, i have tried but unfortunately the gauge is not
>>>> showing, neither is the data in a table? is there any debugging i can put
>>>> into this to step through what the code is doing?
>>>>
>>>> <script type="text/javascript" src="http://www.google.com/jsapi
>>>> "></script>
>>>>
>>>> <script type="text/javascript">
>>>> google.load('visualization', '1', {'packages':
>>>> ['gauge','table','piechart','orgchart','barchart']});
>>>>
>>>>
>>>> // Set a callback to run when the API is loaded.
>>>> google.setOnLoadCallback(init);
>>>>
>>>> // Send the queries to the data sources.
>>>> function init() {
>>>> query = new google.visualization.Query('csv?url=
>>>> http://localhost:8084/Dashboards/Data/LicenseCount.csv');
>>>> query.send(handleCsvLicenseCount);
>>>> }
>>>>
>>>> function handleCsvLicenseCount(response) {
>>>> if (response.isError()) {
>>>> alert('Error in query: ' + response.getMessage() + ' ' +
>>>> response.getDetailedMessage());
>>>> return;
>>>> }
>>>>
>>>> var data = response.getDataTable();
>>>>
>>>> var view = new google.visualization.DataView(data);
>>>> view.setColumns([0, {
>>>> type: 'number',
>>>> label: data.getColumnLabel(1),
>>>> calc: function (dt, row) {
>>>> return parseInt(dt.getValue(row, 1));
>>>> }
>>>> }]);
>>>>
>>>> var options = {
>>>> width: 400, height: 120,
>>>> redFrom: 90, redTo: 100,
>>>> yellowFrom:75, yellowTo: 90,
>>>> minorTicks: 5
>>>> };
>>>> var chart = new
>>>> google.visualization.gauge(document.getElementById('csv_div'));
>>>> chart.draw(view, options);
>>>> }
>>>>
>>>>
>>>>
>>>> </script>
>>>> <!--[if IE]>
>>>> <script src="http://html5shim.googlecode.com/svn/trunk/html5.js
>>>> "></script>
>>>> <![endif]-->
>>>> </head>
>>>> <body>
>>>> SAMPLE TEXT
>>>> <div id="csv_div" style="width: 400px"></div>
>>>> <div id="csv_div1" style="width: 400px"></div>
>>>> </body>
>>>>
>>>> On Friday, March 2, 2012 4:07:10 PM UTC, R22MPM wrote:
>>>>>
>>>>> Hi All,
>>>>> I am a newbie to Coogle charts and have been running through the
>>>>> following tutorial regarding connecting CSV files into charts.
>>>>>
>>>>>
>>>>> http://code.google.com/apis/chart/interactive/docs/dev/dsl_get_started.html#webapp
>>>>>
>>>>> I have a question which im hoping is pretty simple (i have limited JS
>>>>> knowledge)
>>>>>
>>>>> I would like to use Gauge and Bar charts with the CSV data but as i
>>>>> understand it the columns will always be flagged as string, so my
>>>>> question
>>>>> is how and where do i convert the value column to a number?
>>>>>
>>>>> Thanks
>>>>> Matt
>>>>>
>>>>
>> On Tuesday, March 6, 2012 4:39:00 PM UTC, asgallant wrote:
>>>
>>> Hmm...
>>>
>>> You can use Chrome's developer console to get information on any errors
>>> that may be occurring, and you can view the output from
>>> console.log(<variable>) there (use on your DataTable object to see what it
>>> contains).
>>>
>>> If there is no data in the DataTable or
>>> the handleCsvLicenseCount function is never called, then I suspect the
>>> problem is with the query. Is the java data source API located in the same
>>> directory as your HTML file? If not, you need to include the path to the
>>> java data source API in the query. I am also uncertain of the format the
>>> API expects for the URL; using 'localhost' in the URL would normally point
>>> to your own system, but in this case it probably refers to the server
>>> itself, so you should make sure the CSV is in the right place. Someone who
>>> is familiar with the java data source API would be able to help you more
>>> than I can here.
>>>
>>> On Tuesday, March 6, 2012 11:05:00 AM UTC-5, R22MPM wrote:
>>>>
>>>> Thanks for that, i have tried but unfortunately the gauge is not
>>>> showing, neither is the data in a table? is there any debugging i can put
>>>> into this to step through what the code is doing?
>>>>
>>>> <script type="text/javascript" src="http://www.google.com/jsapi
>>>> "></script>
>>>>
>>>> <script type="text/javascript">
>>>> google.load('visualization', '1', {'packages':
>>>> ['gauge','table','piechart','orgchart','barchart']});
>>>>
>>>>
>>>> // Set a callback to run when the API is loaded.
>>>> google.setOnLoadCallback(init);
>>>>
>>>> // Send the queries to the data sources.
>>>> function init() {
>>>> query = new google.visualization.Query('csv?url=
>>>> http://localhost:8084/Dashboards/Data/LicenseCount.csv');
>>>> query.send(handleCsvLicenseCount);
>>>> }
>>>>
>>>> function handleCsvLicenseCount(response) {
>>>> if (response.isError()) {
>>>> alert('Error in query: ' + response.getMessage() + ' ' +
>>>> response.getDetailedMessage());
>>>> return;
>>>> }
>>>>
>>>> var data = response.getDataTable();
>>>>
>>>> var view = new google.visualization.DataView(data);
>>>> view.setColumns([0, {
>>>> type: 'number',
>>>> label: data.getColumnLabel(1),
>>>> calc: function (dt, row) {
>>>> return parseInt(dt.getValue(row, 1));
>>>> }
>>>> }]);
>>>>
>>>> var options = {
>>>> width: 400, height: 120,
>>>> redFrom: 90, redTo: 100,
>>>> yellowFrom:75, yellowTo: 90,
>>>> minorTicks: 5
>>>> };
>>>> var chart = new
>>>> google.visualization.gauge(document.getElementById('csv_div'));
>>>> chart.draw(view, options);
>>>> }
>>>>
>>>>
>>>>
>>>> </script>
>>>> <!--[if IE]>
>>>> <script src="http://html5shim.googlecode.com/svn/trunk/html5.js
>>>> "></script>
>>>> <![endif]-->
>>>> </head>
>>>> <body>
>>>> SAMPLE TEXT
>>>> <div id="csv_div" style="width: 400px"></div>
>>>> <div id="csv_div1" style="width: 400px"></div>
>>>> </body>
>>>>
>>>> On Friday, March 2, 2012 4:07:10 PM UTC, R22MPM wrote:
>>>>>
>>>>> Hi All,
>>>>> I am a newbie to Coogle charts and have been running through the
>>>>> following tutorial regarding connecting CSV files into charts.
>>>>>
>>>>>
>>>>> http://code.google.com/apis/chart/interactive/docs/dev/dsl_get_started.html#webapp
>>>>>
>>>>> I have a question which im hoping is pretty simple (i have limited JS
>>>>> knowledge)
>>>>>
>>>>> I would like to use Gauge and Bar charts with the CSV data but as i
>>>>> understand it the columns will always be flagged as string, so my
>>>>> question
>>>>> is how and where do i convert the value column to a number?
>>>>>
>>>>> Thanks
>>>>> Matt
>>>>>
>>>>
>> On Tuesday, March 6, 2012 4:39:00 PM UTC, asgallant wrote:
>>>
>>> Hmm...
>>>
>>> You can use Chrome's developer console to get information on any errors
>>> that may be occurring, and you can view the output from
>>> console.log(<variable>) there (use on your DataTable object to see what it
>>> contains).
>>>
>>> If there is no data in the DataTable or
>>> the handleCsvLicenseCount function is never called, then I suspect the
>>> problem is with the query. Is the java data source API located in the same
>>> directory as your HTML file? If not, you need to include the path to the
>>> java data source API in the query. I am also uncertain of the format the
>>> API expects for the URL; using 'localhost' in the URL would normally point
>>> to your own system, but in this case it probably refers to the server
>>> itself, so you should make sure the CSV is in the right place. Someone who
>>> is familiar with the java data source API would be able to help you more
>>> than I can here.
>>>
>>> On Tuesday, March 6, 2012 11:05:00 AM UTC-5, R22MPM wrote:
>>>>
>>>> Thanks for that, i have tried but unfortunately the gauge is not
>>>> showing, neither is the data in a table? is there any debugging i can put
>>>> into this to step through what the code is doing?
>>>>
>>>> <script type="text/javascript" src="http://www.google.com/jsapi
>>>> "></script>
>>>>
>>>> <script type="text/javascript">
>>>> google.load('visualization', '1', {'packages':
>>>> ['gauge','table','piechart','orgchart','barchart']});
>>>>
>>>>
>>>> // Set a callback to run when the API is loaded.
>>>> google.setOnLoadCallback(init);
>>>>
>>>> // Send the queries to the data sources.
>>>> function init() {
>>>> query = new google.visualization.Query('csv?url=
>>>> http://localhost:8084/Dashboards/Data/LicenseCount.csv');
>>>> query.send(handleCsvLicenseCount);
>>>> }
>>>>
>>>> function handleCsvLicenseCount(response) {
>>>> if (response.isError()) {
>>>> alert('Error in query: ' + response.getMessage() + ' ' +
>>>> response.getDetailedMessage());
>>>> return;
>>>> }
>>>>
>>>> var data = response.getDataTable();
>>>>
>>>> var view = new google.visualization.DataView(data);
>>>> view.setColumns([0, {
>>>> type: 'number',
>>>> label: data.getColumnLabel(1),
>>>> calc: function (dt, row) {
>>>> return parseInt(dt.getValue(row, 1));
>>>> }
>>>> }]);
>>>>
>>>> var options = {
>>>> width: 400, height: 120,
>>>> redFrom: 90, redTo: 100,
>>>> yellowFrom:75, yellowTo: 90,
>>>> minorTicks: 5
>>>> };
>>>> var chart = new
>>>> google.visualization.gauge(document.getElementById('csv_div'));
>>>> chart.draw(view, options);
>>>> }
>>>>
>>>>
>>>>
>>>> </script>
>>>> <!--[if IE]>
>>>> <script src="http://html5shim.googlecode.com/svn/trunk/html5.js
>>>> "></script>
>>>> <![endif]-->
>>>> </head>
>>>> <body>
>>>> SAMPLE TEXT
>>>> <div id="csv_div" style="width: 400px"></div>
>>>> <div id="csv_div1" style="width: 400px"></div>
>>>> </body>
>>>>
>>>> On Friday, March 2, 2012 4:07:10 PM UTC, R22MPM wrote:
>>>>>
>>>>> Hi All,
>>>>> I am a newbie to Coogle charts and have been running through the
>>>>> following tutorial regarding connecting CSV files into charts.
>>>>>
>>>>>
>>>>> http://code.google.com/apis/chart/interactive/docs/dev/dsl_get_started.html#webapp
>>>>>
>>>>> I have a question which im hoping is pretty simple (i have limited JS
>>>>> knowledge)
>>>>>
>>>>> I would like to use Gauge and Bar charts with the CSV data but as i
>>>>> understand it the columns will always be flagged as string, so my
>>>>> question
>>>>> is how and where do i convert the value column to a number?
>>>>>
>>>>> Thanks
>>>>> Matt
>>>>>
>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/ptwnYJSo7BcJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
