Ciara Brennan (Tableau)
🌐 Data + Maps Tableau User Group 🌐
Join HERE to be informed about upcoming events
Led by @Tore Levinsen (Member) , @George Koursaros (Member) , @Dennis Kao (Member) & @Tedy Iskandar (Member)
David Browne (Tableau)
For anyone who works with Maps & Geocoding or wants to learn you must check out this excellent Maps & Geocoding FAQ by @Sarah Battersby (Tableau)
It is an incredibly comprehensive collection of resources for Maps & Geocoding. Check it out for yourself. Definitely an FAQ worth bookmarking!
David
Tableau Community
Eliza Hokanson (Member) asked a question.
I created a map using a .shp file and have no background layers selected, however, when I hover over a district, the streets show up. Is there a way to remove that, or to change the colors of the street lines?
Workbook is here: https://public.tableau.com/app/profile/eliza.hokanson/viz/PDXElectionsv2/Map
Lamondo Timms (Member) asked a question.
I've attached my package workbook here.
My dataset has Regions for each set of Lat/Long. So after creating my map I went (right click) Region > Geographic Role > Create From... > State
Then I dragged this Region hierarchy onto the detail marks card to get all the Regions outlined in the map. My intention is to use this Map as a Region selector on the dashboard to filter the bar chart. So, for example, if the Midwest region is selected on the map then the bar chart will only show Midwest numbers (and vice versa - if the user selects a year bar first then the map will filter to only that year's data - this seems to be working). However, when the Region is clicked on it's only passing one set of Lat/Long for the region. I notice even when I hover over a region in the map the tooltip only shows one set of Lat/Long as well.
When I look at the Action Filter I notice it's filtering on fields [Region] [Latitude] [Longitude] so it explains why it's happening, but I don't know how to get all Lat/Longs in each region to pass. I've even tried creating copies of Lat/Long and turning them into dimensions and dragging them into the Region hierarchy but it doesn't work. And I even tried creating a geographic role on Lat/Long from Region but that doesn't work.
Is there any way to achieve this? I've been up all night trying to figure it out, would be a huge help. Thank you in advance!
Best Answer
see the red tab - is this what you expected?
Roy Bleyen (Member) asked a question.
Hello everyone!
This is a rather Beginner-level tableau user trying to map the transport flows of a client for my internship task.
I have the departure and destination longitude and latitudes for each transport separately, along with weight and volume shipped. In an ideal state, I'd like to map all transports so I have a clear visualization where all transports come from and where they go to. This will help me on my journey to find improvements in terms of CO2 exhaust.
I was able to map the departure cities and dragged weight to size. This way, I can see where the largest sum of weight departs. Now, however, I am struggling to add the destinations. If I try to add the destinations, the map will be split in two (in other words, another map will be created with the destinations only, instead of putting them together).
Does anybody know how I can solve this issue?
Thanks in advance and I wish you a wonderful weekend!
Stay safe.
Roy
Best Answer
Hi Roy,
It really depends on what your expected output should look like. That part is unclear to me from your post. You could check out the following for some ideas: Create Maps that Show Paths Between Origins and Destinations in Tableau - Tableau and there might be some useful information on how to use Dual-Axis mapping here: Dual Axis Mapping - Many Ways There are some other resources in the blog if you really want to get into some interesting ideas for mapping departures and destinations Hope it helps! Best, Don
Ridhi Fomra (Member) asked a question.
I created a parameter - [Choose a Metric], with options for Revenue, Profit, Units Sold and Cost of Goods and created a calculated field to switch between the selected metrics based on the parameter using CASE. (CASE [Choose a Metric] WHEN 'Revenue' THEN [Revenue] WHEN 'Profit' THEN [Profit] WHEN 'Units Sold' THEN [Units Sold] WHEN 'Cost of Goods' THEN [Cost of Goods Sold] ENDI tried to add a quarterly date filter to my view, but when I do, I get the error mentioned above.
monica maschewski (Member) asked a question.
Hi,
Is possible to create a graph like in the attachment. Is a mix of columns with Gantt...
do not know if is possible. Any advice? I only could do it with columns...but the blue fields want to have it with Gantt lines...
thanks for any help
Ernest Davidson (Member) asked a question.
Using Tableau Public Desktop 3.0. New to Tableau. Data source is an Excel File with two sheets. One sheet is a set of 20 coordinate pairs defining the vertexes of a BOUNDARY line (path), and a BLEND KEY column with values of 1. The second sheet contains 180,000 coordinate pairs defining VESSEL POINTS, a BLEND KEY column, plus several columns for names, dates and times for each VESSEL POINT. The goal is to display the BOUNDARY line and the VESSEL POINTS on a single map. Both sets of data show correctly if displayed independently. The Excel workbook is connected and the two sheets of data joined by the BLEND KEY
PROBLEM - After successfully displaying the VESSEL POINTS, any attempt to load the BOUNDARY points turns the view from maps, to a scatter graph. Help please.
Best Answer
Hi @Ernest Davidson (Member)
You're attempting to combine a points file and a line (based on points) file. Technically, different types of geometry but as the line geometry is based on points, this is somewhat easy:
1) Create the following spatial calculation. Do not use your own data of Latitude/Longitude directly on Rows/Columns. That was your primary issue. Allow Tableau to generate those fields automatically as shown in the screenshots below.
SLT Points
MAKEPOINT([Latitude],[Longitude])
Notice that when you create this calc, it populates in the field list and automatically adds a Globe icon to the field, as Tableau now recognizes it as spatial. Double-click it to allow it to automatically populate the view or drag the field over to the view. Notice that Tableau uses Latitude (generated) and Longitude (generated) automatically on Columns/Rows? Your points will be populated as before and the map mark type will be Filled Map (the points will be slightly differently displayed than what you have currently, which are circles).
2) Create a new calculation for the Boundary Points. Same calculation as before using MAKEPOINT() only this time it will use your Latitude/Longitude data from that table:
Boundary Points
MAKEPOINT([Latitude (Boundary)],[Longitude (Boundary)])
This time drag the field over to the view (the existing map). Notice that Tableau will highlight up a drop-zone in the upper left corner of the map. This is the Map Marks Layer feature. Drop your new calculation onto that drop-zone. It creates a new card in the Marks Card area. You'll notice that it populates some new points onto the map, but it doesn't draw the line you're looking for as it's displaying Filled Map points as before. Go to the card for the Boundary Points and change the Mark Type in the drop down from Automatic to Line. When you do that, a new option appears. A new button in the card specifically for that field, called Path. Drag Point ID (Boundary) onto the Path button. Then you'll see your boundary line (I've changed the color for clarity):
You should now be able to do this on your own with the instructions/screenshots above. IF you have any problem, come back to the thread and let us know. Best way to learn is by doing...
Please check out our post with some tips on asking a question and how to help you get answers more quickly.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.