convert [year] column to date

convert [year] column from excel to date

DATEADD('year', INT([Year])-1900, #1900-01-01#)

https://community.tableau.com/message/235385

Favorites Blog for Tableau layout

http://vizcandy.blogspot.ca/

http://www.vizwiz.com/p/makeovers.html

Origem/Destination Map

https://public.tableau.com/s/gallery/los-viajes-de-la-comitiva-de-boudou-en-2012
 

Exchange map view

 

https://public.tableau.com/s/gallery/boston-bike-share-trend

Color individually the cells using containers - tableau

https://www.youtube.com/watch?v=w2nlT_TBUzU

Time durations - More/ less 24h

http://drawingwithnumbers.artisart.org/formatting-time-durations/

Transform string date to date format in Tableau

1. Duplicate the date dimesion (string)
2. Right click and "Change date type">>>> Date & Time  >> Ok
3. Right click and "Default Properties">>>> Date Format  >>  Custom >>> add "hh:mm:ss.000"

Removing "Abc" Placeholder Text



Sometimes the ABC from the right of the view annoying me.  Tableau Techinical Support sent me the workaround. There are actually two potential ways to get rid of the ABC from the right side of the view, I prefer to use the "Blank"

 

Create a calculated field

Create a calculation that will act as an invisible placeholder field.

 

Step 1 

 Create Calculated Field.

 

Step 2 

In the Create Calculated Field dialog box, type the following:

1. Give the calculated field a name as Blank.
2. In the Formula text box, type two quotation (" ") marks with a space in between the quotation marks.
3. When finished, click OK.

Step 3 
Place the calculated field on the Text shelf, and place another instance of the calculated field in the Columns shelf.

http://kb.tableau.com/articles/knowledgebase/removing-abc-placeholders