Hello, I am looking for some experienced people using azure maps.
I am trying to show some geographical information on my dashboard for the Netherlands and Belgium. The data that I have available does not contain any longitude or latitude. Since the latest Azure maps update, this should not be a problem anymore.
The data that I have contains shipments that are delivered (mainly) in The Netherlands and Belgium. For each country, I would like to create a separate page by using country = "The Netherlands" and country = "Belgium" as a filter.
The table that I am using is as follows:
| ShipmentID | DeliveryPartner | Postalcode | Country |
| 3957823 | a | 8041AL | The Netherlands |
| 3957824 | a | 8071DA | The Netherlands |
| 3957825 | a | 7609PK | The Netherlands |
| 3957826 | b | 8102HE | The Netherlands |
| 3957827 | b | 2000 | Belgium |
| 3957828 | c | 7951NG | The Netherlands |
| +974.812 rows | | | |
Desired result:
I would like to show the total amount of shipment delivered, coloured by DeliveryPartner for Belgium and The Netherlands (two pages in total).
What I achieved:
Currently, I made a custom column: "0000, The Netherlands" (0000 = first 4 digits of the postal code). Apparently, TomTom understands this data and is able to show the data in azure maps. However, because there are so many deliveries in a month, the map is not able to load all dots and decides to show nothing at all.
To achieve fewer data points I thought about using only the first two digits in the postal codes of the Netherlands. This is a common solution, but TomTom does not understand which city and region are supposed to be shown.
Question:
Is it possible to show data in the Netherlands by using an incomplete zip code?
What should the proper format of the zipcode/country be in a column for azure maps to understand it?
Is there any other smart trick that I can use?
Additional information on postal codes in the Netherlands:
"The first two digits indicate a city and a region, the third digit represents the location and the fourth digit represents the district. The first letter indicate the delivery area and the second letter indicate the subdivision of delivery area. Consequently, a postal address is uniquely defined by the postcode and the house number. On average, a postcode in the Netherlands comprises eight single addresses."
Thanks in advance!
