Drill Down in Google map (Region to District)

[#1]

Hi All, Please suggest how we can show drill down functionality in google map. I have the lat and long for District. In the attached file district sales is coming correctly. But we need to show drill down functionality. I have created a Group (Region/District) and named it as GEO, when i am draging the GEO in the dimention nothing is coming. Regards, Manish Virmani

[lironbaram]

basically your problem is you don't have one value of longitude and latitude for the regions

you'll need to create them in the script

and to create all related expressions and variables  to the new fields

[#3]

hi Liron, SO do we need Region Lat Long , District Lat Long. Once we have Region Lat Long then in Expression Latitude, do we need to use if condition. How that will work, not sure. Regards, Manish Virmani

[lironbaram · Accepted solution]

hi

have a look at the attached example i created a new map for regions

and added on the script new variables for the regions map

in the map layout i defined the region map to appear when there is more than one region

and the district map when there is one region

[#5]

Hi Liron, Thank you so much. Can we also control the bubble color intensity. Like higher the Market share darker the color?. Regards, Manish Virmani

[lironbaram]

yes

you can have a look at the attach file

[#7]

Hi Liron Thank you! What and where you changed? Regards, Manish Virmani

[lironbaram]

Hi Manish

i changed to background expression for the longitude expression in the chart