Forum Discussion

teatree's avatar
teatree
Frequent Visitor
9 years ago
Solved

Duplicating Map Legend

Hi,   My map seems to be duplicating each point on the map when both of my legends are selected.   So, I'm placing a pointer on a map to say that one is a client and the other is not a client. Wh...
  • Sean's avatar
    Sean
    9 years ago

    You are welcome! :smileyhappy:

    One more thing you may consider is concatenating columns into a new column solely for Tooltip Use.

    So first create a Column by concatenating the information you want to show in the Tooltip and then use this new column in a Measure!

    Hope this helps! :smileyhappy:

     

Sean's avatar
Sean
Community Champion
9 years ago

teatree This is most likely because you've left the Size field empty.

You need to Leave the Location field blank

Legend - Client/Is not Client column

Lat - Latitude (Do Not Sum) with this set up

Long - Longitude (Do Not Sum) with this set up

Size - If you want them all to be the same size just drag the Client/Is Not Client column to create a Count of...

I think this should do it! :smileyhappy:

teatree's avatar
teatree
Frequent Visitor
9 years ago

Hi Sean,

 

I have additional data in the location field such as the Establishments Name and the Customer Code so that they show when hovering over,  that way I can see that a) the circle is green so they are a client, and b) what the clients customer reference is.

 

 

In response to the measure, I'm not too sure I understand what you mean as I can't use the measure as a legend, unless I'm misunderstanding?

 

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    teatree

    So what happens when you drag the Client column to the Size field? I think it should work with your setup too!

    • teatree's avatar
      teatree
      Frequent Visitor
      9 years ago

      My client column has both Yes/No

       

      Are you saying it would be better if these were split into separate columns? Because by doing what you have said, everything is the same colour and everything in that client column shows up as 1, whether it says yes or no

       

      Thanks for your help by the way:)

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        teatree Okay you still need to drag Client to the size!

        However the issue I think is happening and/or will happen inevitably at different levels when you do the drill down.

        It will definitely happen when you are on the county level.

        EDIT: Because you are plotting 1 County (1 Location) that has both Customers and Not Customers.

        So the drill-down will work but only on the levels where each point you plot can be only either Customer or Not Customer.

        If it can be both you'll get your original result.

        There are many ways you can go about resolving this.

        1) Use several maps - each at a different level. So we you click a County on one the other will zoom in on the zipcode

        2) Plot only zipcodes and put all else in the tooltips (you'll need measures to do this) and use Slicers to navigate the Map

         

         

        Hope this helps! :smileyhappy:

         

        Let me know if you have any questions.