Forum Discussion
There is no way in geographical data to distinguish between province and municipality
It's better to discuss with the sample file. Tool is very sensitive to column names, do you use rich data types or texts, table or range, exact names of the values.
SergeiBaklan Well, I use location names in my language, of course, but you are right: the tool is very sensible to texts in some unpredictable way. For example, if I write:
and I select them as geographical data, I get
It looks like "Inghilterra" (i.e. England) is not recognized. Same for "Spagna" (i.e. Spain). What's fun is that if I write
and set them as geographical data, I get
in Italian language! So, quite hard to understand the logics of that piece of software!
At least partly logic is on AI site, human being sometimes have another one.
In addition to column names try plain texts instead of data types in values. Based on my experience in many cases texts work better.
- You cannot create a map chart by plain text. You have to tell Excel that those labels refer to geographic areas.
