2 Replies Latest reply on Feb 15, 2017 12:18 AM by Matthijs Blenkers

# Customer within/outside range of a dealership

Hi all,

Here's a fun question. It's been bugging me for days now and I can't figure it out.

Case

We have dealerships in different network/chains the Netherlands. Our goal is to have a dealership within say 50km of any customer. Our account manager wants to check:

- How many customers are within the 50KM range

- How many customers are outside the 50KM radius

We want to plot all of our customers and dealerships on a map. When the account manager selects a dealership chain (filter or legend) al the customers within 50km reach a dealership should be identifiable (say a different colour). As a consequence, all the customers outside are also identifiable. We also want to show 'the numbers' --> 5000 customers within service area, 1000 outside service area.

This viz will help the accountmanager to see the degree of coverage of each dealership chain separately or all the chains together AND spot area's where a new dealer is needed.

What do I have so far

I have a solution with a dual axis map. A filled map with the customers per county and a polygon with the gps locations of all the dealerships. The polygon draws a 50km circle around a dealership.

Although it's a nice viz, it isn't quite what I want.

a) When filtering on the dealership chain all my county's without a dealership are filtered out (duh!).

b) I can't count how many customers are in and out of range

I hope you understand I can't share my data. Perhaps the superstore datasource with mock gps for the customers?

• ###### 1. Re: Customer within/outside range of a dealership

Hi Matthijs,

You can go for distance calculation between two locations using calculated field. Here is the link:

Then try to apply filter on this calculation.

Tushar

• ###### 2. Re: Customer within/outside range of a dealership

Hi Tushar,

Thank you for your quick response.

I thought about that too, but I don't know if it's an option because of the number of customers and dealerships. If I have 70.000 customers and 82 dealerships in 4 different chains it would be a massive calculation. I would have to calculate each customer vs the nearest dealership of each chain.

Or am I misinterpreting the use of 'calculating distance'?