Tip of the Week - Geo Chart from Text Column

Tip of the Week - Geo Chart from Text Column

When your dataset contains geographical data columns (continent, country, county, state or city), Zoho Analytics automatically sets them to the corresponding Geo data type. However, there may be cases where the auto-identification may not happen. Like when too many data values are mis-spelt, or are empty, the Geo column may get identified as a Text column. You can still use the Text column and specify it as Geo data type in the Chart editor.




The following animation explains how this is done (creating a map chart from a text column).



This option also allows you to treat a geo column as a text column.