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!
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!
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!
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.
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?
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!
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?
I tried making a similar table on tableau however whenever I add a sparkline, it causes the bar charts to switch from a horizontal to a vertical position.
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
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
@@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
![How to Create an Drill Down Donut Chart [in Tableau]](http://i.ytimg.com/vi/1Pb44LbR_a0/mqdefault.jpg)
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!
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!
This is excellent! I can't believe how creative people get with Tableau. Really appreciate the step-by-step approach to this
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!
Excellent instruciton! THANK You! My tableau game has leveled up.
Much appreciated!
Great tutorial, Anthony! Thanks for this and all you do for the community!
I appreciate that, thank you!
That was awesome! Great step by step explanations. I'm sharing this with my team at work for inspiration!
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.
It took me a while but finally got it
Fantastic!
Thanks for the tutorial, found this template but it was complicated to understand. You made it easy!
Thanks for sharing that! I try to help make difficult concepts approachable.
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?
this is masterpiece
You're too kind!
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!
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?
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.
Did you ever find a solution for this? I'm facing the same issue
I'm also having this issue. Anyone find a solution?
Could you please share the data set ?
Thanks
I tried making a similar table on tableau however whenever I add a sparkline, it causes the bar charts to switch from a horizontal to a vertical position.
How can we have more than 2 trend charts?
Can you share the dataset ?
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
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
@@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
@@FarazNadeem-nq6uc Great, glad you got it sorted out!
Sir I have one question?
How we can highlight row
Condition :- highlight 6th date every month
Experiment with the date calculations in this video on Sparklines th-cam.com/video/ivF2zhEuMb0/w-d-xo.html