-
1. Re: Polygon and exporting question
lenaic.ridingerJun 1, 2017 7:42 AM (in response to Calum Handforth)
Hello Calum Handforth,
This is surely possible!
To be more precise, can we use your polygon shape on a map (region)? Then a simple lasso to select the data points within this shape would work.
Any workbook and the shape would help
----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
-
2. Re: Polygon and exporting question
Calum Handforth Jun 1, 2017 8:43 AM (in response to lenaic.ridinger)Thanks for the reply!
Please find attached the polygon (in the .tde file) and the data. I'd like to use Tableau to identify (for example, through a csv export) which of the data points fall within that polygon. How would I go about doing this?
Thanks!
Calum
-
TestData.csv.zip 8.2 KB
-
BexleyTest.tde.zip 9.8 KB
-
-
3. Re: Polygon and exporting question
lenaic.ridingerJun 2, 2017 4:14 AM (in response to Calum Handforth)
Hai hai Calum Handforth,
Excellent, can I have a .twbx instead of a .tde please? So I can left join the two database
That's really exciting stuff (not much, but I like to work with maps). I can have the two maps next to each others, check my attachment, but I can do better and superimpose them with a .twbx.
It looks like only Id 767 is within the polygon shape.
-
Calum Handforth Polygon coord.twbx 120.6 KB
-
-
4. Re: Polygon and exporting question
Calum Handforth Jun 2, 2017 5:28 AM (in response to lenaic.ridinger)Hi Lénaïc!
This is looking really interesting. I've attached a Workbook here, and would really appreciate it if you could explain to me how you identified that ID767 was within the polygon shape (and how you went about putting this together, particularly superimposing the polygon onto the data)
Thanks!
Calum-
TestWorkbook.twbx 36.0 KB
-
-
5. Re: Polygon and exporting question
lenaic.ridingerJun 2, 2017 6:42 AM (in response to Calum Handforth)
So... I'm really sad to tell you that this is a feature request. However! However, this is progressing well.
One workaround would be load the shape directly in order to create a layer.
The idea. Please upvote and comment it. Our developers regularly check the ideas, comment, and interact with our users.
https://community.tableau.com/ideas/1492
To find the ID 767, I have awkwardly created the same zoom level on both maps in the Dashboard, then aligned the two maps together, and checked if there was any data point in the shape. 769 is close, but not in the shape. Looks like a 5km away to me, roughly.
Again, I'm sorry I haven't been able to solve your query, but I do hope that you have enough details to continue your work.
Let me know if you have any question, and don't forget to click on the helpful and correct buttons please. It helps us and the users better find threads for their issues.
Cheers!
-
6. Re: Polygon and exporting question
Calum Handforth Jun 2, 2017 6:44 AM (in response to lenaic.ridinger) -
7. Re: Polygon and exporting question
lenaic.ridingerJun 2, 2017 6:54 AM (in response to Calum Handforth)
Sure thing,
The following link is a great step by step: Re: Adding a data layer to Polygon Map
More details about the spatial files in these: video or text tutorials.
-
8. Re: Polygon and exporting question
Calum Handforth Jun 2, 2017 7:20 AM (in response to lenaic.ridinger)Thanks Lénaïc Riédinger, however I don't think that's going to work as I'll have to manually count all of the data points that fall within the polygon (and there's quite a few!) unless I've missed something?
Also, when searching the forums, I found this topic: Re: Create polygons and count booking id in the polygons
Is that at all useful? What are your thoughts?
-
9. Re: Polygon and exporting question
lenaic.ridingerJun 2, 2017 7:29 AM (in response to Calum Handforth)
Yes that would be too much, I assumed you provided me with dummy data; I was just checking if I could do something by bringing the maps closer.
It would be useful, yes. I've never done this myself but I'd be curious to see how does your map look afterward.
Let me know how it goes.