Background: Large retail company with many stores throughout the US. Sometimes 2-4 stores are in close proximity to each other, like in shopping malls. Alteryx is used to generate the centroid of each store, based on longitude/latitude. This data is used in Tableau to generate maps.
Issue: Stores in close proximity to each other have overlapping marks in Tableau, making it appear as 1 store instead of 2-4 stores. In most cases, cannot tell it's multiple stores unless zooming in extremely close, which is not a solution.
Possible Solution: I'm able to identify which stores are in close proximity to each other. My thinking is that I can manually provide separation by altering the longitude / latitude of these stores. I have provided an example with 4 stores close to each other. If I could figure out how to loop through them and move the northern most store (max latitude) further north, the southern most store (min latitude) further south, the eastern most store further east, the western most store further west. This is the part I'm having trouble coming up with a solution for.
I have attached example data of 4 "overlapping" stores along with screenshots of how 4 stores can appear as 1.
