I've been fighting this for hours and cannot seem to search the forum for the right answer...
My client wants to see a customer density within a radius of a selected Zip Code. If I hard code a single lat/long into the "Distance - Version 1" calculated field, i get a nice heat map around the hard-coded lat/long of a particular zip code (90026). However, in "Version 2" tab...if I give a parameter to choose the centering zip code, and pass the lat/long into "Distance - Version 2", I'm not getting the heat map of all the surrounding zip codes that are within the radius.
Please look at Version 1 and Version 2. I simply need Version 2 to look like Version 1 when selecting the Target Zip code parameter.
Thank you so much in advance!!!
Jim,
First, thank you for taking the time.
I think I understand your workbook, however...
Because my client wants to choose any zip code (around Los Angeles) and there are hundreds and hundreds of them...doing a cartesian join (as I understand it) would duplicate each customer over a thousand times (once for every zip code)...and there are thousands of customers...resulting in a set with tens of millions of records.
Let me know if I understand your solution correctly.
