Tableau Tips Tweet Series Vol2 | Happy New Year 2021!!

If you've missed it, @HighVizAbility has been sharing a @Tableau tip every day on Twitter & is over 100 tips.Make sure you check out the tips each day & you can access all of the past tips here.https://t.co/MvOwhMKwaF

— Kevin Flerlage (@FlerlageKev) July 24, 2020

#TableauTips How easy it is to turn ON/OFF with "ALL" option in selector values ? in @tableau / @tableaupublic – Check it out.. #datafam

Go to Menu of Selector > Customize > "Show All Values" enable/disable based on your requirements/need pic.twitter.com/rps43rrxLf

— Rajavel (@RcVels) September 11, 2020

#TableauTips Date Filter – Selector Types in @tableaupublic / @tableau

1) Range of Dates
2) Start Date
3) End Date
4) Browse Periods
5) Relative Dates

My fav is Relative Dates – easy and convenient for analysis. #datafam pic.twitter.com/R27C5CI5q6

— Rajavel (@RcVels) September 16, 2020

#TableauTips Depending on the complexity of the calculations used in your extract, this feature can potentially speed up future queries by allowing Tableau to compute certain calculations in advance. Do it anytime b4 publish!

"Data > Extract > Compute Calculations Now"@tableau pic.twitter.com/TEUxLneMmf

— Rajavel (@RcVels) September 17, 2020

#TableauTips Drag/Drop multiple objects from Dimensions/Measures pane to Rows/Columns sections

SHIFT + <select needed objects> = Drag to Rows/Columns

Easy to build viz with multiple objects using SHIFT select key in @tableaupublic / @tableau – Hope it helps! #datafam pic.twitter.com/vvrOvqZ3K1

— Rajavel (@RcVels) September 18, 2020

#TableauTips Can we get the user login in @tableaupublic / @tableau ? YES – with function "FULLNAME()"

I learnt this today and thought of sharing it to #datafam pic.twitter.com/MjtlVIqYDd

— Rajavel (@RcVels) September 24, 2020

#TableauTips Today extending yesterday's tip with additional user functions in @tableaupublic / @tableau :

1) USERNAME() – Returns the username for the current user.
2) USERDOMAIN() – Returns the domain for the current user when the user is signed on to Tableau#datafam https://t.co/X9dCWdLyac pic.twitter.com/fwUGuqAK56

— Rajavel (@RcVels) September 25, 2020

Hey #Datafam – I was busy recently and coming back with my #tableautips This time sharing the Ring Pie that I've used on my IronViz – how did I do it ? Here's the animation of it – Hope it helps!@tableau @tableaupublic pic.twitter.com/9TioV8POZa

— Rajavel (@RcVels) October 12, 2020

#TableauTips Today sharing the DateAdd() function in @tableau / @tableaupublic to the #DataFam

Also learnt the tip of drag/drop creating the calculated fields from #IronViz -I loved it pic.twitter.com/pTxrltCl8G

— Rajavel (@RcVels) October 13, 2020

#tableautips Here is my tip of learning to build rounded bar chart in @tableau @tableaupublic
> Create Bar Chart
> Use Avg(0)
> Dual Axis
> Convert chart to LINE
> Increase SIZE
> Format to look pretty

URL : https://t.co/pKkJ95EKkP

Thanks to @VizWizBI for the video! pic.twitter.com/4gdz8TvUkI

— Rajavel (@RcVels) December 11, 2020

#TableauTips During one of my friends #MOM – learnt this tip of enabling the side bar if its lost while your working with @tableau / @tableaupublic

> Window > Show Toolbar
> Window > Show Status Bar
> Window > Show Side Bar (to enable Data & Analytics pane)

Hope it helps! pic.twitter.com/8A0ZEUUsJ4

— Rajavel (@RcVels) December 15, 2020

How to turn the labels for graphs easily in @tableau / @tableaupublic ? Thought of sharing to #datafam

1) Toolbar shortcuts (T) button – Click to On/Off (or)
2) Label shelves >> "Show Mark Labels" on or off checkbox

I learnt the tip #1 from @VizWizBI videos:) Thanks to him pic.twitter.com/qUFg0s9TaW

— Rajavel (@RcVels) December 18, 2020

How to turn the labels for graphs easily in @tableau / @tableaupublic ? Thought of sharing to #datafam

1) Toolbar shortcuts (T) button – Click to On/Off (or)
2) Label shelves >> "Show Mark Labels" on or off checkbox

I learnt the tip #1 from @VizWizBI videos:) Thanks to him pic.twitter.com/qUFg0s9TaW

— Rajavel (@RcVels) December 18, 2020

#tableautips Describe Worksheet – Shortcut Key tip

> CTRL + E

You can view the description of the worksheet with detailed information & can be shared to others as well to know more about an specific viz or worksheet on @tableau / @tableaupublic

Ref: https://t.co/Z9kJ2BUhZk pic.twitter.com/wN2ibbl1BE

— Rajavel (@RcVels) December 21, 2020

#tableautips View Data — Additional tip

You get them under "Dimension" shelves to view the data of an data source (maybe very helpful while working with smaller dataset)

Hope it helps #datafam while working with @tableau / @tableaupublic pic.twitter.com/VpnY2a7Fo9

— Rajavel (@RcVels) December 21, 2020

#tableautips Summary card very helpful while working on @tableau / @tableaupublic to check counts/sum/min/max

Hope it helps to #datafam !

Ref : https://t.co/6Z6JyJBlVp pic.twitter.com/cAn5wfeXEw

— Rajavel (@RcVels) December 21, 2020

#tableautips Do you know that from @tableau 10 above – you can format the whole workbook easily in @tableaupublic / @tableau ?

Goto Format >> Workbook >> Update formatting (applies to whole workbook)

Ref: https://t.co/uLEtC6e1m8

Hope it helps #DataFam ! pic.twitter.com/i73RuY1DC1

— Rajavel (@RcVels) December 22, 2020

#tableautips Here is the tips series about string functions in @tableau / @tableaupublic

> Formula : LEN("abc") > returns the length of string
> Usage : length of phone number / name / URL String
> Validate them later to get Boolean results (T/F) #DataFam pic.twitter.com/JPpJe3siPD

— Rajavel (@RcVels) December 22, 2020

#tableautips Here is the string tips series function on @tableau / @tableaupublic :

> LOWER("ABC") = abc
> UPPER("abc") = ABC

Hope it helps the #datafam community! pic.twitter.com/e0tyGUhrHj

— Rajavel (@RcVels) December 23, 2020

#TableauTips Series of Tips on string functions in @tableau / @tableaupublic

> FINDNTH(string, substring, occurrence)
> E.g. FINDNTH("Rajavel","a",2) = 4 (a 2nd Occurrence is 4th char)

Hope it helps the #DataFam community! pic.twitter.com/jG8YhS6CLC

— Rajavel (@RcVels) December 23, 2020

#TableauTips Tips series on String function on @tableau / @tableaupublic

> CHAR(NUMBER)

char(9730)=umbrella
char(9786)=white smiley
char(9787)=black smiley
char(9824)=spades
char(9827)=clubs
char(9829)=hearts
char(9650)=up ^
char(9660)=down v
etc,
Ref:https://t.co/lhiUmp6O8G pic.twitter.com/RPdWl9LftQ

— Rajavel (@RcVels) December 24, 2020

#TableauTips String series of functions on @tableau / @tableaupublic – Today is with below function:

> RIGHT("Brad Pitt",4) = "Pitt"
> LEFT("Brad Pitt",4) = "Brad"

Hope it helps #datafam! pic.twitter.com/a9EPL4MpbU

— Rajavel (@RcVels) December 26, 2020

#TableauTips String series tips in @tableau / @tableaupublic

> STARTSWITH("Paul Walker","Paul") = TRUE
> ENDSWITH("Mike Jordan","Jordan") = TRUE

Hope it helps #DataFam ! pic.twitter.com/FhJnaTNvCH

— Rajavel (@RcVels) December 26, 2020

#TableauTips String series tips in @tableau / @tableaupublic :

> TRIM(" Rajavel ") = "Rajavel"
> RTRIM(" Rajavel ") = " Rajavel"
> LTRIM(" Rajavel ") = "Rajavel "

Hope it helps #Datafam ! pic.twitter.com/Vfj1BtAMLe

— Rajavel (@RcVels) December 27, 2020

#TableauTips String series function on @tableau / @tableaupublic

> Concat two string > E.g. > First Name + Last Name
> Concat with Space > E.g. > First Name + " " + Last Name
> Using function > E.g. > First Name + Space(1) + Last Name

Hope it helps #DataFam! pic.twitter.com/sbY4tNt4Ol

— Rajavel (@RcVels) December 29, 2020

#TableauTips Final String Tip Series func & my 50th Tip of the year @tableaupublic/@tableau

> SPLIT(string, delimiter, token number)
> SPLIT("Brad Pitt", " ",1) = Brad (First Name)
> SPLIT("Brad Pitt"," ",-1) = Pitt (Last Name)

Enjoy the new year! Take Care Everyone#DataFam pic.twitter.com/mnwYH2ZAcM

— Rajavel (@RcVels) December 31, 2020