Create an Advanced Tableau Table (Step by Step Instructions)

Be warned, this is Highly Advanced Tableau!!
In this video, we'll explore how to generate advanced tables in Tableau (step by step), complete with multiple chart elements displayed on the same table row. With multiple chart elements like sparklines displayed on the same table row, you can more easily compare and contrast different sets of data, making it easier to identify trends and patterns.
Credit to #datafam members Zainab Ayodimeji & Sam Parsons for influencing this video!
Watch Sam Parsons Original Video Here:
► • Super Advanced Tableau...
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/anthonysmoak
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕
www.buymeacoffee.com/anthonys...
★☆★ Support this Channel: ★☆★
👕 Merch ► shop.spreadshirt.com/AnthonySmoak
0:00 Intro
0:28 Inspirations
2:47 Dataset Overview
3:40 Calculated Fields
8:35 Ranking Build
9:40 Text Build
10:37 Calculated Fields for Bullet Chart
11:52 Bullet Chart Build
15:20 Line Chart Build
19:36 Chart Formatting (3x Speed)
20:15 Bonus Round: How Does This Work??

[@AnnieCushing]

I had watched Sam Parsons' brilliant video last year but had a hard time hearing him and wrapping my mind around the logic. You explained it supremely well. Thank you!

[@AnthonySmoak]

Sam is brilliant for dreaming up this technique. I wanted to offer an alternative explanation after being inspired by Zainab's Tableau Public viz. It feels good when people get some value out of my vids! Thank you for sharing!

[@Scott-nj1jt]

Great tutorial, Anthony! Thanks for this and all you do for the community!

[@AnthonySmoak]

I appreciate that, thank you!

[@ashleygarner4741]

Excellent instruciton! THANK You! My tableau game has leveled up.

[@AnthonySmoak]

Much appreciated!

[@jusjerm]

This is excellent! I can't believe how creative people get with Tableau. Really appreciate the step-by-step approach to this

[@AnthonySmoak]

Full credit to Sam Parsons for the technique development and Zainab Ayodimeji for the inspiration. On my end, trying to figure out how to reverse engineer and explain it took some time!

[@schmiedk1]

That was awesome! Great step by step explanations. I'm sharing this with my team at work for inspiration!

[@AnthonySmoak]

I appreciate the feedback on the explanation! Make sure to check out Sam Parsons's original video as well (link in description). There are many more chart options to choose from.

[@Shalve94]

Thanks for the tutorial, found this template but it was complicated to understand. You made it easy!

[@AnthonySmoak]

Thanks for sharing that! I try to help make difficult concepts approachable.

[@AkiraKurasawa_]

It took me a while but finally got it

[@AnthonySmoak]

Fantastic!

[@AllisonRosenbaum]

Very clear instructions! I'm learning a lot from your tutorials. However, I can't find a way to make a bullet chart on Tableau Public. I don't see an option for a fixed size when building the bar chart; is this something that's only possible on Tableau Desktop?

[@kevintran314]

This is a great video and in-depth explanation! thank you! A quick question, do you know how to modify column widths individually? It appears that every time I try, it changes the width for all columns but Sam Parson was able to on his. Not sure how he did it!

[@xcc7437]

this is masterpiece

[@AnthonySmoak]

You're too kind!

[@estherudom7877]

Excellent work!!!...please it's difficult to use another data set to follow through with this tutorial, is there a way to have access to this particular data?

[@obamacare8679]

I cant seem to reset the Y Axis Position. It got Table across checked, and if I drag it out and put it back, it still have tablea across checked.

[@AbdullahAlMamun-jm4qm]

Could you please share the data set ? Thanks

[@gandharvnarang1557]

Can you share the dataset ?

[@sandipanbepari2897]

How can we have more than 2 trend charts?

[@FarazNadeem-nq6uc]

Since i don't have this data, I am trying this with Sample super store, I created the Current Year calculated field, but i cannot create the Current Year Sales' calculated field, the problem lies over the case statement "if year([Order Date]) = [CY] then [Sales] else null end" i am getting the follwoing two errors: 1. Cannot mix aggregate and non aggregate arguments with this function. 2. Cannot mix aggregate and non aggregate comparisons or results in 'if' expressions

[@AnthonySmoak]

I can comment on your specific data but aggregate issues are usually resolved by using the ATTR function. Play around with ATTR for the Year and SUM for the sales. community.tableau.com/s/question/0D54T000019ux1ESAQ/how-to-get-around-calculated-field-not-allowing-to-mix-aggregate-and-nonaggregate-values

[@FarazNadeem-nq6uc]

@@AnthonySmoak really appreciate your quick response. I just watched your video again and found out that while defining the CY calculated field i forgot to put them in the braces { }, it works perfect now. Thanks again

[@AnthonySmoak]

@@FarazNadeem-nq6uc Great, glad you got it sorted out!

[@sahilgusain3140]

Sir I have one question? How we can highlight row Condition :- highlight 6th date every month

[@AnthonySmoak]

Experiment with the date calculations in this video on Sparklines kzbin.info/www/bejne/n6epY62eetqAmJI