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:
latitude:
=
sum(((256*pow(2,($(var_zoom)-1)))+((0.5*
log((1+(
sin((
latitude)*
pi()/180)))/(1-(
sin((
latitude)*
pi()/180)))))*((-256*
pow(2,
$(var_zoom)))/(2*
pi())))))
longitude:
=
sum( round (256*pow(2,($(var_zoom)-1)))+(
longitude *((256*
pow(2,
$(var_zoom)))/360)))
