I have a google map created using a scatter graph.
My data looks like excel file table attached.
The issue I keep running into is that since I have multiple longitude/latitude values for the same area, my expression SUMS them together if I don't have a date selected. I want to be able to see all data points, regardless of date, but be able to narrow down to a date if necessary.
How can I modify the expression to stop this from happening? I was thinking I needed to add an aggregate to it but I'm not sure how.
my latitude and longitude expression formulas are as follows:
sum( round (256*pow(2,($(var_zoom)-1)))+(