I suspect that the problem is with the "State Top 10%" and "National Top 10%" columns, which have no data, so it seems that the query is treating them as string columns instead of number columns. I'm not sure that there is a good way to fix this (there are some hacky ways I can think of, but you might encounter other issues with them). Is there a difference between a 0 and a null (empty cell) in your application? If not, perhaps the easy solution is to fill in the empty cells with 0's.
Maintenance-wise, moving the metrics to their own sheets will probably be easier to handle, especially if you decide at some point in the future to change the number of rows of data in each metric. On Tuesday, March 25, 2014 3:09:55 PM UTC-4, Dave Lalande wrote: > > Hmmm... If you look at the > sheet<https://docs.google.com/spreadsheet/ccc?key=0AhCv9Xu_eRnSdHBELWZoZHRaQTl5VXdRa3JLTzByUlE&usp=sharing>I > have a tab named "specific_cells". I have groups of metrics and what > rather than have a sheet for every metric ~20 I was attempting to put more > than one on one sheet. This was the idea behind query a specific range > rather than just selecting an entire column. > > I tried a more targeted range (Metric B in the sheet) and I get a failure > on this fiddle. http://jsfiddle.net/davelalande/62tUa/1/ > -- 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/d/optout.
