That worked perfectly, thanks so much! Still need help with the number formatting though. Anyone have any ideas?
On Jan 13, 4:57 am, Fneufneu <[email protected]> wrote: > use ISO country code format like this > data.addColumn('string', 'ISO'); > data.addColumn('number', 'Quantity'); > data.addColumn('string', 'Country'); > and > data.setValue(0, 0, 'US'); > data.setValue(0, 1, 1234567); > data.setValue(0, 2, 'United States of America'); > > but i dont have any solution for number formatting. > > On 12 jan, 18:15, Marion <[email protected]> wrote: > > > I'm very new at working with the API, so bear with me! > > > I'm using theGeoMapvisualization in Region mode. I am showing some > > rather large numbers (in the millions and billions) and I need to be > > able to format these numbers accordingly. ie. 1,234,567 instead of > > 1234567. I tried changing the column type to 'string' instead of > > 'number' and using PHP's number_format() function, and this did not > > work - the color scale did not appear and all the countries I had > > selected were black. I also tried leaving the column type on 'number' > > and using PHP's number_format() function and this also did not work - > > the visualization truncated my numbers past the first comma. Is there > > any solution to this? > > > I am also curious if any documentation exists for the exact country > > names that the API knows how to work with. For example, the API wants > > "United States" but it is "United States of America" in my database. > > I would like to ensure that my country names match up to the API, but > > I can't seem to find a list. It seems like there should be a list > > somewhere? > > > Any help with these matters would be greatly appreciated. Thanks in > > advance! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
