Tableau Zen Master Tips & Tricks - Charts Edition

[@totleariss]

No Axis Bar Chart- 2:00 Bar Chart - 2:30 Lollipop Chart - 2:55 Bar Chart by Month - 3:40 Stacked bar chart - 4:30 Stacked bar chart with percentage total - 5:15 Stacked bar chart with line across - 5:30 Stacked bar chart with end label method 1 - 5:54 Stacked bar chart with end label method 2 - 6:49 Bar in bar chart method 1 - 7:32 Bar in bar chart method 2 - 8:30 Bar in bar chart method 3 - 9:44 Bullet Graph - 10:20 Comparison to prior year - 11:25 Comparison to prior year Singel color variance - 13:56 100% stacked bar chart - 14:56 Rounded bar chart - 16:20 Barbell chart - 17:51 Diverging bar chart - 18:53 Diverging Area chart - 21:40 Nested Sorting - 23:13 Nested Sorting with rank - 24:27 Area Chart - 25:54 Area Chart with line - 26:12 Stacked Area Chart - 26:44 100% Stacked Area Chart - 27:46 Small Multiple Area Chart - 29:55 Scatter Plot - 33:32 Animated Scatter plot - 34:56 Connected Scatter plot - 36:38 Histogram - 38:44 Animated Histogram - 39:30 Basic Map - 40:36 Geographic Grouping - 41:00 Line Chart (Discrete) - 42:43 Line Chart (Continuous) - 43:06 Small Multiple Line Chart - 43:39 Dashed Lines (Method 1) - 44:18 Dashed Lines (Method 2) - 45:08 Common Baseline Chart - 45:55 Stepped Common Baseline Chart (stepped) - 47:31 Highlighted Line Chart (Method 1) - 48:02 Highlighted Line Chart (Method 2) - 48:59 13 week Moving Average - 50:37 Sparklines with Labels - 51:49 Sparkbars - 53:40 Slope Graph (Method 1) - 54:23 Hockey Stick Chart - 55:22 Forecasting - 56:23 Forecasting (no bands) - 57:00 Single Line with Forecast - 57:18 Bump Chart - 57:40 Heat Map - 58:40 Heat Map (Continuous) - 59:20 Dot Map - 1:01:53 Density Map - 1:02:42 Hex Map - 1:03:42 Cat Map - 1:04:56 Simple Pareto Chart - 1:06:00 Advanced Pareto Chart - 1:07:37 Calendar - 1:10:09 KPI Chart - 1:11:24 BANs - 1:12:51 BANs with Text Below - 1:14:23 Dot Plot - 1:14:58 Jitter Plot - 1:15:30 Box Plot - 1:16:00 Box Plot remove ends - 1:16:28 Pie Chart - 1:17:10 Donut Chart - 1:17:48 Tree map - 1:18:38 Tree map bar chart - 1:19:14 packed bubbles - 1:19:32 colored packed bubbles - 1:20:02 Bullseye Chart - 1:20:12

[@paperboy927]

Hero !

[@thumbliner]

Give this man a cookie.

[@jessicawong4628]

Amazing! Thank you!

[@abishekthirukonda5607]

Thank you!

[@vizwiz]

Just saw this Phil! Super helpful! Thanks for taking the time to do it.

[@Angelita_Liu]

Beautifully presented, Andy, this is the best ever tableau tutorial I have ever had so far. you have become my tableau internet Guru and I always watch your videos whenever i have questions about tableau.

[@danielwalczak9453]

I know everything took longer, but it really helped watching you build each visual on the fly! Excellent content, thank you! Also, you are hilarious.

[@kaushiksrivatsa6690]

Appreciate your patience for the thank less crowd you were teaching. I was literally clapping for almost all the amazing tips you gave throughout the video. Keep teaching Andy. You're great

[@v.c1485]

Your dual axis just fixed my "adding label showing total # to each stacked Bar issue"!!! I couln'd by doing the reference line! and yours is perfect!

[@VISUALDUMP]

I have not watched the video yet but I already know this video is going to teach me more than the tableau course I paid for.

[@vizwiz]

I have my own course. Two actually. 1. Next-Level Tableau -> nextleveltableau.com 2. Next-Level Tableau Lite -> lite.nextleveltableau.com

[@joelrosos2929]

Most helpful for a beginner me. Been playing with Tableau for a week now. Thank you.

[@mattsantamaria1173]

Absolute must watch for anyone who uses Tableau. Thanks Andy!

[@anmaxin325]

Marvelous! Everyone who studys Tableau needs it!

[@zipporah_prz8334]

Even with the challenge of no pre-builts this was an amazing feat. Just found out about you today. I'm hooked (and subscribed)!

[@vizwiz]

Fantastic! Thank you!

[@rscitta]

You Sir are a genius! This video turned from me from a novice to a Tableau rockstar in only 1h20 :-)

[@lucky-fr1ux]

After taking training to learn tableau nd after I learnt in Udemy , and max videos on KZbin......all these making me confused Finally I'm here ... which made me clear all the doubts...i started to following

[@vizwiz]

That's fantastic! Thank you!

[@Drkalaamarab]

Hi Andy Sir, You are my Hero to learn many new ideas in creating charts. Great demonstration ❤️👍 loved it 🙂. I am great lover of Visualization. Thanks for videos. More to come......🙂

[@xt.7933]

Wow, this is like watching a magic show! Just wish the data was attached so that we could follow you step by step. Bravo still! Thank you for sharing.

[@vizwiz]

This uses superstore.

[@krishnap8715]

Actually you have covered Complete Tableau in just one hour. Superlike.

[@emanuelecostantini9243]

One of the most useful Tableau video ever!!!! Thanks a lot!!!

[@vizwiz]

Thank you! That's very kind.

[@alexandremorin-chasse2897]

Nice work. A massive amount of information inside a user-friendly format. Once in a while, I have to set the speed to 75% in order to see every click you make, but that is not a real problem.

[@vizwiz]

alexandre morin-chasse thank you for the kind words. The purpose of the webinar was to do as many charts as possible. When I learn from videos, I find it helpful to pause the video along the way and reproduce the clicks.

[@alexandremorin-chasse2897]

@@vizwiz Same for me. By the way, #MakeoverMonday is on my bookshelf along with other great books on Dataviz. I believe it is an essential ressource for original ideas and useful tips. Thanks to you and Eva Murray for this nice contribution.

[@manishlakhera8250]

Andy, Sir your visualization techniques are Rocking.. Thanks You Sir for this superb Tips & Tricks Video

[@aryob5092]

It`s 2021 and I`m still using it as reference.... Wow, thanks Andy

[@vizwiz]

The gift that keeps on giving. 😊

[@poiisondn]

Best video ever. Saved my ass with creating visual analytics. Thanks!

[@joesanjuan1083]

Newbie Tableau user here. This is soooooooooo awesome!

[@vizwiz]

That’s great to hear! Thanks for the feedback.

[@shubhamekbote1628]

Man of the match! Very well played with tableau. It seems effortless work but there's lots of hard work behind it. Thank you! Cheers👍

[@sharadjadhav2982]

This was amazing and super light. Thanks, Andy.

[@mmmaxmmm83]

Never stop doing these

[@makiemosola2766]

You are such a delight, this is so helpful thank you and God bless you

[@maxt1846]

Fantastic tutorial! Keep on going, Andy!

[@ogwouchenna896]

Bless you Mr andy, this is a life saver

[@graceyu906]

Great video! Thanks for sharing all these fundamental and practical tips.

[@wanderlust8075]

You r simply Amazing !! Big Fan of yours !

[@Seaweedaids]

Many thanks for sharing Andy, tons of useful tips here

[@joelrocha5388]

Incredible! Thank you for sharing Andy.

[@vizwiz]

Joel Rocha cheers Joel!

[@theomerka5472]

Thank you very much. So professional, so understandable, and comprehensible, Wow.

[@vizwiz]

Thanks for the feedback Theo!

[@jayantnayak4034]

Hi Andy, Thanks a lot for sharing your knowledge with us. It's great help. I am facing some issues in Bar-In-Bar Chart. Actually I am using it to Compare my last year cost with current year (by month)....and I need to add an Average Line (average of last year cost) to be shown on the CHART..but when I am adding that Average Line its showing me average of last 14 months (Jan2020 till Feb2021) instead of showing the average of 2020. Need your guidance plz

[@charudattshenoy8961]

Hi Andy, big fan of your skills and I learn a lot from your videos. I have a question if you could help me. The tableau filters, parameters are very dry in look and feel. Is there a way we can enhance the look and feel of it and make it more visually appealing along with the other charts for an app-like experience?

[@vizwiz]

I have seen examples where people create object that look like buttons instead. Check out the work by Lindsey Poulter, Ryan Sleeper, Ken Flerlage and Kevin Flerlage. I believe they all have examples.

[@paolameneghetti9001]

Really insightful! Many thanks for sharing all these tips!

[@abdullah7891]

Fantastic Tute but I just wanted to ask, what's the "Use me" filter option. Or maybe I might've skipped out on something.

[@vizwiz]

I have no idea what you are referring to.

[@Cantblendthis]

Holy cows! It's like a magic show but with dataviz ... that was so motivating! Now watch me do 40 minutes on that first bar chart .. lol

[@vizwiz]

Glad you enjoyed it!

[@riiyaa23]

Very helpful tutorial. Thanks Andy!!

[@Mister.Psychology]

Very cool video. I should have watched this before I even started using the software. So many cool trick that are need to know.

[@__shalini]

Simply mind blowing! Thank you Andy! How can I get the 'Word Population 1950-2015' dataset that you used for the Diverging Bar Chart

[@vizwiz]

Shals if you download the workbook from the link in the description and unzip it, you’ll find all of the data sources.

[@__shalini]

@@vizwiz got it! Really appreciate your prompt reply

[@govind710]

loved watching this video, really quick way to learn, could you make the data sets available in link so that we can learn by doing as well

[@vizwiz]

GOVIND GUPTA you can download it from my blog www.vizwiz.com/2018/10/82-charts-in-80-minutes.html

[@sarahgibbons8376]

Hi Andy - I love this - thank you!! Do you have a solution for a side-by-side chart (at least 2 bars) with a line chart on top please. I can do it with stacked bars but not side by side??

[@phillipwade5276]

very helpful options you provide. Thank you. Have you shown ways to bridge years within current and prior year metrics. i.e. where fiscal is not calendar and trying to compare year over year or current to prior period?

[@kdausu90]

Love these videos

[@melaniebrowne8241]

Absolutely excellent! Thank you :)

[@hanane.ouhammouch]

You are a master thank you very much for the sharing

[@rogerjackls3995]

Great tips. Thanks Andy

[@kimwuensch1578]

Question . My friends son is doing his science fair project and needs a chart that shows people who take a polygraph test that have anxiety . So the chart would show subject 1-4 two took meds and two didn’t , three were truthful and one was deceptive . What type of chart could be used to achieve this .

[@xt.7933]

This is eye-opening! Thanks a lot! Could you share the data so that we could follow and practice?

[@vizwiz]

Download the workbook here - public.tableau.com/views/TipsTricks-ChartsEdition/Title?%3Aembed=y&%3AshowVizHome=no Unzip the twbx and you should get the data as well.

[@surajkandukuri1756]

Thank you, Andy! Learned a lot following along with my own data set. I'm struggling with creating Calculated Fields. Specifically, I'm trying to generate labels for the delta between years X and Y on my slope and barbell charts. I'm not sure how to define a value for a dimension in the formula (e.g. [Sales] in 2019 - [Sales] in 2000). Are you planning to make a video on calc fields or is there a resource that you can recommend?

[@vizwiz]

This video should help. kzbin.info/www/bejne/j6bbiqVqlNFlrdk

[@muraliinside]

Excellent tips. Well paced.

[@rerunepisode]

how do i download the data? i want to follow along.

[@ateeqahmad]

This is so kind! Thank you Andy!

[@deepkumargala1579]

This is very helpful. Thank you Andy!

[@MrSunitharam]

Andy..can you please share data set for diverging charts

[@user-hb2df6nn2y]

Hi Andy, why to do SUM([Profit])/SUM([Sales]) > 0 ? I mean isnt it the same of just typing SUM([Profit])>0 cause sum sales will always be positive so the ratio will be positive or negative just depending on sum profit value. Am I wrong?

[@areezamr]

Lovely tutorial. Great work and thanks for your time and efforts to share with us. But try as I might I was never able to get the data. When you download the twbx file from the links provided and you then press the data source tab to see the data, it opens a window and asks you to locate the (raw) data file. It would be great if we can download this as well.

[@vizwiz]

Amr Mahmoud unzip the twbx

[@areezamr]

@@vizwiz Thanks for the reply. Being a newbie I had no idea that was an option. Greatly appreciate for being patient with me.

[@malathikandimalla554]

You r amazing and u r life saver. I don't see any data in the link, please post the datasource.

[@BharatPatel-tc8dt]

Awesome! Most helpful to new BEE :)

[@freakshitzchopra8796]

this is awesome. Thanks you so much for putting in so much effort to share your knowledge :)

[@benjiyamamoto4222]

It would help if we had the data to work along with this video. not able to find it

[@vizwiz]

Hi Benji. If you download the workbook and then unzip it, you will see the data in a folder. If I recall, nearly all of these use Superstore which you will already have.

[@karthikkunala]

The bar in bar chart 2 dint work properly, I tried multiple times. Since I was not able to build that couldn't do bar in bar 3 too.

[@vsagar4b38]

Thank You Andy

[@amandaavellar9715]

Is there a way to do side by side rounded bar charts?

[@jamesdigishop]

game changer. thanks for sharing bro!

[@vizwiz]

That’s great to hear. Thank you!

[@VinayKumar-ij4eu]

Hi Andy....I just saw this and it was awesome and appealing, could you please let me know if you cover Tableau from basic to advance with different Charts, Calculations, Dashboards? I just start learning tableau so can't get many things which you did so quickly :)

[@vizwiz]

There are two videos in my Live feed about layout containers that might be useful. Have a look and if these aren’t what you mean, then please leave another comment here.

[@VinayKumar-ij4eu]

@@vizwiz Hi Andy, could not found the video, can you please share the link with me?

[@vizwiz]

@@VinayKumar-ij4eu kzbin.info/www/bejne/fYqyqoWeqKyWjc0&ab_channel=AndyKriebel kzbin.info/www/bejne/j3bdeXSrabp7qcU&ab_channel=AndyKriebel

[@VinayKumar-ij4eu]

@@vizwiz Thanks Andy but I am looking for a tableau course which covers all the topic from basic to advance

[@VinayKumar-ij4eu]

@@vizwiz There are 238 videos on your channel named Tableau Tips, will those be sufficient for a beginner?

[@cristianraulval]

Gracias. Saludos desde Colombia!

[@jessicawong4628]

I'm constantly learning SO MUCH from you. Thank you!

[@kennywiseman3932]

Hi Andy, Awesome videos. Quick question around single state maps; how can i create and analyze data on a single state?

[@vizwiz]

Ken Forbin filter to the state you want to analyze.

[@EdmondAdventures]

Hi Andy, is there a way to create a gauge-like chart in Tableau?

[@vizwiz]

Yes, there are lots of resources if you google it.

[@StockSpotlightPodcast]

LEGENDARY!

[@DebasmitaDasgupta1]

I have 2 datasets. One of 4th Jan and the other of 11th jan. Both the datasets contains views and downloads of articles/blogs. I need to find out increase/decrease of views from 4th to 11th and bring one report from it using tableau. Do I have to append them first? Can you suggest a solution?

[@vizwiz]

This solution should work, except use weeks instead of months. kzbin.info/www/bejne/jJqnZKmZocyBrJo

[@gritmanish]

Thanks Andy.. Nice Tips

[@rss8808]

I have created 2 graphs and now i want to create a 3rd Graph from existing Graph 1 and Graph 2 (output data) is this possible?

[@satyabratmajhi7981]

Aswome Video Andy. Thanks a lot.

[@rochellerobinson939]

How do I get the data? I've gone through the comments below and still can't figure out where the data is.

[@vizwiz]

It uses Superstore that comes with Tableau.

[@sanbarik04]

Execellent Sir. Thanks a lot.

[@aryob5092]

Thank you... clapping all the time... great tips bro

[@mudassarhussain178]

Awesome! How can i get the workbook ?

[@vizwiz]

On my blog. All of my videos have an accompanying post. www.vizwiz.com/2018/10/82-charts-in-80-minutes.html

[@syedshaulhameed]

how to connect JSON data into tableau. my .Json file is 7.6MB. kindly help me load the data..

[@saininavjyotsingh1070]

well done brother nice stuff appreciated.

[@navid8276]

Pretty curious about that “rat sightings” data set you got there 😂 awesome vid btw

[@ibraheemqaed7608]

Thank you Andy, it was really a helpful tricks

[@fusionarun]

Learnt a lot! Thanks!

[@kv6639]

For a free alternative, consider R with ggplot2. I'd be surprised if Tableau does anything beyond what R can do. The downside is the learning curve is steep with R.

[@StockSpotlightPodcast]

ggplot2 is great, but takes a lot more time/thinking if you want to get real granular with your customizations. I like being able to have both as options

[@kdausu90]

Is this finished workbook available for download?

[@vizwiz]

Kaden yes, here. www.vizwiz.com/2018/10/82-charts-in-80-minutes.html

[@kdausu90]

Thank you so much!

[@govind710]

@@vizwiz not able to download complete workbook, seems some issue, could you make it available again or check if there is any issue at your end

[@namanhtran5695]

How can i get access to the data worksheet?

[@vizwiz]

I'm not sure what you mean by the "data worksheet", but if you need the data (1) it's superstore so you probably have it already and (2) you can download the workbook and unzip it and the data will be there.

[@gubingwang8124]

Where can we find the excel file? thanks Andy!

[@vizwiz]

Gubing Wang download the workbook on my blog www.vizwiz.com/2018/10/82-charts-in-80-minutes.html

[@kaushiksrivatsa6690]

@@vizwiz I am not able to find the excel workbooks on the link please help

[@arojitdas8256]

at 14:52 how did u made 2018 and 2017 total sale measure

[@vizwiz]

Arojit Das you can download the workbook from my blog and see how I did it.

[@meeteeeuma]

I have three fields , date, state and sum(sales). I have to pick top 5 States (based on sales) for current quarter and get trend graph for those states in past three quarters. How can I do this?

[@vizwiz]

Uma Sivalingam post on the forums. This channel isn’t meant for that purpose.

[@tanyabhalla5083]

Please help me with the data work please...?

[@PavanLalwani]

Awesomeee

[@avinashvishwakarma4884]

Sir can we make Top 10 Sales based on state Calculated field and the feild will provide us only top 10 sales total Sum can we do it?

[@vizwiz]

Avinash Vishwakarma post on the forums when you need help. Your question is not related to these videos.

[@adhibaguspribadi]

Mr andy, can i get a data source 🙏🏻

[@vizwiz]

Unzip the twbx and you should get the data as well.

[@adhibaguspribadi]

Thank you sir

[@abhibagewadikar8170]

Awesome 👍👍

[@anirutkepan4867]

Very useful tips, thanks you.

[@cm96yyc]

For 100% stacked bar chart (14:56), that is misleading. Your date is a dimension so it aggregates for each month for every year, so its the sum of sales across all Januaries etc for 2016-2018. So really its 3x as much as you did in any given year, unless you were trying to show that, and it wasn't clear.

[@marktossell8461]

Awesome! Thanks.

[@vizwiz]

You're welcome!

[@marktossell8461]

@@vizwiz I’m a new Tableau SE; background as a TCRM partner. I’m now a Tableau sponge! 😎

[@teddywaweru2270]

@ kzbin.info/www/bejne/iWa0f2CcgJdgrbc you mention on having dual axes with the reference line. I tried this out & turns out that the reference line will show both values of the dual axes in use. Is there a way to disable one of the axes from the reference line output?

[@teddywaweru2270]

I think the best alternative is to format the values so that their positions are not automatic, then they would align well.

[@vizwiz]

Yeah, that's annoying isn't it? Not much you can do about it when both axes are the same measure.

[@yukilu2040]

thank you. it‘s very helpful