Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to figure out a solution for using Lat Long value and city names together in a drill down option in geo analytics.
Earlier I have tried using state name and city names of a country in drill down option by creating a Drill down group and succeded.
Now I need to use Lat long position of city and state names in a drill down option. while trying i'm unable to get the appropriate result.
Could any expert help me solve this?
Below is the Lat Long value for each state.
LOAD * INLINE [
Place Name, Lattitude, Longitude, ID
"Himachal Pradesh, India", 32.084206, 77.571167, 1
"Telangana, India", 17.123184, 79.208824, 2
"Madhya Pradesh, India", 23.473324, 77.947998, 3
"Haryana, India", 29.238478, 76.431885, 4
"Chhattisgarh, India", 21.295132, 81.828232, 5
"Haryana, India", 29.065773, 76.040497, 6
"Bhitarwar, Madhya Pradesh, India", 25.794033, 78.116531, 7
"Maharastra, India", 19.601194, 75.552979, 8
"Tripura, India", 23.745127, 91.746826, 9
"Chandoor, Telangana, India", 17.874857, 78.100815, 10
"Karnataka, India", 15.317277, 75.713890, 11
"Kerala, India", 10.850516, 76.271080, 12
"Uttar Pradesh, India", 28.207609, 79.826660, 13
"Assam, India", 26.244156, 92.537842, 14
"Maharashtra, India", 19.663280, 75.300293, 15
"Tamil Nadu, India", 11.127123, 78.656891, 16
"Karnataka, India", 15.317277, 75.713890, 17
"West Bengal, India", 22.978624, 87.747803, 18
"Gujarat, India", 22.309425, 72.136230, 19
"Odisha, India", 20.940920, 84.803467, 20
"Rajasthan, India", 27.391277, 73.432617, 21
];
City names are directly from excel.
Hi,
What is the structure of your table ?
to be able to drill down, you should have: Country, cityname, Long lat
its 2 seperate table. City name comes in excel and Inline table for Lat Long Values.
As far as I know we should create a Drill Down Group with Latt Long & City Name and use it as Dimension in the Chart layer.
But creating a Drill down group is not working with different data set.
you should at least link (join) the tables ! otherwise the drill down will not work.
did you join the tables ?
Yeah thats is done. ID field is the link between 2 table
Try to use this drill down group on a simple table to see if it is working well.
if it don't work, try to attach sample app (QVF) with these 2 geo-tables
forget Different composition of datas in Drill down.
Is it possible to use "Long Latt" data of State and "Long Latt" data of city in a drill down chart layer?