Andy, as always, great content. I couldn't understand a thing from the blog that Tableau has published to explain this. Love this channel. Please never stop.
Now that I’m building tableau reports, the for each statement is the best technique ever. It works for LOD’s as well.u showed that in another video. Thanks
It's interesting to hear it explained like this, and then compare your logical sequence to the Tableau UI. There aren't many cases where the Tableau UI is off, but this looks like one where it needs another rethink.
Agreed Charlie. The whole UI needs to be flipped upside down and the words changed for it to make sense. But now that I understand it, please don't change it. :-)
This really helped me to finish the table calculation part of workout Wednesday (EPL rankings) of this week in no time. LOD piece took a while but your other short videos on it evenrually helped me think through it. Thanks Andy!!
Great video! What if I have say table 1 in Sheet 1 with two columns; number of orders for each customer and customer name and table 2 in Sheet 2 also with customer names but this time, the second column in sheet 2 has the number of times the customer ordered on Black Friday. My goal is to get in a new table in a new sheet ( say sheet 3) the ratio of orders on Black Friday/total number of orders per customer.. so basically the values in sheet 2/values in sheet 1. How do one go about achieving that? Bear in mind that not all customers will buy anything on Black Friday and I will wanna see them show up with a zero in sheet 3. Note that, sheets 1 and 2 have some filters in the filter pane Thank you!!
Let's use a pareto that calculated the % of total running sales by product and we region in the rows. So essentially calculating a pareto per region. You would read it like: "For each Region, calculate the running total of sales by Product then for each Region, calculate the % of total sales by Product."
Hi nice video. I am new to Tableau. I am working on one assignment where I am trying to show relationship between source and destination IP addresses on dashboard. My requirement is to show respective destination IP of the source IP in the form of chart. Actually I am not getting what type of chart is good to show such relationships effectively. Currently I am using bubble chart to show my source IP address with size and when I click on particular SOURCE IP it displays respective destination IP address and its count in form of the table but I want to show in chart format. Could you please tell me how to do this. or Any similar example would be great. Thanks
Yes sometimes it does. Read them upside down. So if you have two boxes checked, let’s call them segment and category with segment at the bottom and you have region unchecked. And let’s say you’re using a difference from table calc. You would say something like “Calculate the difference from each region by segment then by category.” Once they are checked and you move them around, that order will stick no matter where you put the fields on the shelves. You could also think of the Region as a group by if you are familiar with Alteryx or SQL.
@@vizwiz is right if I try to imagine this particular case as a table where my rows are Regions and my columns are in the next order Segment->Category?
![ถามตรงๆ กับ อาจตุพร ทำไม ประเทศไทย ใครเป็นนายก ก็โดนด่า พอออกเเล้วคนคิดถึง!!?? l [Nickynachat]](http://i.ytimg.com/vi/3YFLMXxBGAs/mqdefault.jpg)
There cannot be any more explanation required about this most powerful feature of Table Calculations. You made everything crystal clear.
This lesson has really helped me to understand concept of table calculations. Appreciate a thorough lesson on table calculation advance level as well.
Dude, you are too good. It's amazing, I never understood table calculations before so easily. Thanks a lot.
thank you! I ran into issues with table calcs but this video helped shine a lot of light on it!
oh man... now I get table calcs so much easier. great way to explain this.
Thank you so much. This video has cleared up my confusion regarding table calculation.
Extremely useful for my Tableau Professional Certification Exam preps!
Andy, as always, great content. I couldn't understand a thing from the blog that Tableau has published to explain this. Love this channel. Please never stop.
Glad it was helpful!
This lesson really clears things up for me regarding table calculations. I will take this by heart. Thank you, Andy.
My pleasure. I’m glad you found it helpful.
Thank you ! This is the best table calculations tutorial! Subscribed 👍
Finally I found a right teacher to learn Tableau. thanks andy
This is my favorite of your videos, Andy!
Thank you for your honesty and for your clear guidance!
Very clarifying. Makes me wonder why Coursera couldn't lay it out this clearly
Now that I’m building tableau reports, the for each statement is the best technique ever. It works for LOD’s as well.u showed that in another video. Thanks
Thank you so much Andy! This gives me a new approach when it comes to table cal
Happy to help!
That was a very detailed and clear explanation of tableau calculations!
Thats really great...it gave me lots of clarity on using LODs
Andy, thanks for the superb tutorial. This is a really great way to demystify tableau table calculations.
It's interesting to hear it explained like this, and then compare your logical sequence to the Tableau UI. There aren't many cases where the Tableau UI is off, but this looks like one where it needs another rethink.
Agreed Charlie. The whole UI needs to be flipped upside down and the words changed for it to make sense. But now that I understand it, please don't change it. :-)
Thanks for this Andy! Super helpful video!
Glad it was helpful!
Thank you, Andy for the detailed explanation. very insightful.
A big thank-you Andy, what a great way to consolidate this, very helpful!
Ultimate Kriebel, Thank you So much for posting this video. It teaches how to read table calc
This really helped me to finish the table calculation part of workout Wednesday (EPL rankings) of this week in no time. LOD piece took a while but your other short videos on it evenrually helped me think through it. Thanks Andy!!
I wish I found your post earlier, Andy...it is the most helpful interpretation to decipher the code of the intimidating table calculation!
Thank you so much for simplifying this Andy. It was very helpful.
Andy iam big big fan of u, thanku for giving details explanation about tableau
My pleasure. I’m happy to hear you find it useful.
I found this very helpful. Thank you 🙏
You're so welcome!
Great Job Andy.
Requesting you to post a dedicated video on some basic calculations tips also.
Keep on sharing Tableau Master.....
I need to see this video again...
Thank you so much Andy!
My pleasure. I’m glad you found it helpful.
Thank you Andy, great lesson!
Great video! What if I have say table 1 in Sheet 1 with two columns; number of orders for each customer and customer name and table 2 in Sheet 2 also with customer names but this time, the second column in sheet 2 has the number of times the customer ordered on Black Friday. My goal is to get in a new table in a new sheet ( say sheet 3) the ratio of orders on Black Friday/total number of orders per customer.. so basically the values in sheet 2/values in sheet 1. How do one go about achieving that? Bear in mind that not all customers will buy anything on Black Friday and I will wanna see them show up with a zero in sheet 3.
Note that, sheets 1 and 2 have some filters in the filter pane
Thank you!!
Very clear and helpful, really appreciate it!
This is pure GOLD! Thank you Andy!!!!
Cool thanks Andy very consice and useful
Thank you, Andy. Tableau should pay you for this!
Rayce Rollins wouldn’t that be nice!!
@@vizwiz :)
Great information! Thanks for the clarity!
This is PURE GOLD, thanks Andy! If we add a secondary calculation, how we would read it?
Let's use a pareto that calculated the % of total running sales by product and we region in the rows. So essentially calculating a pareto per region. You would read it like:
"For each Region, calculate the running total of sales by Product then for each Region, calculate the % of total sales by Product."
Andy Kriebel Great video sorted out many confusions and hit and trial at my end 😂
really great! thanks a lot. i have tries to understand the table caluclation and i fail. now got it.
11:03, should it be "by Quarter and Year" ?
You are awesome! I could not stand the girl narrating the official Tableau tutorials so I ended up here.
Neither could I! They REALLY need a different narrator. Or they need to alternate her with someone else.
I agree, I tried hard but just could not stand her voice
Thanks for great video - perfect sir !
Thank you for this!
Glad it was helpful!
Thanks, Andy! This is a timely help indeed :)
Thank you. This is very helpful.
very nice explanation
Loved it! Thank you, Andy.
An interesting take would have been to show how the equivalent of table calculation could be done using LOD calculations.
Already done! th-cam.com/video/VlEwu-TKE_o/w-d-xo.html
Superb, thank you!
Hi Andy Hope you are doing good i have been following your channel since long back. can you please make video for tableau server.
Very well explained, Thank you!!
Hi Andy, I want to know how we connect different sheets of excel to different sheets in Tableau? Could you please help?
I learned a lot,thanks.
Can you also make us understand what is running total ?
Thanks Andy!
@ 7.18 easy to understand with power point
very helpful! thank you so much!!!
Hi nice video.
I am new to Tableau. I am working on one assignment where I am trying to show relationship between source and destination IP addresses on dashboard. My requirement is to show respective destination IP of the source IP in the form of chart. Actually I am not getting what type of chart is good to show such relationships effectively. Currently I am using bubble chart to show my source IP address with size and when I click on particular SOURCE IP it displays respective destination IP address and its count in form of the table but I want to show in chart format. Could you please tell me how to do this. or Any similar example would be great. Thanks
Awesome explanation! Easy to remember! By the way, pls charge your Mac :)
C'est top! Meric, Andy.
That was great! Could you make a similar video explaining Level Of Detail expressions?
Once I have the same level of understanding, yes.
I think we all have that barrier.
Awesome!
Does it matters the order of unticking boxes in the red box?
Yes sometimes it does. Read them upside down. So if you have two boxes checked, let’s call them segment and category with segment at the bottom and you have region unchecked. And let’s say you’re using a difference from table calc. You would say something like “Calculate the difference from each region by segment then by category.” Once they are checked and you move them around, that order will stick no matter where you put the fields on the shelves. You could also think of the Region as a group by if you are familiar with Alteryx or SQL.
@@vizwiz is right if I try to imagine this particular case as a table where my rows are Regions and my columns are in the next order Segment->Category?
gre8 very detailed
I gave you 2 likes, Andy, from both of my accounts
🏆