Problems with axis values not displaying are usually due to one of two things: either improperly loading the API, or drawing charts inside hidden divs.
On Monday, February 24, 2014 1:12:22 PM UTC-5, Ashok Kumar wrote: > > I fixed the issue but again i have a minor problem the values in the xaxis > are not displaying in my column graph however when i hover over the bars in > the graph the x and y axis values are getting displayed. > > On Friday, 21 February 2014 16:27:38 UTC+1, asgallant wrote: >> >> If you are grouping your data, then it is reasonable to expect the >> grouped data set to be smaller than the base data set. If each unique >> value in column 3 is in an average of about 3 rows, those row counts make >> sense. >> >> On Friday, February 21, 2014 10:04:13 AM UTC-5, Ashok Kumar wrote: >>> >>> Hi, >>> >>> I am trying to generate a column chart from a csv file with 1677 rows. >>> However the chart only displays data from the first 550 rows in the source >>> CSV file. >>> >>> I am using the group method to display the max usage of tokens for each >>> day in the month. I have also given my code hereunder. >>> >>> Regards, >>> Ashok >>> >>> <!DOCTYPE html> >>> <html> >>> <head> >>> <title>Tele2 QTP License Monitoring Console</title> >>> <script src="https://www.google.com/jsapi";></script> >>> <script src="http://code.jquery.com/jquery-1.10.1.min.js";></script> >>> <script src="http://localhost/jquery.csv-0.71.js";></script> >>> <script type="text/javascript"> >>> google.load("visualization", "1", {packages:["corechart" , >>> "gauge"]}); >>> //google.load("visualization", "1", {packages:["gauge"]}); >>> </script> >>> <script> >>> function Initalize() >>> { >>> drawChart(); >>> drawGauge(); >>> } >>> >>> function drawChart() >>> { >>> var queryOptions = >>> { >>> csvColumns: >>> ['string','string','string','string','string','number','number','number','string','string','string','number','string','string','string','string'], >>> >>> csvHasHeader: false >>> } >>> csvUrl= >>> 'http://10.206.50.158/output.csv<http://www.google.com/url?q=http%3A%2F%2F10.206.50.158%2Foutput.csv&sa=D&sntz=1&usg=AFQjCNE05UFW07THAXTV68_8D-Dhj1YTmA> >>> '; >>> var query = new google.visualization.Query(csvUrl,queryOptions); >>> query.send(handleQueryResponse); >>> function handleQueryResponse(response) >>> { >>> if (response.isError()) >>> { >>> alert('Error in query: ' + response.getMessage() + ' ' + >>> response.getDetailedMessage()); >>> return; >>> } >>> var data = response.getDataTable(); >>> /*var GaugeData = response.getDataTable(); >>> var RowId = GaugeData.getNumberOfRows()-1;*/ >>> var maxLicensebyDate = google.visualization.data.group(data,[3],[{ >>> type: 'number', >>> label: 'License', >>> column: 6, >>> aggregation: google.visualization.data.max >>> }]); >>> var dataView1 = new google.visualization.DataView(maxLicensebyDate); >>> /*var dataView2 = new google.visualization.DataView(GaugeData); >>> dataView2.setRows([RowId]); >>> dataView2.setColumns(6);*/ >>> var chart = new >>> google.visualization.ColumnChart(document.getElementById('chart')); >>> //var GaugeChart = new >>> google.visualization.Gauge(document.getElementById('gaugechart')); >>> chart.draw(dataView1,{title: 'Daywise License Utilization',hAxis: >>> {title: 'Date'},vAxis: {title: 'License'}}); >>> //GaugeChart.draw(dataView2,{width: 400, height: 250,redFrom: 18, redTo: >>> 20,yellowFrom:15, yellowTo: 17,minorTicks: 5,min: 1,max: >>> 20,animation:{duration: 400,easing: 'linear'}}); >>> } >>> } >>> function drawGauge() >>> { >>> var queryOptions = >>> { >>> csvColumns: >>> ['string','string','string','string','string','number','number','number','string','string','string','number','string','string','string','string'], >>> >>> csvHasHeader: true >>> } >>> csvUrl= 'http://10.206.50.158/output.csv'; >>> var query = new google.visualization.Query(csvUrl,queryOptions); >>> query.send(handleGaugeResponse); >>> function handleGaugeResponse(response) >>> { >>> if (response.isError()) >>> { >>> alert('Error in query: ' + response.getMessage() + ' ' + >>> response.getDetailedMessage()); >>> return; >>> } >>> var GaugeData = response.getDataTable(); >>> var RowId = GaugeData.getNumberOfRows()-1; >>> var dataView2 = new google.visualization.DataView(GaugeData); >>> //console.log(RowId); >>> dataView2.setRows([RowId]); >>> dataView2.setColumns([6]); >>> var FilteredView = dataView2.toDataTable(); >>> >>> //'string','string','string','string','string','number','number','number','string','string','string','number','string','string','string','string' >>> >>> //FilteredView.insertRows(1,[[null],[null],[0],[null],[null],[null],[null],[null],[null],[null],[null],[null],[null],[null],[null],[null]]); >>> FilteredView.setColumnLabel(0,'License'); >>> var GaugeChart = new >>> google.visualization.Gauge(document.getElementById('gaugechart')); >>> GaugeChart.draw(FilteredView,{width: 400, height: 250,redFrom: 18, >>> redTo: 20,yellowFrom:15, yellowTo: 17,minorTicks: 5,min: 1,max: >>> 20,animation:{duration: 400,easing: 'linear'}}); >>> } >>> } >>> google.setOnLoadCallback(Initalize); >>> </script> >>> </head> >>> <body> >>> <center><blockquote><font size =8><font color="blue">QTP License >>> Dashboard</font></blockquote></center> >>> <div id="chart"></div> >>> <br> >>> <br> >>> >>> <div id="gaugechart"></div> >>> </body> >>> </html> >>> >> -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
