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 the Geo Map visualization 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 -~----------~----~----~----~------~----~------~--~---
