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
-
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
-
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:
-
-
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
-
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.