Hello All,
I am having difficulty plotting the data points correctly. I have the Google map script showing correctly but my Latitudes/Longitudes that are in North America territory appear all over the world. Clearly something is off.
I have used the following expressions:
Lat -
=sum(
((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((LONGITUDE)*pi()/180)))/(1-(sin((LONGITUDE)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi()))))
)
Long -
=sum( round (256*pow(2,($(var_zoom)-1)))+( LATITUDE *((256*pow(2,$(var_zoom)))/360)) )
and my dimension is a drill down group that consists of country-state-city-name
can someone help me determine what i am doing incorrectly?
thanks!