Hello Tableau Vizards,
In my data I have the records with zipcodes and I need to display records within 50 miles of radius of zipcode selected.
I need to create filter for the zipcode and miles (ex: 50 miles) selector so I can select zipcode to display the records within 50 miles of radius of that zip code.
I can see latitude (generated) and longitude (generated) in measures.
Please guide how to calculate this. I have attached the test data as excel.
Can I display records without map?
Thanks in advance.
-Priti
Hi, Priti
To achieve your requirement, you need another data source with lat/long information for each zip code.
and left join to your data source by zip code as shown below
and then create the calculation to calculate the distance
a sample workbook attached for your reference.
Hope this could help
ZZ
