the problem is that the second column has a lot of null values. once the majority of values are null, the chart doesn't display any values. can you set the value of the empty cells to 0 instead of null?
thanks, MC Get Vizzy On Thu, Sep 3, 2009 at 8:24 PM, Kostrowsky <[email protected]>wrote: > > Hi, > > I'm trying to show a simple Line Chart by querying a 2-column dataset > of 130 records. The first column is a date, the second one a value > corresponding to the date. You may find the spreadsheet page at: > > > http://spreadsheets.google.com/pub?key=tM0t3U1FfvsGypMlD_lEePw&single=true&gid=2&output=html > > When I select up to 20 records or so to be treated with the > Visualization API, the dataset is processed readily. But with more > than 20 records or so (there is 132 records in all), my chart comes > out empty, without any error being alerted. > > Since I only want to show in the chart the last 10 days of data, I > coded the following. The code is functioning properly with < 20 > records, but with more than 20, the x-axis shows the last 10 days, but > the chart is still empty. > > / > > ***************************************************************************/ > > function drawChart() { > var query = new google.visualization.Query('http:// > spreadsheets.google.com/tq? > > range=A2:B50&headers=-1&key=0ApZfIRHIB6uCdE0wdDNVMUZmdnNHeXBNbERfbEVlUHc&gid=2'<http://spreadsheets.google.com/tq?%0Arange=A2:B50&headers=-1&key=0ApZfIRHIB6uCdE0wdDNVMUZmdnNHeXBNbERfbEVlUHc&gid=2%27> > ), > now = new Date(), > oneDay = 24*60*60*1000, > numberOfDays = 10, > daysAgo,dateString,todayString,dd,mm,aa; > daysAgo = new Date(now-oneDay*numberOfDays); > dd = daysAgo.getDate(); > dd = dd<10?'0'+dd:dd; > mm = daysAgo.getMonth()+1; > mm = mm<10?'0'+mm:mm; > aa = daysAgo.getFullYear(); > dateAgoString = aa+'-'+mm+'-'+dd; > dd = now.getDate(); > dd = dd<10?'0'+dd:dd; > mm = now.getMonth()+1; > mm = mm<10?'0'+mm:mm; > aa = now.getFullYear(); > todayString = aa+'-'+mm+'-'+dd; > query.setQuery('SELECT A,B WHERE A >= date "'+dateAgoString+'" and A > <= date "'+todayString+'" ORDER BY A'); > query.send(handleQueryResponse); > } > / > > ***************************************************************************/ > > What am I doing wrong, or is there a limitation to the number of > records? > > Thanks. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. 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 -~----------~----~----~----~------~----~------~--~---
