2 of 2 people found this helpful
Tableau out of the box will map to zip
if that is not good enough for the need then you will need to use custom mapping from mapbox and Qgis to get you closer
you can use Sarah Battersby's work on jittering the point
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
"I tried finding street-level coordinates but wasn't successful."
What did you try? Usually inputting the address into Google Maps is enough to get you latitude and longitude points for any street address.
The issue, though, is that you're going to need those same lat/long coordinates for ALL your locations if you have them for some. It's hard to get Tableau to work with multiple levels of granularity when you're creating a map.
Can you "jitter" the values: https://www.biztory.com/2015/11/16/tableau-tip-multiple-map-symbols-on-a-same-location/ ?
Another approach: Jitter on a map without identical coordinates
WAHOO!!! I learned something! I'd just been googling the address, but found that I go to Google Maps, drop in the address, right click on the resulting pin, Select What's Here, and the coordinates pop up on a tile at the bottom of the screen. You are worth your weight in coffee beans today. Many thanks!
Glad that helped!
Those coordinates are in the URL too, if you know where to look...
In addition to directions provided find my approach as reference below and stored in attached workbook version 10.5 located in the original thread
1. M1. Customer String Feeder: IF FIRST()==0 THEN STR(MIN([Customer Name])) ELSE PREVIOUS_VALUE("") + ", " + STR(MIN([Customer Name])) END
2. M2. Customer String: IF FIRST()==0 THEN LOOKUP([M1. Customer String Feeder],LAST()) END
3. Drag the required objects to the indicated locations
4. M2. Customer String > Right Click > Edit Table Calculation >
Hope it helps