1 of 1 people found this helpful
Your problem is solved when you use a filled map.
Hope this helps
That only works where I can use filled maps so for a county, state, postcode sector etc. but in cases where I have a specific point such as an exact latitude and longitude filled maps don't work.
See the attached workbook as an example of what I mean.
Thanks for your response,
Fix Map Axes.twbx 18.7 KB
1 of 1 people found this helpful
Please zoom the area by Selecting Ctrl+Shift+Drag and Press shift to lock on the Map.
Hope this is helpful to you and Let us know if you need further assistance.
Sreenadha Reddy Palakolanu
I think this is an issue as Tableau requires at least 2 points to reference an appropriate level of zoom to use. The only workaround I have found to this is to duplicate all of your data so every point effectively becomes 2 points. Not elegant and obviously if you are working with a large amount of data will be an issue.....
There is an idea here that would be worth voting on https://community.tableau.com/ideas/6568
I ended up doing something similar to your suggestion which gave me a bit of a result. I showed the next nearest point to the point I was filtering on and made this point an invisible shape so you couldn't see it on the map. Not great but it kinda works
Thanks for the link. Will definitely be voting on this idea.
I am trying to duplicate the data as per your suggestion, but didnt quiet get what you mean by that.
I tried creating dummy lat and long fields, which are slightly different than the original location and add them to the view, but then I cant plot the map, the option is disabled.
Am I missing something very obvious?
Sorry, I should have supplied some more details to replicate this.
I have duplicated all of my data and made a very small change to only the Lats of the duplicate copy of the records - i.e. "original lat" + 0.00000000000000001 or something small to make them slightly unique. I also added a column to the data that flagged each record as being "original" or "new" and used this to size the points ("original" size - large, "new" size - small) so when they are plotted the new records effectively appear under the original points so each pair "looks" like one point.
As the duplicated records contain all of the same data as the original (except the different Lat), when filters etc are applied they are all affected together so the zoom works when one point is shown as in reality 2 are actually displayed (one is just tiny and under the large "real" data point).
Anyway, this method is of no consequence when working with small datasets and if you don't mind some manual editing of the input file but this duplication of records would obviously be a problem at scale and is a bit clunky.... would be better solved of course on the software side but in the meantime seems ok as a workaround.
Hope this helps.
Thanks for the tip, after some fiddling around, I could do it after converting lattitude and longitude to dimensions.
Now i need to play around with the amount of distance between the duplicated point and the sizes to get the desired zoom level for each point.
Thanks a lot.
Glad its coming together - see attached for an example of how I have set this up. I have colour coded the records in excel for the original (green) and duplicate (red) records.
Note the longitude for the duplicates is equal to the original longitude plus a small value (see formula in J27 for example). Also note the record ID in A2 is equal to the record ID in A27 - it's just a repeat of all the same data, the only difference is the "status" I have assigned and the longitude value for the duplicates.
In the workbook you can now select from the filter a single ID record and I think you will find the level of zoom is acceptable - note I have assigned "Status" to size to make the new records small and original large etc.
Selecting the data point and looking at the underlying data will reveal there are actually 2 records of course, one is just hidden under the other.
Book1.twbx 28.9 KB
3 of 3 people found this helpful
with the new functions MAKEPOINT and MAKELINE you can solve this without changing the data!
You just create a double axis with the desired point and an invisible line with the desired zoom.
Here is how:
- Create a parameter p_zoom (e.g. with values 1, 0.5, 0.1, 0.01)
- create 4 calculated fields:
- Original point as point object ([point1]): MAKEPOINT([Latitude],[Longitude])
- Two points with the added zoom ([Makepoint-zoom],[Makepoint+zoom] ): MAKEPOINT([Latitude]+[p_zoom],[Longitude]+[p_zoom]) MAKEPOINT([Latitude]-[p_zoom],[Longitude]-[p_zoom])
- A line between these points[zoomline]: MAKELINE([Makepoint-zoom],[Makepoint+zoom])
- Show the field [zoomline] on a map
- Douplicate the generated longitude
- Replace the second [zoomline] field on the detail shelf with the [point1] field
- Change the format of the point as you like (e.g. point instead of automatic, bigger, red) and the format of the line to be invisible (e.g. opacity = 0%)
Lisa, this is a great solution - thank you. I posted a link to your reply on the ideas page for controlling map zoom.
Thanks for the solution Lisa. Is there a way to not display the line created by Makeline() ? I have reduced the color opacity to 0% but if i hover over it, i can still see the line.