Tim I am struggling with Tableau not recognizing a small (i.e., 250 rows) data set of North Dakota oil and gas wells even though the Lat-Lon are formatted correctly and Geographic Roles of both are correctly formatted in data. Thoughts?
You shouldn’t need it to recognise rows if you have the lat longs. You either use tableau’s gecoding or you use your own lat longs for the locations. If you build using tableau gecoding double click the colour. That has location if it doesn’t map it right click the colum in data column and apply geographic roles. If any locations are ambiguous it will need country or region info. Only towns over 100k population will be recognised you can manually set the reminder. Alternatively you put the location name on detail, double click lat and double click long. You should get a point map. Make sure the lat and long columns are recognised as spatial data tupes
@@TableauTim I've assigned the correct geographic roles to both Lat and Lon columns. They are in decimal degrees and NAD 1983. Is it a problem of projection? Some of the Lat-Lon seem to be aggregated and they are aggregated in the correct 6-7 counties in North Dakota BUT the individual well Lat-Lon are not so it looks like a map with the Lat-Lon of the centroids of each county.
@tedauch3004 yes it is an issue. There’s function to process the projection. It creates points based on your lat and long. If you know the code for the projection you can place that in the function. help.tableau.com/current/pro/desktop/en-us/functions_functions_spatial.htm there’s a link in there on the make point function to codes
@@TableauTim Any chance i could pay you to do a screenshare at some point cause at this point I can't seem to see what is wrong. I am using decimal degrees and projections I have used dozens of times in Tableau with no problem.
You need a data model. Tableau doesn’t have anetwork days function. The other way to do it is a very annoying formula that checks for days of the weeks and has context for bank holidays etc again very clunky
Not sure if you are still answering this video but here we go: I started displaying a chart with companies by country. For US map I would like to also display it by state, but only if the user clicks in the US or filters it. Any guidance?
hello tim i have one question .. i want to hide particular table and particular column in tableau server or online for client side user... is it possible please let me know .. or if possbile please help me out
Hey! very helpful, I just have a question that I can't seem to get the answer to. I have a map with the total money spent on something, and then I want to dissect the info into which industries are spending more by state. But I don't know how to do it. Could you help me
You can’t do that on a map. A map means you’re locked into geography so the only thing you could do is maybe make a nasty pie chart on each region on the map. Alternatively you could look at trellis charts and represent the info that way bits far more advanced than this video. It’s down the road of customs charts. Tableau public will have some good examples you can find.
good day sir , well i suffer from fixing my data location in my tableau ... i have a hirorchy of country / state/ city/postal code , all of them are recognized geographically unless the city wich I do not know why , but no matter how I try to edit the location it just does not work so what should I do !! this map location editing thing is driving me insane
Built it it depends on the country and location and what you mean by sub district. That has a different meaning in every country. As an example subdistricts aren’t a thing. We have country, nation, county, council, postcode as a rough hierarchy. Also if tableau doesn’t you can grab a data set that does and map it yourself using spatial capabilities. Marc Reid has some great videos on TH-cam.
Hi Tim can you pls display the continents wise total sales
Thank you for this very interesting video 😀
very helpful thanks
Awesome !
Tim I am struggling with Tableau not recognizing a small (i.e., 250 rows) data set of North Dakota oil and gas wells even though the Lat-Lon are formatted correctly and Geographic Roles of both are correctly formatted in data. Thoughts?
You shouldn’t need it to recognise rows if you have the lat longs. You either use tableau’s gecoding or you use your own lat longs for the locations. If you build using tableau gecoding double click the colour. That has location if it doesn’t map it right click the colum in data column and apply geographic roles. If any locations are ambiguous it will need country or region info. Only towns over 100k population will be recognised you can manually set the reminder.
Alternatively you put the location name on detail, double click lat and double click long. You should get a point map. Make sure the lat and long columns are recognised as spatial data tupes
@@TableauTim I've assigned the correct geographic roles to both Lat and Lon columns. They are in decimal degrees and NAD 1983. Is it a problem of projection? Some of the Lat-Lon seem to be aggregated and they are aggregated in the correct 6-7 counties in North Dakota BUT the individual well Lat-Lon are not so it looks like a map with the Lat-Lon of the centroids of each county.
@tedauch3004 yes it is an issue. There’s function to process the projection. It creates points based on your lat and long. If you know the code for the projection you can place that in the function. help.tableau.com/current/pro/desktop/en-us/functions_functions_spatial.htm there’s a link in there on the make point function to codes
@@TableauTim Any chance i could pay you to do a screenshare at some point cause at this point I can't seem to see what is wrong. I am using decimal degrees and projections I have used dozens of times in Tableau with no problem.
hi , can you please share how can we calculate network days between 2 date field in tableau prep, excluding holidays & weekends also
You need a data model. Tableau doesn’t have anetwork days function. The other way to do it is a very annoying formula that checks for days of the weeks and has context for bank holidays etc again very clunky
Not sure if you are still answering this video but here we go:
I started displaying a chart with companies by country. For US map I would like to also display it by state, but only if the user clicks in the US or filters it. Any guidance?
Hi..if I want to countd from a table and divide sum total from table b..can it be done
hello tim i have one question .. i want to hide particular table and particular column in tableau server or online for client side user... is it possible please let me know .. or if possbile please help me out
Hey! very helpful, I just have a question that I can't seem to get the answer to. I have a map with the total money spent on something, and then I want to dissect the info into which industries are spending more by state. But I don't know how to do it. Could you help me
You can’t do that on a map. A map means you’re locked into geography so the only thing you could do is maybe make a nasty pie chart on each region on the map. Alternatively you could look at trellis charts and represent the info that way bits far more advanced than this video. It’s down the road of customs charts.
Tableau public will have some good examples you can find.
good day sir ,
well i suffer from fixing my data location in my tableau ... i have a hirorchy of country / state/ city/postal code , all of them are recognized geographically unless the city wich I do not know why , but no matter how I try to edit the location it just does not work so what should I do !! this map location editing thing is driving me insane
hello bro. i have question. can tableau access to the sub-district area?
Built it it depends on the country and location and what you mean by sub district. That has a different meaning in every country. As an example subdistricts aren’t a thing. We have country, nation, county, council, postcode as a rough hierarchy. Also if tableau doesn’t you can grab a data set that does and map it yourself using spatial capabilities. Marc Reid has some great videos on TH-cam.
Tim, Tableau doesn't have London Borough maps...just the zip codes.
Zip codes, counties, airports, cities and NUTs www.tableau.com/mapdata
@@TableauTim That's great Tim..Book marked the link and will give it another shot ! Thank you !
You can bring in London boroughs as part of your data set. Just grab spatial files from a government website and plug it in.
those are provinces