google / google-visualization-issues

288 stars 35 forks source link

problem with Cork, Ireland #2087

Open ghost opened 8 years ago

ghost commented 8 years ago

Hi

if I have a spreadsheet of counties and values for Ireland, eg:

County Value Dublin 100 Wexford 200 Galway 500 Cork 200 .....and so on.

I create a geochart for Ireland, setting Region to IE and the Resolution to Provinces.

All 26 counties populate with the correct values, except for county Cork. Nothing populates for Cork at all.

If, however, I change the reference to 'Cork' to the ISO-code for Cork (IE-CO), then the chart populates correctly, but with the tooltip reading as IE-CO, which I can't have.

Can anything be done to fix this?

Example for reference here:

https://jsfiddle.net/zz5aq119/

Thanks

Orlaith

grabks commented 8 years ago

Pasted response from email thread: Hi Orlaith,

It appears that the ISO code in our coder is incorrect for Cork. If your only concern is the tooltip, then you can simply provide a formatted value that says 'Cork', which will display in the tooltip. However, the actual ISO code would still be used for the display. Here's an example: https://jsfiddle.net/zz5aq119/1/

ghost commented 8 years ago

Thanks for the reply - I'm using the chart via a plugin for a wordpress site, so it's not really possible to re-format the value.

Is it possible for the ISO code to be updated with the correct code?

thanks!

grabks commented 8 years ago

We intend to update the regioncoder with the updated codes, but I don't have any estimates of when we might do this. You'd be better off implementing some sort of workaround for now.

If you can't modify the formatted values, then you could use another workaround where you add a label column. Here is an example of that: https://jsfiddle.net/zz5aq119/2/

ghost commented 8 years ago

Ok thank you - I'll see what I can do.