0

Using CustomerID instead of their address to look up location

Hello,

Part of a dashboard we're making will use google maps imbedded API and dynamic URL to show the customer's location. I'm wondering how we can use a CustomerID to filter the map, instead of their address. I thought there was something with hidden slicers in the lessons, but I can't seem to find it.

I'm using randomly generated addresses for this proof of concept.

6 replies

null
    • VP Product Management
    • Ian_Macdonald
    • 2 wk ago
    • Reported - view

    Hi 

    You can use anything you like to filter the data before you send it onto Google Maps. I'm not quite sure what it is you are asking.

    Can you please clarify?

    Thanks,

    Ian

      • Stefano_Sena
      • 2 wk ago
      • Reported - view

      Hi  ,

       

      Instead of using the address to filter through the locations, I'd like to use the address' corresponding customer ID. The below example shows the map when I try to filter using the customer ID instead of the address (example from original post). EDIT: this is showing the incorrect address.

      Below is the test data I'm using if this helps:

      Dynamic URL below as well:

    • VP Product Management
    • Ian_Macdonald
    • 2 wk ago
    • Reported - view

    Hi 

    OK, but Google maps knows nothing about your Customer ID. All it knows is how to plot a lat/long on the map, geocoded from the address you are passing to it.

    So you can filter on Customer ID in Pyramid, because your model knows about it, then you have to pass to Google that ID's address so it can geocode it and put a pin on the map.

    Ian

      • Stefano_Sena
      • 13 days ago
      • Reported - view

      Hi  ,

       

      Thanks for your insight and advice.

    • Customer Solutions Architect
    • Moshe_Yossef
    • 13 days ago
    • Reported - view

    Hi 

    I think what you want to do is add a customer id filter, and an address filter.

    Then create an interaction between the customer id and the address filter.

    Then interact the address filter with the URL element.

    then hide the address filter.

    Notice you need to use the dynamic URL to get the address - so you will probably need to use captions.

      • Stefano_Sena
      • 13 days ago
      • Reported - view

      Hi  ,

       

      This worked, thank you! I had the filter interactions backwards...

      Have a great day!

Content aside

  • Status Answered
  • 13 days agoLast active
  • 6Replies
  • 24Views
  • 3 Following