Can you provide your sample data or workbook?
Thank you for replying.
Well, the previous data was confidential, so I have narrowed it down but now 'am not getting any issues with the longitude but still all 'am getting is a point on the map instead of pack of regions.
(Note - before the data contained 70424 records but now 50)
1. Kindly explain why was I getting the previous issue.
2. Please resolve the recent issue.
Thank you replying.
I have attached the mock up data in the reply mail. Kindly find the attachment.
More over, I want to show the places in the regions (south mumbai, west mumbai, central mumbai etc. as a heat map), so that I can select the places and drill down to next level of selection.
Thank you for the suggestion but I am looking for bit deeper operation than that.
In tableau the least granularity it comes to is the city level. eg. Mumbai is a city in the state Maharashtra but I am going further to show the regions of Mumbai (south mumbai, west mumbai, central mumbai etc. as a heat map), so that I can select the places and drill down to next level of selection.
Yes Mafooj. This is exactly what I am looking for. Kindly share the process.
Thanks for the confirmation.
Here we go,
First thing you need to understand the territory hierarchies of our Country and roles for each one. In our country demarcation of territory fields are Country>States>Districts/Cities>Postal Codes>Streets>Ward etc like that. So, when we've any of these information in our source data then we've maintain the domain like State information should be in State/Province field only or District/city should be in the same field. So that when we connect the source in tableau, field can be assign to respected geographical roles accordingly. If not then we've to manually set the roles.
In your case what I observed from your sample source there is a field called State. When I saw the underlying value of State it is showing Mumbai Total . First neither its a state nor city name. In the field State values should be Maharashtra and there should be a different field for City having value Mumbai only. Once you have these territory details in your source. Then it'll be very easy for your visualize these information in tableau.
Another point I wants to clear about the co-ordinates (Latitude and Longitude) can only represent as a dot in a map for drawing a polygon which area of that particular location you have to have GIS spatial data, spatial (.shp) data is nothing but collection of latitude and longitude of that location. So with co-ordinates you can only have dot plot on map. For filled map you should have proper territory details like State/District ect. City will be represented as dot only.
I hope you have brief idea about mapping
Now come to your expected view.
First thing what I did
I created a field called District using below logic. I'll not recommend this in your original source. You have to standardize your field values properly before coming to tableau. Its important, so that field values can be searched easily in google map to draw the polygons.
Then I have set the geo-role of District as County.
Once done then I've used dual axis on your co-ordinates to draw filled map for district and overlay Mini Regions as dots
Then little formatting and you'll get your expected view. Workbook attached for your reference. Let us know if this help.
geo dashboard_v10.5.twbx 24.5 KB
Thank you so much for the solution. It modified the my thought process for designs.
There are few things I want to mention. The mockup data I provided was a part of data from the client, for confidentiality I picked up only those fields which were needed from the whole data and the latitude and longitude was not provided, I searched it from Google and put it there.
Again please rectify me if I am wrong.
So according to you, we can not portray the map as a heat map by using lat and long, right?
More over can you explain more about the spatial data? (it will be helpful if you can attach a sample dashboard for that)
My whole moto to stretch this discussion was to get a solution where I could show a heat map for different parts (like south mumbai, central mumbai etc) in the map, further selection of which would lead you to the relative dashboards.
Kindly suggest me if you have some other solutions.
Thanks & Regards,
Thank you for the solution but this was the point where I started.
1. Yes! We can't create a filled map from co-ordinates (latitudes and longitudes).
2. You can find several sample dashboard in public gallery on spatial maps. However to begin with I'd recommend to follow these kb articles. Go through these thoroughly, I hope you'll get fair idea from these articles.