Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiple Legends in Single map

Hi, I have a data of my service centre presence across the globe. I have another data set of total users of my service per country across the globe. I have created a map displaying service centre ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Maggie,

Thank you for your reply!

I have gone through the link, it has only single data set but I have multiple data set and let me re frame my doubt.

 

"I have a data of my electronic devices sales per country across the globe.

I have another data set of total sales of all the electronic devices across the globe.

I have created a map displaying my sales in each country.

Now I have to see both the data in the map to check where
I dont have any sales and others are selling along with my sales center detials."

 

Thanks in Advance

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Do you have a table like this?

country electronic devices sales
a 1 10
a 2 11
a 3 12
b 4 13
b 5 14
c 6 15

 

Then you want to show country and sales of the electronic devices in this country in the map, right?

 

If not, please show me a simple example data and expected result.

 

Best Regards
Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Maggie,

     

    Really thanks for your replies, 

     

    Please find the below details

     

    Data set 1 Has country,Sales centre ,geo coordinates, device sold and sales  valueData set 1

     

     

     

     

     

     

     

     

     

     

     

    Data set 2 has country and device sold in the country (Generic Data not my sales)

    Data set 2

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Using Data set 1 

    I created a map showing sales of device in the country and located with the geo coordinates.

     

    Now I want to include the second data set details in the same map to see country wise usage of device as well as my sales in the country.

     

    For eg; In Chile people are using all three device where am selling only TV.

    So to visualize it, I need to mark the whole chile in three Colours one for each device and I need to pin point my sales centre using geo coordinates.

     

    Out should be like this , where the fill map style is representing the county and device used blue dots are my sales centers.

    Output in maps