I think you just need to load the data source (in your case sales data). You need to ensure having one single column in the data source with the ISO2 or ISO3 code.
After loading the data open the data manager and edit the data source. Make sure that for the appropriate colum the field type is set to geo data and the format is set to ISO2 or ISO3.
Do the reload again. You then can drag the country field onto the map together with the KPI field.
The world map visualisation is done automatically.
Please mark helpful / correct if applicable
Thanks for your reply.
I tried out your suggested solutions but it still did not work for me.
I think the problem lies with the fact that the column name of 'World.Name' of the world.kml file cannot be changed to 'CountryISOCode' without an error message showing, which says 'the field name must be unique. the field already exists in table: salesdata$'
Hi, maybe I didn´t explain myself enough.
I meant just to load the sales data file. The world map is loaded automatically when you assign the country field as a geo field with ISO2 or ISO3 code. You don´t need to load a separate world.kml file.
PS: Yes, it´s right. The data manager doesn´t allow to rename a field to the same fieldname of an another source. For me this is a missing feature, because exactly by having same field name you can achive the match between data sources.
If you really need to load your own world.kml file you have to go to the data load editor, unlock the autogenerated code and then to rename the field automatically in the script. Unfortunately this will cause that the data load manager cannot be used for the existing loads (only for new loads).