Thursday, 5 July 2018

TC18 London - Practical Tableau Tips

Ryan Sleeper

Fundamentals = Success
Ryan’s two most popular posts out of 200 is one on bars and one on lines

Bar chart tips
  1. Give your headers space
  2. But don’t make your bars too fat
  3. For only a few bars - use a direct label and hide the axis
  4. Heavy axis ruler bar to give the base a firmer zero line

Line chart tips
  1. Maximise Data Ink ratio (Tufte concept) To do this minimise the non-data elements
  2. Remove redundant data ink
  3. Make increments on the axis larger
  4. Remove obvious axis labels
  5. Highlight the key element you want to analyse

Psychological Schemas - we learn by patterns so if we disrupt the pattern, we struggle. Ie if green didn’t equal good and red wasn’t bad
  1. Don’t break these within your visualisation or you will confuse your users

Spatial Context
  1. Adding any spatial element to a view helps add additional context and spot weird outliers as we have preconceptions about how the pattern should be

CTRL+E - in Tableau this can tell us a lot
You can also click on a calc in a Calculation window and click ‘describe’ on the dialogue box and you can copy and paste your calculation

Filter in Use
Create a calculation If sum(num of red) <> attr({fixed: sum (num of records)}) then ‘Filter in use’ else “” end
Add to the dashboard to show when someone is filtering

Descriptive analytics (basic dashboarding)
Prescritptive analytics - explain why something has happened and describe what to do about it
Add your own commentary by using a string parameter on another sheet and a three choice option as to whether it is positive, neutral or negative and then show the resulting values in the main dashboard.


  1. It was really a nice post Thanks for sharing
    Tableau Online Training

  2. Thank you so much for putting up such a informative post about Tableau and related aspects.

    Tableau Rest Api Connection


    Hello my dear people, I am Linda McDonald, currently living in Austin Texas, USA. I am a widow at the moment with three kids and i was stuck in a financial situation in April 2018 and i needed to refinance and pay my bills. I tried seeking loans from various loan firms both private and corporate but never with success, and most banks declined my credit ,do not full prey to those hoodlums at there that call them self-money lender they are all scam , all they want is your money and you well not hear from them again they have done it to me twice before I met Mr. David Wilson the most interesting part of it is that my loan was transfer to me within 74hours so I will advise you to contact Mr. David if you are interested in getting loan and you are sure you can pay him back on time you can contact him via email……… ( No credit check, no cosigner with just 2% interest rate and better repayment plans and schedule if you must contact any firm with reference to securing a loan without collateral then contact Mr. David Wilson today for your loan

    They offer all kind of categories of loan they are

    Short term loan (5_10years)
    Long term loan (20_40)
    Media term loan (10_20)
    They offer loan like
    Home loan............., Business loan........ Debt loan.......
    Student loan.........., Business startup loan
    Business loan......., Company loan.............. etc
    When it comes to financial crisis and loan then David Wilson loan financial is the place to go please just tell him I Mrs. Linda McDonald direct you Good Luck.......................

  4. Are you in need of Loan? Here all problem regarding Loans is solve between a short period of time what are you waiting for apply now and solve your problem or start a business with funds Contact us now. many more 2% interest rate.(Whats App) number +919394133968
    Mr Sorina