Forum Discussion
Count filter in Map
Hi Cahaba,
thank you for your help so far. I created a seperate Table with my Distinct Lat2 values (i'll do the Lat&Lon combo later).
Unfortunately i couldn't follow your last step. Could you please specify?
Attached you can see the visuals I'm building. The first image shows all my datapoints (Lat, Lon). In the second image I used my Lat2/Lon2 coordinates.
I want to build a filter that allows me to exclude small clusters (e.g. less than 5 datapoints) in my map.
Memorable MemberBefore the map visual one must first establish the correct data set. So you'll want to work in a table visual as an interim step.
I suggest that the new calculated merged column LatLon2 is the field that should be used as the basis for counting rows - but you know your data better than I and if you think another field will always be valid go for it. For now lets call it LatLon2
But you want to look at some examples of COUNTROWS - and create a measure that you can add to your table visual that counts how many rows/times the same LatLon2 appears/exists. Call this CountLatLon. So for instance your first 3 rows this new column CountLatLon states 3 on each row, then next 2 rows states 2, then 1, then 1, then 2, etc
Once this exists - then you have a basis to apply a filter for the value of CountLatLon.