I just realized that the sorting of the address is messed up to. I get that its a string and a number. But I can't seem to figure out the proper syntax. Any suggestions?
On Friday, May 2, 2014 2:44:03 PM UTC-4, Todd Lee wrote: > > I've used the goolge api to create a pretty sweet chart. You can find it > here: http://http://www.bramptoncondoliving.ca/index.php?p=665 > > Here is the problem. The chart messes up the numbers over 1000. ie it > should show order up or down like this 100, 200, ...900, 1000 instead is > does 100, 1000, 1100...800,900. > Here is the code that I'm using: > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" " > http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <meta http-equiv="content-type" content="text/html; charset=utf-8" /> > <title>Google Visualization API Sample</title> > <script type="text/javascript" src="http://www.google.com/jsapi > "></script> > <script type="text/javascript"> > google.load('visualization', '1', {packages: ['table']}); > function drawVisualization() { > // Create and populate the data table. > var data = google.visualization.arrayToDataTable([ > ['<b><center>Address</center></b>', > '<b><center>Website</center></b>', > '<b><center>Condo</center></b>','<b><center>Neighborhood</center></b>', > '<b><center>Year</center></b>','<b><center>Floors</center></b>','<b><center>Starting > > Sq.Ft.</center></b>','<b><center>Starting > Price</center></b>','<b><center>Starting > Fee</center></b>','<b><center>Water</center></b>','<b><center>Hydro</center></b>', > > '<b><center>Starting Rent</center></b>'], > > ['<center>20 Cherrytree Dr East</center>', '/mississauga-condos-for-rent', > '<center>Crown West Condo</center>','<center>Fletchers Creek > South</center>','<center>1988</center>', > '<center>16</center>','<center>950</center>','<center>$176,500</center>','<center>$661</center>','<center>YES</center>','<center>YES</center>','<center>$1,450</center>'], > > ['<center>58 Church St East</center>', '/mississauga-condos-for-rent', > '<center>Hallmark Place Condo</center>','<center>Downtown > Brampton</center>','<center>NA</center>', > '<center>13</center>','<center>1,450</center>','<center>$300,000</center>','<center>$640</center>','<center>YES</center>','<center>YES</center>','<center>$1,500</center>'], > > ['<center>100 County Court</center>', '/mississauga-condos-for-rent', > '<center>Crown East Condo</center>','<center>Fletchers Creek > South</center>','<center>1987</center>', > '<center>20</center>','<center>1,100</center>','<center>$205,000</center>','<center>$638</center>','<center>YES</center>','<center>YES</center>','<center>$1,500</center>'], > > > ['<center>9 George St North</center>', '/mississauga-condos-for-rent', > '<center>Renaissance Condo</center>','<center>Downtown > Brampton</center>','<center>2011</center>', > '<center>27</center>','<center>650</center>','<center>$200,000</center>','<center>$257</center>','<center>YES</center>','<center>NO</center>','<center>$1,100</center>'], > > > ['<center>22 Hanover Rd</center>', '/mississauga-condos-for-rent', > '<center>Bellaire On The Park 2 Condo</center>','<center>Queen Street > Corridor</center>','<center>1990</center>', > '<center>24</center>','<center>750</center>','<center>$182,000</center>','<center>$381</center>','<center>YES</center>','<center>YES</center>','<center>$1350</center>'], > > ['<center>24 Hanover Rd</center>', '/mississauga-condos-for-rent', > '<center>Bellair On The Park 3 Condo</center>','<center>Queen Street > Corridor</center>','<center>1990</center>', > '<center>22</center>','<center>750</center>','<center>$172,000</center>','<center>$402</center>','<center>YES</center>','<center>YES</center>','<center>$1,300</center>'], > > ['<center>26 Hanover Rd</center>', '/mississauga-condos-for-rent', > '<center>Bellair On The Park 1 Condo</center>','<center>Queen Street > Corridor</center>','<center>1988</center>', > '<center>16</center>','<center>850</center>','<center>$165,000</center>','<center>$430</center>','<center>YES</center>','<center>YES</center>','<center>$1,200</center>'], > > ['<center>100 John St</center>', '/mississauga-condos-for-rent', > '<center>NA</center>','<center>Downtown > Brmapton</center>','<center>2011</center>', > '<center>27</center>','<center>650</center>','<center>$220,000</center>','<center>$260</center>','<center>NO</center>','<center>NO</center>','<center>$1,200</center>'], > > ['<center>25 Kensington Rd</center>', '/mississauga-condos-for-rent', > '<center>Kensington Towers 2</center>','<center>Queen Stree > Corridor</center>','<center>1975</center>', > '<center>18</center>','<center>950</center>','<center>$155,000</center>','<center>$392</center>','<center>YES</center>','<center>NO</center>','<center>$1,275</center>'], > > ]); > > // Create and draw the visualization. > var table = new > google.visualization.Table(document.getElementById('visualization')); > > var formatter = new google.visualization.TablePatternFormat('<a > href={1}>{0}</a>'); > formatter.format(data, [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]); // > Apply formatter and set the formatted value of the first column. > > var view = new google.visualization.DataView(data); > view.setColumns([0,2,3,4,5,6,7,8,9,10, 11]); // Create a view with > the first column only. > > table.draw(view, {allowHtml: true, showRowNumber: false}); > } > > google.setOnLoadCallback(drawVisualization); > </script> > </head> > <body style="font-family: Arial;border: 0 none;"> > <div id="visualization" style="width: 940px; height: 400px;"></div> > </body> > </html> > > > Please how do I get it to sort properly? > > Thanks > Todd > -- 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.
