Thanks for this but I am not sure if that works for me.
I do not intend to calculate distance between two shops. I want to count number of stores which are within specific distance (say 2 miles) of each other.
1 of 1 people found this helpful
Check the first it exactly fits to your requirement;
please check this thread which is already posted in community; density map & clustering
Thanks for the help.
First tutorial Customers within N miles radius analysis using Tableau helped a great deal and exactly this is what I was looking for.
I am using Tableau 8.2 and I have set up the maps but facing trouble to sum up results in a table.
The table I am looking forward to simply has Region and Number of Customers as columns. So each region names shows numbers of customers falling within N miles of stores in that region.
In rows basically I plan to show radius we chose. (Variable 'N') in this case.
Can you help me with the table?
Ok I found it. Below formula works best.
IF FIRST()==0 THEN
WINDOW_SUM(SUM(IF [Sales at STORE Level] >= 0 THEN 1 ELSE 0 END))