when trying to join a table with lat, long values with Shape file follow below steps .
Add below to the query item.
geography::STPointFromText(‘POINT(‘ + CAST([LONG] AS VARCHAR(20)) + ‘ ‘ + CAST([LAT] AS VARCHAR(20)) + ‘)’, 4326) as loca_geo
join should be Intersects
Join to geometry.
Follow below steps:
select Help → Settings and Performance → Start Performance Recordingfrom the Tableau toolbar.
Then right click on the source in the Data toolbar and select ‘Refresh’. This will force Tableau to re-run the query.
Once the query completes, select Help → Settings and Performance → Stop Performance Recording from the Tableau toolbar.
This should result in a new Tableau window opening with a workbook called ‘Tableau — PerformanceRecording’
Right-click anywhere in the bar next to ‘Executing Query’ and select ‘View data’
Source of the article:
Below URL gives a very good idea about this
1. select abc
2. go to color and change opacity from 100% to 0%. this would hide text ‘abc’
3. now right click on column next to abc, go to format-> Column Divider-> pane-> none
4. now reduce the size of abc column as minimal as possible. so user wont be able to see it.
Create a new blank column with text ‘ ‘. Drag this column and repeat above steps – 3,4.
Detailed video is also available at youtube.
Use below function
geography::STPointFromText(‘POINT(‘ + CAST(longitude AS VARCHAR(20)) + ‘ ‘ + CAST(latitude AS VARCHAR(20)) + ‘)’, 4326) as geo_location
Go to Format > Shading and configure your alternating colors in the “Row Banding” sections. You can adjust the colors as well as how many rows to include before alternating (band size) and at what level in your table the banding should be applied.
Default is 6 columns. To increase number of columns follow below procedure.
At Tableau workbook-
Go to Analysis–>Table Layout –>Advanced and change the number in Rows and Columns as per your need.
You can’t add more than 16 to this, but increase it to 16 (for identification).