I created my 1st visualization that creates a sortable table of values. The problem is that when I sort the "Checkouts" column, they sort like letters and not like numbers even though I specified the column data type as a number.
Here's the table: http://library.paulsmiths.edu/test/charts/top5visualization.html And the json data that it queries: http://library.paulsmiths.edu/test/charts/top5.php Notice that that Checkouts column is a number but when you sort the column, it doesn't sort properly: {"cols":[{"id":"year","label":"Year","type":"number"}, {"id":"title","label":"Title","type":"string"}, {"id":"checkouts","label":"Checkouts","type":"number"}], Sorted Copy from chart: 2011 Dog hikes in the Adirondacks : 20 trails to enjoy 9 2010 Water for elephants : a novel by Sara Gruen. 9 2010 The Eighth International Symposium on Environmenta 9 2010 Streams : their ecology and life by Colbert.E. Cu 8 2010 Introduction to permaculture by Bill Mollison wit 8 2010 Negotiation by Roy J. Lewicki, Bruce Barry, David 8 2010 Amuse-bouche : little bites that delight before th 8 2010 Billy Joe Tatum's Wild foods cookbook and field gu 8 2008 About wine by J. Patrick Henderson, Dellie Rex. 36 2011 The help by Kathryn Stockett. 18 2009 Twilight by Stephenie Meyer. 16 2011 Research design : qualitative, quantitative, and m 14 2009 Lies my teacher told me : everything your American 14 2009 Marked : a house of night novel |c P.C. Cast and 14 2008 Plows, plagues, and petroleum : how humans took co 14 2010 How the other half lives; studies among the teneme 13 Any idea how to fix this? Am I overlooking something? Thanks, Mike -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To post to this group, send email to google-chart-api@googlegroups.com. To unsubscribe from this group, send email to google-chart-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-chart-api?hl=en.
