Google Map - Date as dimension

[#1]

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)))

[#2 · Accepted solution]

Use average instead of sum.