So the business problem is like this: We sell our product via the FMCG Producer-Distributor-Retailer model. With our distributors we make a legal agreement that we will not make any other distributor within x kms radius area of your shop. X gets decided on the shop size and demand size of the area.
For this I have to plot a map which keeps getting updated based on our distributor's details and whatever particular logic of x is.
The one solution I can think of is placing all the data on a sheet, making a column of that x kms and then plotting it on my maps which I keep refreshing as new data comes in.
I am just wondering if there is a better solution as a lot of companies would need real-time understanding of their distributors shops and area they are allowed to govern
