I'm pretty new to Spotfire Map Charts.
I am looking to build a dashboard which would be maintained in SharePoint Lists. We have a column - 'Location' which would have the region (countries) that are affected by a particular row. It is a multiselect data type.
From what i have tried on the map charts so far, it seems i would have to give in the Longitude and Latitude information. However, the data i have looks more in the following fashion:
Row 1 : United States; Canada Row 2 : Mexico; Chile; China Row 3 : Germany Row 4 : Brazil; Canada
For my purpose, i would want to show the locations to show up on the Map charts and would read the data as follows:
United States: 1 Canada : 2 Mexico : 1 Chile : 1 China : 1 Brazil : 1
Can someone please guide me how i can go about doing that.
Thanks in advance!
I was able to use the geocode my data but was still having issues due to my data being a multi-select. To simplify things for me, i made changes to the source (Made a different table, which would clean the data and have a single country in each column, this is then imported into Spotfire) and was able to make it work.
This is a workaround, not a solution. Thanks.