Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to add google maps (particular country) in Scatter chart.
I need only India with states and cities.
I tried below code but it is showing different country.
Please help me out.
// Google Maps Key gmap_key = ''; max_zoom_level = 14; def_zoom_level = 7; def_map_size = 400; // Variables required for calculating map var_pi180 = '=pi()/180'; var_lat_offset = '0'; var_mc2 = '=256*pow(2,$(var_zoom))'; var_mc1 = '=256*pow(2,($(var_zoom)-1))'; var_mid_lat = '=median(latitude)'; var_mid_long = '=median(longitude)'; var_zoom = '=if(max(aggr(if(max(round(256*pow(2,(_zoom_level-1)))+(Longitude*((256*pow(2,_zoom_level))/360)))-min(round(256*pow(2,(_zoom_level-1)))+(Longitude*((256*pow(2,_zoom_level))/360)))<def_map_size AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<def_map_size,_zoom_level,null()),_zoom_level))>def_zoom_level,max(aggr(if(max(round(256*pow(2,(_zoom_level-1)))+(longitude*((256*pow(2,_zoom_level))/360)))-min(round(256*pow(2,(_zoom_level-1)))+(longitude*((256*pow(2,_zoom_level))/360)))<def_map_size AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<def_map_size,_zoom_level,null()),_zoom_level)),def_zoom_level)'; var_maptype = '=if(isnull(only(maptype)),fieldvalue('&chr(39)&'maptype'&chr(39)&',4),maptype)'; // Calculate best zoom level set HidePrefix = '_'; _zoom_level: LOAD RecNo() as _zoom_level AutoGenerate(max_zoom_level); maptype: LOAD * INLINE [ Maptype roadmap mobile satellite terrain hybrid ]; Colors:
Dynamic Image:
'http://maps.googleapis.com/maps/api/staticmap?center=' &var_mid_lat &',' &var_mid_long&' &zoom=$(var_zoom)'&' &maptype='&var_maptype&' &size='&def_map_size&'x'&def_map_size&' &sensor=false'
Thanks,
Krishna.