Forum Discussion
There is no way in geographical data to distinguish between province and municipality
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.
SergeiBaklan Well, it looks like I can get better results if I use headers. I wasn't aware of this aspect.
It is not yet all automatic, that is, some manual selection is still necessary, but it works better.
Thank you, Sergei.
I found some other entities, but there appears to be no relationship that says Turin is part of its metropolitan area.
