Forum Discussion
Map visual overlapping event coordinates resulting in incorrect data values
I am using the map visual to display bubble points reflective of user events occurring across various geographies at different dates. However, in this case the events logged may occur in the exact sa...
Please find a mock table of the dataset that covers my issue below:
| count | short_date | threshold | lat | lon |
| 5 | 2021-08-02 | "5 +" | 39.5 | -98.35 |
| 3 | 2021-07-20 | "2 - 3" | 39.5 | -98.35 |
| 5 | 2021-07-13 | "5 +" | 39.5 | -98.35 |
| 5 | 2021-06-29 | "5 +" | 39.5 | -98.35 |
| 4 | 2021-06-08 | "4" | 39.5 | -98.35 |
| 4 | 2021-06-15 | "4" | 39.5 | -98.35 |
| 3 | 2021-08-10 | "2 - 3" | 39.5 | -98.35 |
| 8 | 2021-08-24 | "5 +" | 39.5 | -98.35 |
| 3 | 2021-06-22 | "2 - 3" | 39.5 | -98.35 |
| 4 | 2021-06-03 | "4" | 39.5 | -98.35 |
| 7 | 2021-08-31 | "5 +" | 39.5 | -98.35 |
I don't have a screenshot of an expected outcome, but rather looking for potential input on how to appropriately handle the occurence of these overlapping points. I desire to be able to use the threshold attribute as the legend to color the bubble points. In my second screenshot above, the user would be led to believe that on June 29th there was a count of 30 that occured. This would be incorrect as on that date only a count of 5 was logged and the 30 is a product of summing the count across multiple dates that the user cannot identify currently as is.
It depends which part of the pie chart you hover over.