I must tell you, I spent a year taking a course from a major University in Tableau. Your presentation and clarity is so good I am considering writing the University and having them send you my first quarter tuition I was robbed. It is you Anthony Smoak and the legendary Andy Kriebel that produce the best videos. Even your intro video I leaned some things Please keep it up.
Hello James, Thank you so much for your note, I very much appreciate it. I learned a lot of things along the way so I am indebted to so many in the Tableau community. There's a lot of positivity in this community and it's amazing. I am happy to hear you found the video useful 🙂 Donabel
Nishi. It is with the University of Washington in Seattle. Part of the University's Continuing education program. The program is a weekly 3 hour on line Zoom type course class called "Certification in Data Visualization". Since Tableau is in Seattle the instructors worked or used to work at Tableau. It's on line. People from around the US were enrolled. If that helps.
Hey James, do u have links to tutorial similar to Anthony Smoak? That has taught me so much. I am trying to replicate/clone sqlbelle tutroial as well.... this cloning technique has taught me a lot. Many in Tableau community do not share Worksheet but only the dashboard. I am looking for such tutorial dispareately.
you actually put not just efforts but also your heart in creating these videos.. you are adding up so much value in my life with such a precise content.. i am seriously following your playlist & i could see myself having a grip on tableau.. thank you so very much! grateful to have such a quality content!!!
Excellent explanation. I am from India and I have started teaching Tableau to management students. (Although I am, myself, still learning it). I find your videos very very helpful in clearing my doubts. You are like a lighthouse in the ocean of youtube videos.
Thank you!!! You are the best. Your explanations are clear and concise. You have saved my life more than once. I have spent tons of hours on Tableau videos and training and I am glad I found you.
Countless others have commented on how phenomenal your videos are, and I couldn't agree more. Your explanation skills are absolutely sublime; your structuring of videos are par none. I took a whole Tableau course on UDemy, yet I still come here to clear up difficult concepts and the nitty gritty topics that the other instructor just breezed by. I highly suggest, you consider teaching in a University; you'd make a lot of students feel accomplished. Thank you.
Hello Kaust, Thank you for this very kind note. I really, really appreciate you taking the time to share this. More than anything I am happy you found the videos helpful. I do teach, not at University but at a local college. I hope my students feel that they're gaining something from my courses :)
Wow, what a video! .Your way of explaining the concept is like preparing all dishes on dining table to have it. Thank you so much, I'm really getting the things from you. I hope you would post more advanced tableau.videos
Thank you - i have been on and about your channel for nearly 8 months now - have learned allot - your handson approach and making the abstract so easy is commendable. Andy Kriebel and that gentleman who taught the dashboard layout design - you are all masters and these are master classes. I still struggle with LODs and SETS - have watched your videos more than a couple times already, am sure will get the hang of it. But, sqlbelle, you are my go to source for all clarifications :-) thank you!
I've watched some of your videos for more than once, or even twice. There are new ahas every time. Thank you! I couldn't find the advanced table calculation tutorial. May I know if this series is still in your list? 😀
Hey I will say a great video, i never saw this kind of confidence and fully control on the topic. i wish if i can find all your tableau video, which i can watch and learn the tableau with great confidence. Thank you once again.
Hi Donabel, I really liked this video. I learned new concepts from this video 1. Adding a secondary calculation to certain Table Calculations 2. Regarding the Table Calc Filters not affecting the actual Table Calculations. I cannot wait for the Advanced Table Calculation video. Thanks for all your efforts!!!
That was such an awesome video on table calculations. The way you explained everything in layman terms makes it so easy to follow. Best videos on tableau ever !!.Please do the video on advanced table calculations .
You explanations are awesome. Your approach of breaking down a complex concept into the fundamentals are really impressive.Thank you Ma'am, for your amazing tutorials.
Hatsoff to sqlbelle! I have never seen anyone explaining table calculation in such depth helping us understand every bit of it! You are incredible mam! Am gonna watch all your videos n am loving it! ❤️👌👏
Thank you for the awesome video. You mentioned at 11:12 that the original numbers will disappear or change the moment table calculations are applied. I want to find out how the original numbers can be placed to the left or right of the new table for comparison purposes.
Love this video! May I know whether the advanced video on table calculations with specific dimensions is out? I can't find it in your channel! Also great if you could cover more on filtering dates without affecting the view (eg table calculation filters)
@@sqlbelle You're welcome, I'd like to suggest you to make a video. I tried to make a basket analysis but with 2 windows which is more intuitive than the one with square in one window, but I did not manage :-( Maybe, if you want to, you could do it. I've been inspired by this video : ruclips.net/video/p18o6ZkafRU/видео.html at the 43:07 minutes Thanks :-)
your video's are amazing , it's very useful and I gain so much knowledge from it , i used to do all the table calculation without any deep understanding of the details of it . thanks so much your effort is highly appreciated.
thanks for the video again crystal clear, can you in future , do a video on types of dashboards and steps for approaching a dashboard solution. for example a data discovery dashboard may have different requirements than a operational dashboard, in my past i have used table calculations for a data discovery dashboard , as you mentioned filters will change the calculations and users were confused.
This is a great suggestion Aditya, thank you. For sure I will look at creating a series on crafting the dashboards. In my experience, it has always been a collaborative approach. My team works very closely with other functional groups, and we go through iterations. We try to focus on requirements in these cross functional meetings and I've found that that helps. It also influences the strategy for our deployment. Donabel
Thank you Nishi, I have it in my queue. I do have a few other topics that I am planning to produce before that. Thank you for your feedback and support, much appreciated!
Don't know how I missed this fantastic video, but glad I found it now! Take a bow Donabel, you are master of Tableau and a savior for me! Love the way you explain and make one understand so thoroughly! 😊👍
All are praising you fir your work ..you must think it series and help us more regarding this ..please make advanced course on udemy ..waiting like anything..
As always, it's a great video. I haven't found any other video the way you explain in each and every video. Thank you so much putting all your effort and time to simplify each and every concept in Tableau. If possible could you please make advance level of " Table Calculations" Video because this is one of the difficult topic to grasp.
Really mam you are such a good teacher..the way you explain things is awesome...Eagerly waiting for more such videos on defferent topics (Parameters, Advance table Calculations, sets).
Thank you @Shashank Ohja! I have one LOD video for Part 2 of the Calculations Series: ruclips.net/video/yush1yNz9VM/видео.html Thank you for your support and feedback!
Mam I really want to say this….while watching your videos my husband is just sitting aside me and he said m getting really positive wives…your way of explanation is so perfect…you can miss tiny things to explain but you explained every tidbits too nice …thank so much
Rupa - thank you so much for your very kind note. I appreciate what you shared and appreciate you took the time to share it. I wish you all the best :)
Thank you for such a clear demonstration. Could you please explain further the following topics in "Table Calculation"? 1. At the level (eg. Deepest, etc) 2. Sort Order (Specific Dimensions, etc) 3. Add Secondary Calculation (in case of "Running Total")
Thank you. These will be included in the Advanced Table Calc videos. To answer briefly though: 1. "At the level" - when you lock the dimensions, or when you select specific dimensions, you can also specify how granular the calculation should be 2. Sort Order - you can decide to order the calculations using specific fields (for example, in a running total, you may decide to do the cumulative value direction based on an aggregation (add all values in descending order, add all values in ascending order etc) 3. Secondary Calculation - adding one more calculation on top of the result of a previous table calculation Hopefully this helps for now.
Mam..waiting for your next video.let us know on what topic is it going to be on?post more videos best tutorial ever seen.you are amazing and we are blessed to learn much from you
Thank you! I posted the next video topic and screenshot under the "Community tab" (although the demo has already changed a little bit). Next topic is about enhancing text tables, and adding KPIs, sparklines and conditional formatting. It should be published in the next day or two.
Agree, very informative tutorial. Question; regarding calculations, can you address and do a walkthrough on how to calculate employee turnover from a month-to-month perspective? I have no trouble getting the current month ending headcount but can’t seem to get a calculation to work that gives me prior month headcount. I need the different to then calculate the average and use for the Turnover calculation. Any feedback you can provide would be greatly appreciated!
Thank you John, I can try and create a tutorial to turnover or something similar. Depending on how your table/viz is laid out, you can try using the LOOKUP function, something like: LOOKUP(SUM(headcount), -1) for previous month.
@@sqlbelle Thanks for the quick reply! I think I've tried that example but I'll try again and confirm. In the meantime, I will keep enjoying your videos. Love your work and appreciate the time and energy you dedicate to the subject matter! Appreciate it very much.
@@sqlbelle Hi again, If you don't mind, I'll send an invite via LinkedIn so we can connect there. I can provide specific worksheet I'm working on to detail my issue with the Turnover calculation. Is this okay with you? I'll await your response on Linked In. Thank you!
Great video on table calcs! really informative. Are you planning to make video on 10 impTable calculations of Tableau as you did for 15 imp LOD problems?
Great video, you said about fixing the dimension in Table calc, so that the calculation are not re-calculated, when filtered with dimensions and measures. When are you coming up with that video. Hope to hear from you soon.
Thank you Tarun. I plan to finish up the LOD series first (will be 3 parts, first video will be published today), and then tackle table calculations. Thank you for your support!
Having a question regarding table calculations, what is the difference in quick table calculations and table calculations. and also waiting for advanced table calculations vedio
Hello Faisal - these two are technically the same. The Quick Table Calculations are the ones pre-defined by Tableau (when you right click on a measure pull, you will see Quick Table Calculations). Table Calculations are all these calculations, which could be quick table calcs, or ones that you construct yourself from scratch.
Hello icedventimocha! I don't have the advanced table calc video(s) yet. I have a few other videos in the queue (the new one will be out by tomorrow), hopefully you will find them useful as well :)
Thank you for the fantastic videos! They are so well organized and easy to follow. I really enjoy watching your tutorials. I do have a question about "Compute Using Cell". Is there any practical example where we should use it? For example, If we use % of the total and compute using cell, it will return 100% for each cell. If we calculate rank, then it will return 1 for each cell. So what is the practical use of this function?
Thank you Sienna. Depending on your layout, a "cell" can still be a composition (for example, imagine a cell that has only Yes/No values). Per cell can be helpful with 100% stacked charts, for example something like this: www.perceptualedge.com/blog/wp-content/uploads/2015/08/Womens-Equality-Day-Infographic-Redesigned.jpg Glad you are finding the videos helpful!
I started watching your channel and it is awesome , but the definition of the pane is not clear for me ,which you said it determined by the second to the last dimension you see in the view
Thank you Anas. Notice what happens when you place at least 2 discrete dimensions in your view - do you notice (visually) a grouping that shows up? That's the pane ..
Hi Mam - Could you please send me the link of Advance table calculations video. Your video is mind blowing. No one can teach like that or in that way how you do Please help me. please send me the link of the Advance table calculation video.
Hi Karl, I have one video (for now) on SQL. I have been planning to add more but just have not had the time to do both Tableau and SQL videos in a week. I plan to add more this year, I have a few topics lined up. Here is my video on joins: ruclips.net/video/4k5ODpvDZrY/видео.html
How to get % difference from maximum value, lets say we wanted to know the maximum sales and then how much is my current month sales difference % from maximum month, and maximum sales will be dynamic, can you help me out here.
Is it always going to re-calculate based on the filter applied or is there a way to have it fixed regardless of the filter? One similarity i can think of is like a show/hide capability. When we hide something, it does not neccesarily recalculates the value
Hey Patrick. If you are simply hiding, these wont cause table calcs to re-calculate. Regular dimension and measure filters though will cause it to re-calculate. The one filter that won't affect it is what we call late filter (or table calc filter) - which is the very last operation in this order of operations hierarchy: help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm Hope this helps.
Hello Kaust - sometimes what happens to me is the window shows up behind another open window. Could this be the case? Which table calculation function are you trying this on?
@@sqlbelle Yep you were right. I was using 3 external screens and I did not realize the pop up window was showing up on my laptop... Thank you so much.
I find it strange that a moving average over current and 5 previous time points does not generate null values for the first 5 time points. These don't have any previous 5 time points. The null value for %difference makes more sense but is inconsistent with how a moving average handles missing previous values. Or am I missing something?
Hello Ruben. That is an option for table calculations. The default is to calculate even if there are not enough points (for example if it's a 3 time point moving average, the first value will only be divided by 1; second value will be divided by 2 etc) When you edit the table calculation, there is an option to NULL the values until there is enough points. In which case, first and second points will be NULL. It's only the third point that starts getting value. Hope this helps.
@@sqlbelle Thanks for letting me know, I'll try and make that work! P.s. your work is outstanding. My only remark is that I couldn't find some of the raw data for replicating all examples. I (and perhaps many others) would be perfectly happy to pay for those, perhaps via your gumroad profile? Keep up the great work! Big hug from Amsterdam!
I must tell you, I spent a year taking a course from a major University in Tableau. Your presentation and clarity is so good I am considering writing the University and having them send you my first quarter tuition I was robbed.
It is you Anthony Smoak and the legendary Andy Kriebel that produce the best videos. Even your intro video I leaned some things Please keep it up.
Hello James,
Thank you so much for your note, I very much appreciate it. I learned a lot of things along the way so I am indebted to so many in the Tableau community. There's a lot of positivity in this community and it's amazing.
I am happy to hear you found the video useful 🙂
Donabel
which university? you spent a year only learning tableau?
Nishi. It is with the University of Washington in Seattle. Part of the University's Continuing education program. The program is a weekly 3 hour on line Zoom type course class called "Certification in Data Visualization". Since Tableau is in Seattle the instructors worked or used to work at Tableau. It's on line. People from around the US were enrolled. If that helps.
Hey James, do u have links to tutorial similar to Anthony Smoak? That has taught me so much. I am trying to replicate/clone sqlbelle tutroial as well.... this cloning technique has taught me a lot. Many in Tableau community do not share Worksheet but only the dashboard.
I am looking for such tutorial dispareately.
totally agree... sqlbelle is top 3 best tableau teachers I've ever came across
you actually put not just efforts but also your heart in creating these videos.. you are adding up so much value in my life with such a precise content.. i am seriously following your playlist & i could see myself having a grip on tableau.. thank you so very much! grateful to have such a quality content!!!
This was so clear. I loved that you took us through a sample dataset to demonstrate these functions.
This is tutorial is really good. She is one of the best Tableau instructors. Thanks to her, all the video tutorials are free on RUclips.
Sqlbelle, that was great. I join the crowd to praise the work you are doing. Thank you so much!
Thank you Luis Gerardo! Glad you found the video helpful :)
Excellent explanation.
I am from India and I have started teaching Tableau to management students. (Although I am, myself, still learning it).
I find your videos very very helpful in clearing my doubts.
You are like a lighthouse in the ocean of youtube videos.
you are the best teacher of tableau..
Thank you!!! You are the best. Your explanations are clear and concise. You have saved my life more than once. I have spent tons of hours on Tableau videos and training and I am glad I found you.
Countless others have commented on how phenomenal your videos are, and I couldn't agree more. Your explanation skills are absolutely sublime; your structuring of videos are par none. I took a whole Tableau course on UDemy, yet I still come here to clear up difficult concepts and the nitty gritty topics that the other instructor just breezed by. I highly suggest, you consider teaching in a University; you'd make a lot of students feel accomplished.
Thank you.
Hello Kaust, Thank you for this very kind note. I really, really appreciate you taking the time to share this. More than anything I am happy you found the videos helpful. I do teach, not at University but at a local college. I hope my students feel that they're gaining something from my courses :)
Looking forward to your advanced table calculations video. You really know how to explain something complex in a simple way. Thank you.
Thank you for your kind note KDB324!
@@sqlbelle Can we have it ?
Awesome tutorials, much better than some paid ones.
Thank you for your feedback, Etienne! Much appreciated, as always 🙂
recommend this for anyone who want to learn tableau, amazing video
Thank you Michal! :)
Wow, what a video! .Your way of explaining the concept is like preparing all dishes on dining table to have it. Thank you so much, I'm really getting the things from you. I hope you would post more advanced tableau.videos
Thank you Chenna! I am glad you found the video helpful!
Keep them coming, to me this is best Channel on Tableau.
Thank you Karl! Happy you're finding the channel informative :)
This video is incredible! This is literally making my day I feel like I am actually understanding and processing the information!
Thank you! So happy to hear you found it helpful.
Wow, that was a lot of great information to help me understand the calculations. Thank you.
Thank you Michelle! Glad you found it helpful 🙂
Very clear explanation of table calculations. Thank you!
Thank you Adriana :)
Thank you - i have been on and about your channel for nearly 8 months now - have learned allot - your handson approach and making the abstract so easy is commendable. Andy Kriebel and that gentleman who taught the dashboard layout design - you are all masters and these are master classes.
I still struggle with LODs and SETS - have watched your videos more than a couple times already, am sure will get the hang of it.
But, sqlbelle, you are my go to source for all clarifications :-) thank you!
I've watched some of your videos for more than once, or even twice. There are new ahas every time. Thank you! I couldn't find the advanced table calculation tutorial. May I know if this series is still in your list? 😀
Hey I will say a great video, i never saw this kind of confidence and fully control on the topic. i wish if i can find all your tableau video, which i can watch and learn the tableau with great confidence. Thank you once again.
Hi Donabel,
I really liked this video.
I learned new concepts from this video
1. Adding a secondary calculation to certain Table Calculations
2. Regarding the Table Calc Filters not affecting the actual Table Calculations.
I cannot wait for the Advanced Table Calculation video.
Thanks for all your efforts!!!
Now everything is clear in my mind. Thanks a lot @sqlbelle, you are great instructor
Thank you - so happy to hear :)
Thanks for making it so easy to understand. Waiting for your advanced table calculations. Thanks again
Thank you Nikhith! :)
ありがとうございます！
Thank you very much Georgina!
That was such an awesome video on table calculations. The way you explained everything in layman terms makes it so easy to follow. Best videos on tableau ever !!.Please do the video on advanced table calculations .
Thank you Nellie! Happy you found the video helpful :)
The best tableau tutorial video I’ve ever seen❤ from Macau subscriber
awesome. very comprehensive and easy to follow!
Thank you Micha!
Your explanations are awesome. Thanks for sharing your knowledge.
Thank you Jose-Alberto!
You explanations are awesome. Your approach of breaking down a complex concept into the fundamentals are really impressive.Thank you Ma'am, for your amazing tutorials.
All your videos are amazing! Thank you for your wonderful teaching
Thank you Suganthi!
Awesome explanation about Table calculations. Thank you so much.
Thank you Jayaraju D!
Great video(s), professionally done. Thanks a lot!
Thank you @srem1971. I hope you found it useful! :)
Simply Wow!what a magnific lesson!
Thank you :)
Hatsoff to sqlbelle! I have never seen anyone explaining table calculation in such depth helping us understand every bit of it! You are incredible mam! Am gonna watch all your videos n am loving it! ❤️👌👏
thank you sql belle! you are awesome - so calm and clear in your explanations
Fantastic tutorial, and good preparation for the explanation too.
Thank you Santhosh!
Thank you so much for detail explained table calculations.. awaiting for advanced table calculations blog.. Thank you so much for ur effort..
Thank you for your comment and your feedback fakeersab!
Thank you for the awesome video. You mentioned at 11:12 that the original numbers will disappear or change the moment table calculations are applied. I want to find out how the original numbers can be placed to the left or right of the new table for comparison purposes.
Nice way of teaching !!thank you.
Thank you Roshan! :) :)
Love this video! May I know whether the advanced video on table calculations with specific dimensions is out? I can't find it in your channel! Also great if you could cover more on filtering dates without affecting the view (eg table calculation filters)
This is so clear. Help me a lot. Thank you so much for sharing your knowledge.
Thank you Vivian
Really, one of the best explination I've never seen on the net ... Thanks a lot :-)
Thank you Youness!
@@sqlbelle You're welcome, I'd like to suggest you to make a video. I tried to make a basket analysis but with 2 windows which is more intuitive than the one with square in one window, but I did not manage :-(
Maybe, if you want to, you could do it. I've been inspired by this video : ruclips.net/video/p18o6ZkafRU/видео.html at the 43:07 minutes
Thanks :-)
your video's are amazing , it's very useful and I gain so much knowledge from it , i used to do all the table calculation without any deep understanding of the details of it .
thanks so much your effort is highly appreciated.
Thank you for your comment, Ahmad!
Thank you. Very clear and informative
Thank you Ami!
Excellent explanation, love it.
Thank you Jing!
thanks for the video again crystal clear, can you in future , do a video on types of dashboards and steps for approaching a dashboard solution. for example a data discovery dashboard may have different requirements than a operational dashboard, in my past i have used table calculations for a data discovery dashboard , as you mentioned filters will change the calculations and users were confused.
This is a great suggestion Aditya, thank you. For sure I will look at creating a series on crafting the dashboards.
In my experience, it has always been a collaborative approach. My team works very closely with other functional groups, and we go through iterations. We try to focus on requirements in these cross functional meetings and I've found that that helps. It also influences the strategy for our deployment.
Donabel
Hi Sqlbelle, such an awesome refresher! was wondering if you can please make the advanced table calc video that you were talking about? thanks!
Thank you Nishi, I have it in my queue. I do have a few other topics that I am planning to produce before that. Thank you for your feedback and support, much appreciated!
Nice explanation.. Love from india
Thank you Jai! :)
Don't know how I missed this fantastic video, but glad I found it now! Take a bow Donabel, you are master of Tableau and a savior for me! Love the way you explain and make one understand so thoroughly! 😊👍
Thank you again, Vijay! Glad you are finding nuggets of info in the videos that are still helpful even if you're already familiar with Tableau :)
Really good content. Looking forward to an advanced table calc video soon. Super helpful looking at financials over time
Thank you John!
Thank you. Well explained.
Madam I'm daily learning my self with your class..
Thanks you..
Thank you Venugopola, glad to hear :)
Thank you very much for sharing videos like this :)
Glad you like them chandra!
All are praising you fir your work ..you must think it series and help us more regarding this ..please make advanced course on udemy ..waiting like anything..
Thank you VDN! Appreciate your comments and support .. thank you 🙂
Excellent explanation... Love it.
Thank you for making such video which easy to understand.
Thank you for your comment, Nikhil! Glad you found the video helpful!
As always, it's a great video. I haven't found any other video the way you explain in each and every video. Thank you so much putting all your effort and time to simplify each and every concept in Tableau. If possible could you please make advance level of " Table Calculations" Video because this is one of the difficult topic to grasp.
crazy and amazing that this is free
Thank you :)
Really mam you are such a good teacher..the way you explain things is awesome...Eagerly waiting for more such videos on defferent topics (Parameters, Advance table Calculations, sets).
Another excellent video. Thanks 😊
Thank you kloidulent!
Thank you so much for this amazing explaination, you are the best.
Thank you Uttam! Glad you found the video helpful!
Awesome as ever :) Loved this one. I would also love if you make some videos about LODs :)
Thank you @Shashank Ohja! I have one LOD video for Part 2 of the Calculations Series: ruclips.net/video/yush1yNz9VM/видео.html
Thank you for your support and feedback!
It is vary useful one , Thanks a lot!
Happy you found it useful, Mahesh! Thank you for sharing!
Vow great presentation.. you made it very simple for our understanding.. looking forward for advanced table calculation.. Thank you so much
Thank you Guna! Glad you found the video helpful!
It was very useful …..thanks
Thank you Sharan!
Mam I really want to say this….while watching your videos my husband is just sitting aside me and he said m getting really positive wives…your way of explanation is so perfect…you can miss tiny things to explain but you explained every tidbits too nice …thank so much
Rupa - thank you so much for your very kind note. I appreciate what you shared and appreciate you took the time to share it. I wish you all the best :)
You helping me a lot ...thank you so much for these detailed videos 😊🙏
Thank you, I am glad to hear Anagha!
Hi Sqlbelle, could you do a video on this please How to Show Running Total From Beginning date for Last 7 days Tableau? Thanks
Thank you for such a clear demonstration. Could you please explain further the following topics in "Table Calculation"?
1. At the level (eg. Deepest, etc)
2. Sort Order (Specific Dimensions, etc)
3. Add Secondary Calculation (in case of "Running Total")
Thank you. These will be included in the Advanced Table Calc videos.
To answer briefly though:
1. "At the level" - when you lock the dimensions, or when you select specific dimensions, you can also specify how granular the calculation should be
2. Sort Order - you can decide to order the calculations using specific fields (for example, in a running total, you may decide to do the cumulative value direction based on an aggregation (add all values in descending order, add all values in ascending order etc)
3. Secondary Calculation - adding one more calculation on top of the result of a previous table calculation
Hopefully this helps for now.
@@sqlbelle Thank you so much!!
These are great points. I'll make sure to try and address this clearly in the next table calc videos - thank you for this!
Mam..waiting for your next video.let us know on what topic is it going to be on?post more videos best tutorial ever seen.you are amazing and we are blessed to learn much from you
Thank you! I posted the next video topic and screenshot under the "Community tab" (although the demo has already changed a little bit). Next topic is about enhancing text tables, and adding KPIs, sparklines and conditional formatting. It should be published in the next day or two.
Agree, very informative tutorial. Question; regarding calculations, can you address and do a walkthrough on how to calculate employee turnover from a month-to-month perspective? I have no trouble getting the current month ending headcount but can’t seem to get a calculation to work that gives me prior month headcount. I need the different to then calculate the average and use for the Turnover calculation.
Any feedback you can provide would be greatly appreciated!
Thank you John, I can try and create a tutorial to turnover or something similar.
Depending on how your table/viz is laid out, you can try using the LOOKUP function, something like:
LOOKUP(SUM(headcount), -1) for previous month.
@@sqlbelle Thanks for the quick reply! I think I've tried that example but I'll try again and confirm. In the meantime, I will keep enjoying your videos. Love your work and appreciate the time and energy you dedicate to the subject matter! Appreciate it very much.
@@sqlbelle Hi again, If you don't mind, I'll send an invite via LinkedIn so we can connect there. I can provide specific worksheet I'm working on to detail my issue with the Turnover calculation. Is this okay with you? I'll await your response on Linked In.
Thank you!
Great video on table calcs! really informative. Are you planning to make video on 10 impTable calculations of Tableau as you did for 15 imp LOD problems?
Great video! Is there a more advance Table Calc video that you've done?
I'm looking for how to Edit the table calculations manually
Great video, you said about fixing the dimension in Table calc, so that the calculation are not re-calculated, when filtered with dimensions and measures. When are you coming up with that video. Hope to hear from you soon.
Thank you Tarun. I plan to finish up the LOD series first (will be 3 parts, first video will be published today), and then tackle table calculations. Thank you for your support!
Gosh, you are so amazing! Thank you so much!
can you please a do small session on marks , tooltips in tableau how to use and whats the use of them exactly
Great suggestion, thank you. There may be pieces in here that can help as well : ruclips.net/video/iSsQVSXfFck/видео.html
Thank you so much for this informative video. It's really helpful. 👍
Thank you Shalini. Glad to hear you found the video helpful!
Having a question regarding table calculations, what is the difference in quick table calculations and table calculations. and also waiting for advanced table calculations vedio
Hello Faisal - these two are technically the same. The Quick Table Calculations are the ones pre-defined by Tableau (when you right click on a measure pull, you will see Quick Table Calculations). Table Calculations are all these calculations, which could be quick table calcs, or ones that you construct yourself from scratch.
Very useful :)
Thank you Simon🙂
Simon, somehow I thought I saw a new comment/question from you, but when I look for it, I can't seem to find it.
did you uploaded advanced table calculation?. I couldn't find . Please provide link. Thanks for your video its really useful.
Hello Aparna, I don't have the advanced table calculation yet, but I have it planned for the next few weeks. Thank you for your support!
You are amazing!
Thank you Jimmy!
Do you have the advanced table calc already up? Or is it still in the works?
Hello icedventimocha! I don't have the advanced table calc video(s) yet. I have a few other videos in the queue (the new one will be out by tomorrow), hopefully you will find them useful as well :)
Thank you for the fantastic videos! They are so well organized and easy to follow. I really enjoy watching your tutorials.
I do have a question about "Compute Using Cell". Is there any practical example where we should use it?
For example, If we use % of the total and compute using cell, it will return 100% for each cell. If we calculate rank, then it will return 1 for each cell.
So what is the practical use of this function?
Thank you Sienna. Depending on your layout, a "cell" can still be a composition (for example, imagine a cell that has only Yes/No values). Per cell can be helpful with 100% stacked charts, for example something like this: www.perceptualedge.com/blog/wp-content/uploads/2015/08/Womens-Equality-Day-Infographic-Redesigned.jpg
Glad you are finding the videos helpful!
@@sqlbelle I see! Thank you so much for the quick reply!
I started watching your channel and it is awesome , but the definition of the pane is not clear for me ,which you said it determined by the second to the last dimension you see in the view
Thank you Anas. Notice what happens when you place at least 2 discrete dimensions in your view - do you notice (visually) a grouping that shows up? That's the pane ..
Hi Mam - Could you please send me the link of Advance table calculations video. Your video is mind blowing. No one can teach like that or in that way how you do Please help me. please send me the link of the Advance table calculation video.
Subscribed and Liked waiting for more vidoes :)Mam
Thank you so much chandra! Another one coming up in a few hours :) Appreciate your note!
Intro BGM brought me back good old memories... from the show "HOW IT'S MADE" National geography science channel.
That is so cool, Pradeep. Thanks for sharing! Now I have to go look for this series and re-listen to the background music :)
Super cool! I will have to re-listen the background music again :) Thank you Pradeep!
thank you !
Thank you for your support Jayasree, and your kind comments!
Wonderfull but I request you to do more videos on LOD's IN details with real life scenarios :)
Thanks Chandra! There will be additional videos on LODs
Do you have another channel for Sql? I do not see any sql videos and I am very interested in improving my skills.
Hi Karl, I have one video (for now) on SQL. I have been planning to add more but just have not had the time to do both Tableau and SQL videos in a week. I plan to add more this year, I have a few topics lined up.
Here is my video on joins:
ruclips.net/video/4k5ODpvDZrY/видео.html
How to get % difference from maximum value, lets say we wanted to know the maximum sales and then how much is my current month sales difference % from maximum month, and maximum sales will be dynamic, can you help me out here.
Is it always going to re-calculate based on the filter applied or is there a way to have it fixed regardless of the filter?
One similarity i can think of is like a show/hide capability. When we hide something, it does not neccesarily recalculates the value
Hey Patrick. If you are simply hiding, these wont cause table calcs to re-calculate. Regular dimension and measure filters though will cause it to re-calculate. The one filter that won't affect it is what we call late filter (or table calc filter) - which is the very last operation in this order of operations hierarchy: help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
Hope this helps.
@@sqlbelle thank you so much!! I appreciate your efforts and they are all helpful! Looking forward to your next videos!
Awesome..
Thank you ankur!
When I do "Edit Table Calculations" it just numbers the individual data points. There is NO pop up Table Calculation box. What gives!?
Hello Kaust - sometimes what happens to me is the window shows up behind another open window. Could this be the case? Which table calculation function are you trying this on?
@@sqlbelle Yep you were right. I was using 3 external screens and I did not realize the pop up window was showing up on my laptop... Thank you so much.
Is there "advanced table calculation tutorial"? I couldn't find it.
Madam i have stucked with..
I want to show previous year 2 nd quater june sales only..
How can i get that
Please have a look at this, this may help? ruclips.net/video/N-L26NUXhP0/видео.html
Great explanation, but the music is rather loud and distracting.
Thank you Youa! I've noted the music and will fix in future videos. Thank you for letting me know!
I find it strange that a moving average over current and 5 previous time points does not generate null values for the first 5 time points. These don't have any previous 5 time points.
The null value for %difference makes more sense but is inconsistent with how a moving average handles missing previous values.
Or am I missing something?
Hello Ruben. That is an option for table calculations. The default is to calculate even if there are not enough points (for example if it's a 3 time point moving average, the first value will only be divided by 1; second value will be divided by 2 etc)
When you edit the table calculation, there is an option to NULL the values until there is enough points. In which case, first and second points will be NULL. It's only the third point that starts getting value.
Hope this helps.
@@sqlbelle Thanks for letting me know, I'll try and make that work!
P.s. your work is outstanding. My only remark is that I couldn't find some of the raw data for replicating all examples.
I (and perhaps many others) would be perfectly happy to pay for those, perhaps via your gumroad profile?
Keep up the great work! Big hug from Amsterdam!
mam i have so many question how can i ask you directly...............help me finding a job in this.
Please connect with me on LinkedIn Nitesh.
@@sqlbelle i have sent you request yesterday
the music drive people nuts
You are just magnificent