Forum Discussion
Too many values error in map
This is an interesting problem. What if you didn't get that "too many values" error? Would the display of all those bunched up little circles help you? If you zoomed out, there would be circles on top of each other. If you zoomed in, maybe you would need a gigantic monitor to be able to view them separately.
How about two maps? With one you could zoom the other. Read about it here: http://tinyurl.com/pb372qn.
I thought of this solution with a drill down reporrt asocorro already, unfortunately the data relate to Germany and there is no state / region to use to break it down further. Indeed with high zoom all is drawn on top of each other so it does not give any info, but it's to be used with high zoom for field sales trip planning as mentioned... this is the idea at least.
The problem is that with zoom change the dataset is not refreshed, so indeed, I do not mind not seeing couple of hundreds points in top zoom where they all just create one big spot.... but when zoomed down they need to be shown. Would it be possible to refresh for data just in the area shown then it is all sorted ofcourse as theer can be around 20 or so points.. but that is not the case unfortunately... I'm probably trying BIMap to do something it has not really been designed for. Should the data be somehow consolidated, theer is no problem, but as it is customer level I'm breaking it on and so many customers.... here we are. :smileyindifferent:
pinky - What is the location data, is it city or geocoordinates or something else? Thought would be that you could create a calculated column that essentially consolidated the data in some manner where everything in a certain area all has the same location code for example?
Can't you create another filter in addition to the ABC? Say, city, customer business type, or salesperson? You could also resort to a map in R, where you can have more control over the map details.
