Video

Hi - It's quite difficult to debug that kind of issue here in the comments. I'd recommend posting on the Tableau Forums where you can also upload your workbook as it will be much easier for someone to diagnose. Thanks. community.tableau.com/s/explore-forums

I no longer have the exact links as this was some time ago, but from the linked page is you search for these you should find them or similar data sources: 1. Admin Areas (polygons). 2. Roads and streets (lines). 3. Educational facilities (points)

Thanks! Glad it was useful.

Thanks for the kind words. You could put a count of facilities on to the tooltip of the admin area layer, then when you hover you'd see that number. Hope that helps.

@@MarcReid Thanks a lot !

It's not possible to adjust the arc that Tableau creates between two specified points. It's generated algorithmically

Hi - It's quite difficult to debug that kind of issue here in the comments. I'd recommend posting on the Tableau Forums where you can also upload your workbook as it will be much easier for someone to diagnose. Thanks. community.tableau.com/s/explore-forums

something like: IF value>5 THEN [GEOGRAPHY] ELSE NULL END. If that doesn't work / not what you meant, then I'd recommend posting on the Tableau forums with an example workbook.

@@MarcReid yes sir, that worked. Thank you!

Hi Tom, it's difficult to debug these kinds of issues here. I'd recommend posting on the Tableau forums and attaching a packaged workbook. It will be easier for someone to explore the issue in detail. Thanks. community.tableau.com/s/explore-forums

Thanks! Glad to hear it was useful

Hi Nicccy - yes, you need two sources to make the join. Can you separate the data out into two separate sources? If not, you could duplicate the source - connect to it twice - and filter each source to the relevant data then make the join. Hope that helps.

See this blog post for more on using images in Tableau. Hope it helps! datavis.blog/2020/12/24/five-ways-to-use-images-in-tableau/

Great to hear, James!

Glad it helped!

Thanks! Glad to hear it was helpful.

Hi - yes, I think a self join would be the way to go. Essentially it's a row level calculation so both points to be on the same row.

@MarcReid Thank you very much for this tutorial, although it has been online a while, it is extremely helpful. And this comment is extremely important, because I got the impression from other tutorials that it is possible do to these calculations with different rows. However, I tried to check if there is any point within a (rather large) series of overlapping buffers and failed. Due to the multiplication in the intersects this seems to be tricky, because every buffer have true and false intersects. Has anyone an idea how I can identify the buffers with no points within a defined range?

Hi Adolfo - thanks for the kind words. You should be able to use an outer (or right) join to include those points that don't intersect. If you still see issues, I'd recommend posting on the forums along with your workbook so someone can take a closer look. Hope that helps.

I'm not really sure what the issue is here. I'd recommend posting the question on the Tableau forums where you can also upload your workbook for the best support: community.tableau.com/s/explore-forums

Hi - I'd recommend posting this question on the Tableau forums: community.tableau.com/s/explore-forums

Thanks!

Hey Alain, thanks for the comment! Great to hear it was useful.

Please can you confirm what you mean? thanks.

After you added the third layer on the map, you went on to disable selection on the map (time: 05:45). I created a dual-axis map on my worksheet in Tableau, but the layer of the map I imported from a spatial data (shapefile) is still enabling selection. How do I disable the selection? The version of the tableau I use is 2023.1.0. Thank you. @@MarcReid

@@MarcReid After you added the third layer on the map, you went on to disable selection on the map (time: 05:45). I created a dual-axis map on my worksheet in Tableau, but the layer of the map I imported from a spatial data (shapefile) is still enabling selection. How do I disable the selection? The version of the tableau I use is 2023.1.0. Thank you.

Thanks for clarifying. at this time stamp (6:06) czcams.com/video/ppo3d9HFMrc/video.htmlsi=NZ84EuD6KkbzhwJH&t=362 I select "Disable selection" from the drop down menu. Are you seeing that option?

@@MarcReid Thank you so much for your response, but the drop down option is not available in my Tableau version which is 2023.1.0. How else can I go about it? Thank you.

Great to hear. Glad it was useful.

Hi Scott, thanks for the kind words - much appreciated. It will depend on your data and how you've configured the join (inner, left, outer), but if a point meets the join criteria for multiple buffers, you'll get multiple rows. To ensure the True rows are on top, you might need to reorder the values in the colour legend (top right in the video), you can click and drag them. Hope that helps. If not, the best thing to do is open a case on the Tableau forums so the workbook can be shared (community.tableau.com/s/explore-forums), there's generally a very quick response.

@@MarcReid Thanks for the quick response man, made me an instant subscriber. Yeah I'd suspect something must be going on with my joins. When I make the "In Range" field a filter and have it set to true, the color's reflect appropriately along with the accurate distances being displayed. However, when I set it to All, the distances get really wonky and begin to calculate for other locations rather than the one it's "within range" of I'm guessing. I'll go ahead and try to switch away from an inner join if that works. What do you mean by "To ensure the True rows are on top, you might need to reorder the values in the colour legend (top right in the video), you can click and drag them"? in case you have another moment?

​@@scottgill1515- the odd numbers you are seeing might be the aggregation of values for the dupe rows. (see this timestamp for more: czcams.com/video/pqb6RMGFVl0/video.htmlsi=5RNz5uDjy1R-aIlg&t=500). re the colour reordering, if you have one point in range of one buffer but out of range of a second buffer (true and false), those two points will overlap on the map so you'll true or false on top depending on the z-order depending on how the colours are sorted, which you can change by dragging the colours in the legend to change. Hope that makes sense.

@@MarcReid You are the smartest man alive!! No fix needed with the join just needed to re-order the color legend like you suggested haha. Have no idea how you figured that out but it's awesome. I appreciate you so much!

@@scottgill1515 - 🙂 Happy to help.

I haven't looked at this data in a long time but I'll assume there is a flight Id field there in which case you could create a calc: COUNTD(Flight_ID) and put that on the tooltip. Alternatively, you could create a bar chart showing the number of flights between each origin and destination and use that as a viz-in-tooltip, filtering on the origin when you show the tooltip. (see Tableau's help page on viz in tooltip to learn more).

Hi - see this help page for a screen shot and description: help.tableau.com/current/pro/desktop/en-us/annotations_marklabels_showhideworksheet.htm#format-mark-labels:~:text=click%20Match%20Mark%20Color

@@MarcReid Oh, it worked 'Match Mark Color'. Thanks a lot, data community is splendid!

You are amazing

That's great to hear. Thanks for the feedback.

Thanks!

@@MarcReid Is there a way to make the arrows straight and to see the direction of the arrows ?

@@lavaforce-overwatchmoments9848 - the lines will always be curved to represent the curvature of the earth, though this will be less noticeable for shorter distances. you could create a new map layer with spatial points to indicate the start of the lines (use the same lat/long you are using to create the lines).

Hi - the layer control was introduced in 2021.2. See this video for more info: czcams.com/video/g6Ikidt8taQ/video.html

Thanks. Row ID is a unique value for each of the data. A mark is how Tableau renders data in the view - it could be a bar, line, circle or shape for example. That counter tells you how many marks are being rendered in the view.

I think this forum post will help guide you in the right direction: community.tableau.com/s/question/0D54T00000C5yWvSAJ/time-difference-is-displayed-as-negative

It's hard to say without seeing your workbook. Feel free to download the workbook at the link in the description to see a working example.

Hi - thanks for the feedback. Spatial joins can be slow if you're working with a lot of data especially if points are contained within multiple buffers as you are then creating multiple rows for each point. If you can pre-filter that data that would help. For further help it's best to post a workbook on the Tableau forums where someone can then take a look.

I'd recommend posting on the Tableau forums, Ahmed. You're welcome to tag me but most likely by the time I see it someone will have already answered. community.tableau.com/s/explore-forums

If you have a file with latitude and longitude points, this is the calc: BUFFER(MAKEPOINT([Lat],[Long]),20,"miles")

Thanks. One way to do that is to use a parameter in a calculation and return your spatial object based on the parameter selection. For example: IF p.Select_Layer = 1 THEN [My_Spatial_Object] ELSE NULL END. And drag that calc onto the view as a map layer. It will then only show when the parameter is set to a value of 1.

Thanks a lot, Jen. That's much appreciated and I'm glad it was helpful. All the best!

Thanks. No, for the Intersects function it needs to be the same data source. But you could make a spatial join with your two data sources. See this video for an example czcams.com/video/MXquD73rnic/video.html

Hi - Please see the earlier comments with links to data. You can also download the workbook and extract the data from that.

Hi - It's not totally clear to me the scenario you're explaining, however, if your point is within range of two buffers then the spatial join will result in two rows. You then need to determine which of those you want to use - for displaying the distance or whatever. If this doesn't help I'd recommend sharing your workbook on the Tableau forums for more specific help.

@@MarcReid Thanks for the reply, I will try to refine the case. A point that is closer to buffer 1 and is within its radius, is not considered part of buffer 1. For example: the condition I created as in your example "within range" does not show it as being within the range, and the distance actually refers to buffer 2, which is further away. As soon as I change the parameter and increase its radius to the maximum (I did as in your example - 500 m), and both buffers contain the point, then the data of the point correctly refers to the buffer closest to it - buffer 1.

@@roiargaman850 - I'd suggest making a post on the Tableau Forums where you can also upload your workbook as it will be much easier for someone to diagnose. Thanks. community.tableau.com/s/explore-forums