Tableau Table Calculations Explained - Complete Tutorial with Examples | sqlbelle

  Рет қаралды 82,885

sqlbelle

sqlbelle

Күн бұрын

Пікірлер: 210
@McRaeJim
@McRaeJim 4 жыл бұрын
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.
@sqlbelle
@sqlbelle 4 жыл бұрын
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
@ni12907
@ni12907 3 жыл бұрын
which university? you spent a year only learning tableau?
@McRaeJim
@McRaeJim 3 жыл бұрын
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.
@saurrabhsinghkushwaha4684
@saurrabhsinghkushwaha4684 3 жыл бұрын
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.
@michafabich9213
@michafabich9213 2 жыл бұрын
totally agree... sqlbelle is top 3 best tableau teachers I've ever came across
@shraddhaw1537
@shraddhaw1537 2 жыл бұрын
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!!!
@karenzhou1083
@karenzhou1083 Жыл бұрын
This was so clear. I loved that you took us through a sample dataset to demonstrate these functions.
@luisgerardor943
@luisgerardor943 2 жыл бұрын
Sqlbelle, that was great. I join the crowd to praise the work you are doing. Thank you so much!
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you Luis Gerardo! Glad you found the video helpful :)
@jasonchen8486
@jasonchen8486 2 жыл бұрын
This is tutorial is really good. She is one of the best Tableau instructors. Thanks to her, all the video tutorials are free on KZbin.
@teachingntraining
@teachingntraining 2 жыл бұрын
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.
@zeeshanahmed2594
@zeeshanahmed2594 5 ай бұрын
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.
@ivan19541
@ivan19541 2 жыл бұрын
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.
@kaustshroff381
@kaustshroff381 2 жыл бұрын
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.
@sqlbelle
@sqlbelle 2 жыл бұрын
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 :)
@KDB324
@KDB324 4 жыл бұрын
Looking forward to your advanced table calculations video. You really know how to explain something complex in a simple way. Thank you.
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you for your kind note KDB324!
@bimerap5735
@bimerap5735 3 жыл бұрын
@@sqlbelle Can we have it ?
@collardgreens1275
@collardgreens1275 3 жыл бұрын
This video is incredible! This is literally making my day I feel like I am actually understanding and processing the information!
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you! So happy to hear you found it helpful.
@kirikiran
@kirikiran 2 жыл бұрын
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!
@MuhammadKhan-wp9zn
@MuhammadKhan-wp9zn Жыл бұрын
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.
@Chenna_Reddy11
@Chenna_Reddy11 3 жыл бұрын
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
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Chenna! I am glad you found the video helpful!
@michellebannon674
@michellebannon674 4 жыл бұрын
Wow, that was a lot of great information to help me understand the calculations. Thank you.
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you Michelle! Glad you found it helpful 🙂
@bernardarhin2628
@bernardarhin2628 Жыл бұрын
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.
@ravss25
@ravss25 2 жыл бұрын
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! ❤️👌👏
@georginafung7119
@georginafung7119 3 жыл бұрын
ありがとうございます!
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you very much Georgina!
@equiwave80
@equiwave80 3 жыл бұрын
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!!!
@justayoutuber1906
@justayoutuber1906 6 күн бұрын
Great job. You have a very pleasant voice too!
@karlyvanvieux4386
@karlyvanvieux4386 4 жыл бұрын
Keep them coming, to me this is best Channel on Tableau.
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you Karl! Happy you're finding the channel informative :)
@yujielu1928
@yujielu1928 Жыл бұрын
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? 😀
@MekanJuma
@MekanJuma 3 жыл бұрын
Now everything is clear in my mind. Thanks a lot @sqlbelle, you are great instructor
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you - so happy to hear :)
@nellier2155
@nellier2155 3 жыл бұрын
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 .
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Nellie! Happy you found the video helpful :)
@vijayarjunwadkar
@vijayarjunwadkar 3 жыл бұрын
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! 😊👍
@sqlbelle
@sqlbelle 3 жыл бұрын
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 :)
@AdrianaPerez-ev5cj
@AdrianaPerez-ev5cj 3 жыл бұрын
Very clear explanation of table calculations. Thank you!
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Adriana :)
@ahmadkhateeb2519
@ahmadkhateeb2519 3 жыл бұрын
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.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you for your comment, Ahmad!
@nikhithcheavi1665
@nikhithcheavi1665 3 жыл бұрын
Thanks for making it so easy to understand. Waiting for your advanced table calculations. Thanks again
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Nikhith! :)
@sony88hify
@sony88hify 2 жыл бұрын
you are the best teacher of tableau..
@user-rf5yk5hz6d
@user-rf5yk5hz6d Жыл бұрын
The best tableau tutorial video I’ve ever seen❤ from Macau subscriber
@michafabich9213
@michafabich9213 2 жыл бұрын
recommend this for anyone who want to learn tableau, amazing video
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you Michal! :)
@jordantoups3248
@jordantoups3248 Жыл бұрын
thank you sql belle! you are awesome - so calm and clear in your explanations
@jose-alberto-salazar-jimenez
@jose-alberto-salazar-jimenez 2 жыл бұрын
Your explanations are awesome. Thanks for sharing your knowledge.
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you Jose-Alberto!
@yitianwang4233
@yitianwang4233 4 жыл бұрын
Awesome tutorials, much better than some paid ones.
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you for your feedback, Etienne! Much appreciated, as always 🙂
@srem1971
@srem1971 4 жыл бұрын
Great video(s), professionally done. Thanks a lot!
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you @srem1971. I hope you found it useful! :)
@jraj2380
@jraj2380 2 жыл бұрын
Awesome explanation about Table calculations. Thank you so much.
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you Jayaraju D!
@8703sm
@8703sm 2 жыл бұрын
All your videos are amazing! Thank you for your wonderful teaching
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you Suganthi!
@vivianhorak
@vivianhorak 3 жыл бұрын
This is so clear. Help me a lot. Thank you so much for sharing your knowledge.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Vivian
@rajrawat287
@rajrawat287 21 күн бұрын
Simply Amazing teach.more power to you
@1973youness
@1973youness 3 жыл бұрын
Really, one of the best explination I've never seen on the net ... Thanks a lot :-)
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Youness!
@1973youness
@1973youness 3 жыл бұрын
@@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 : kzbin.info/www/bejne/pmKboGmQoMaZiLc at the 43:07 minutes Thanks :-)
@fakeersabnadaf3775
@fakeersabnadaf3775 4 жыл бұрын
Thank you so much for detail explained table calculations.. awaiting for advanced table calculations blog.. Thank you so much for ur effort..
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you for your comment and your feedback fakeersab!
@lillresonates7081
@lillresonates7081 3 жыл бұрын
Madam I'm daily learning my self with your class.. Thanks you..
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Venugopola, glad to hear :)
@santhoshvnr
@santhoshvnr 3 жыл бұрын
Fantastic tutorial, and good preparation for the explanation too.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Santhosh!
@2688Micha
@2688Micha 3 жыл бұрын
awesome. very comprehensive and easy to follow!
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Micha!
@roshanshah5831
@roshanshah5831 3 жыл бұрын
Nice way of teaching !!thank you.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Roshan! :) :)
@ImranAmiKh4n
@ImranAmiKh4n 2 жыл бұрын
Thank you. Very clear and informative
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you Ami!
@sikhasharma1204
@sikhasharma1204 Жыл бұрын
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.
@nikhilsakhare639
@nikhilsakhare639 3 жыл бұрын
Excellent explanation... Love it. Thank you for making such video which easy to understand.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you for your comment, Nikhil! Glad you found the video helpful!
@shashankku.1469
@shashankku.1469 2 жыл бұрын
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).
@magnumbi8396
@magnumbi8396 3 жыл бұрын
Simply Wow!what a magnific lesson!
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you :)
@jolson1204
@jolson1204 2 жыл бұрын
Really good content. Looking forward to an advanced table calc video soon. Super helpful looking at financials over time
@sqlbelle
@sqlbelle 2 жыл бұрын
Thank you John!
@GuruprakashAcademy
@GuruprakashAcademy 2 жыл бұрын
Thank you. Well explained.
@uttamburnwal4662
@uttamburnwal4662 3 жыл бұрын
Thank you so much for this amazing explaination, you are the best.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Uttam! Glad you found the video helpful!
@anaghadamame196
@anaghadamame196 3 жыл бұрын
You helping me a lot ...thank you so much for these detailed videos 😊🙏
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you, I am glad to hear Anagha!
@vdn5716
@vdn5716 4 жыл бұрын
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..
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you VDN! Appreciate your comments and support .. thank you 🙂
@chandrakumarreddyvennapusa7806
@chandrakumarreddyvennapusa7806 4 жыл бұрын
Thank you very much for sharing videos like this :)
@sqlbelle
@sqlbelle 4 жыл бұрын
Glad you like them chandra!
@Guna_cocktail
@Guna_cocktail 3 жыл бұрын
Vow great presentation.. you made it very simple for our understanding.. looking forward for advanced table calculation.. Thank you so much
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Guna! Glad you found the video helpful!
@jaitiwari241
@jaitiwari241 3 жыл бұрын
Nice explanation.. Love from india
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Jai! :)
@jingli5141
@jingli5141 3 жыл бұрын
Excellent explanation, love it.
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Jing!
@AJaditya123
@AJaditya123 4 жыл бұрын
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.
@sqlbelle
@sqlbelle 4 жыл бұрын
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
@shalinigarg859
@shalinigarg859 3 жыл бұрын
Thank you so much for this informative video. It's really helpful. 👍
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Shalini. Glad to hear you found the video helpful!
@kloidulent
@kloidulent 3 жыл бұрын
Another excellent video. Thanks 😊
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you kloidulent!
@ni12907
@ni12907 3 жыл бұрын
Hi Sqlbelle, such an awesome refresher! was wondering if you can please make the advanced table calc video that you were talking about? thanks!
@sqlbelle
@sqlbelle 3 жыл бұрын
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!
@ko3584
@ko3584 3 жыл бұрын
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)
@shashank1337
@shashank1337 4 жыл бұрын
Awesome as ever :) Loved this one. I would also love if you make some videos about LODs :)
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you @Shashank Ohja! I have one LOD video for Part 2 of the Calculations Series: kzbin.info/www/bejne/r6bWmWSvg99sjK8 Thank you for your support and feedback!
@fuscone
@fuscone 3 жыл бұрын
crazy and amazing that this is free
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you :)
@maheshbarma
@maheshbarma 3 жыл бұрын
It is vary useful one , Thanks a lot!
@sqlbelle
@sqlbelle 3 жыл бұрын
Happy you found it useful, Mahesh! Thank you for sharing!
@sharanchuraky6356
@sharanchuraky6356 3 жыл бұрын
It was very useful …..thanks
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Sharan!
@yinkaakinwunmi6014
@yinkaakinwunmi6014 Жыл бұрын
Hi Sqlbelle, could you do a video on this please How to Show Running Total From Beginning date for Last 7 days Tableau? Thanks
@Asuresh392
@Asuresh392 4 жыл бұрын
did you uploaded advanced table calculation?. I couldn't find . Please provide link. Thanks for your video its really useful.
@sqlbelle
@sqlbelle 4 жыл бұрын
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!
@roopali3369
@roopali3369 3 жыл бұрын
can you please a do small session on marks , tooltips in tableau how to use and whats the use of them exactly
@sqlbelle
@sqlbelle 3 жыл бұрын
Great suggestion, thank you. There may be pieces in here that can help as well : kzbin.info/www/bejne/n4TWgomJjct5mc0
@hamidyazdi399
@hamidyazdi399 7 ай бұрын
Great video! Is there a more advance Table Calc video that you've done?
@hamidyazdi399
@hamidyazdi399 7 ай бұрын
I'm looking for how to Edit the table calculations manually
@Blablabla-rq3to
@Blablabla-rq3to Жыл бұрын
Gosh, you are so amazing! Thank you so much!
@Vihan13
@Vihan13 3 жыл бұрын
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
@sqlbelle
@sqlbelle 3 жыл бұрын
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.
@JP-kh6sv
@JP-kh6sv 4 жыл бұрын
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!
@sqlbelle
@sqlbelle 4 жыл бұрын
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.
@JP-kh6sv
@JP-kh6sv 4 жыл бұрын
@@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.
@JP-kh6sv
@JP-kh6sv 4 жыл бұрын
@@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!
@sienna_personal
@sienna_personal 2 жыл бұрын
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?
@sqlbelle
@sqlbelle 2 жыл бұрын
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!
@sienna_personal
@sienna_personal 2 жыл бұрын
@@sqlbelle I see! Thank you so much for the quick reply!
@Universe-xg7ou
@Universe-xg7ou 4 жыл бұрын
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")
@sqlbelle
@sqlbelle 4 жыл бұрын
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.
@Universe-xg7ou
@Universe-xg7ou 4 жыл бұрын
@@sqlbelle Thank you so much!!
@sqlbelle
@sqlbelle 4 жыл бұрын
These are great points. I'll make sure to try and address this clearly in the next table calc videos - thank you for this!
@rxmendxmen567
@rxmendxmen567 4 жыл бұрын
Very useful :)
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you Simon🙂
@sqlbelle
@sqlbelle 3 жыл бұрын
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.
@jimmyf.x.9526
@jimmyf.x.9526 3 жыл бұрын
You are amazing!
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you Jimmy!
@rupasingla9494
@rupasingla9494 3 жыл бұрын
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
@sqlbelle
@sqlbelle 3 жыл бұрын
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 :)
@anasnaser7042
@anasnaser7042 3 жыл бұрын
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
@sqlbelle
@sqlbelle 3 жыл бұрын
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 ..
@tarun007
@tarun007 3 жыл бұрын
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.
@sqlbelle
@sqlbelle 3 жыл бұрын
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!
@havefundrawing
@havefundrawing 4 жыл бұрын
Do you have the advanced table calc already up? Or is it still in the works?
@sqlbelle
@sqlbelle 4 жыл бұрын
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 :)
@chandrakumarreddyvennapusa7806
@chandrakumarreddyvennapusa7806 4 жыл бұрын
Subscribed and Liked waiting for more vidoes :)Mam
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you so much chandra! Another one coming up in a few hours :) Appreciate your note!
@faisalshaikh5856
@faisalshaikh5856 3 жыл бұрын
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
@sqlbelle
@sqlbelle 3 жыл бұрын
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.
@nehabhatia9520
@nehabhatia9520 2 жыл бұрын
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?
@jayasreecarey7843
@jayasreecarey7843 3 жыл бұрын
thank you !
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you for your support Jayasree, and your kind comments!
@laedays
@laedays 2 жыл бұрын
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
@sqlbelle
@sqlbelle 2 жыл бұрын
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.
@laedays
@laedays 2 жыл бұрын
@@sqlbelle thank you so much!! I appreciate your efforts and they are all helpful! Looking forward to your next videos!
@sabyasachiadhikary7138
@sabyasachiadhikary7138 11 ай бұрын
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.
@karlyvanvieux4386
@karlyvanvieux4386 4 жыл бұрын
Do you have another channel for Sql? I do not see any sql videos and I am very interested in improving my skills.
@sqlbelle
@sqlbelle 4 жыл бұрын
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: kzbin.info/www/bejne/apyYgHemq6mNqLs
@kaustshroff381
@kaustshroff381 2 жыл бұрын
When I do "Edit Table Calculations" it just numbers the individual data points. There is NO pop up Table Calculation box. What gives!?
@sqlbelle
@sqlbelle 2 жыл бұрын
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?
@kaustshroff381
@kaustshroff381 2 жыл бұрын
@@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.
@theswarajratan3714
@theswarajratan3714 3 жыл бұрын
Awesome..
@sqlbelle
@sqlbelle 3 жыл бұрын
Thank you ankur!
@priyanshagarwal8490
@priyanshagarwal8490 2 жыл бұрын
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.
@pradeepp9126
@pradeepp9126 3 жыл бұрын
Intro BGM brought me back good old memories... from the show "HOW IT'S MADE" National geography science channel.
@sqlbelle
@sqlbelle 3 жыл бұрын
That is so cool, Pradeep. Thanks for sharing! Now I have to go look for this series and re-listen to the background music :)
@sqlbelle
@sqlbelle 3 жыл бұрын
Super cool! I will have to re-listen the background music again :) Thank you Pradeep!
@chandrakumarreddyvennapusa7806
@chandrakumarreddyvennapusa7806 4 жыл бұрын
Wonderfull but I request you to do more videos on LOD's IN details with real life scenarios :)
@sqlbelle
@sqlbelle 4 жыл бұрын
Thanks Chandra! There will be additional videos on LODs
@あいうえお-y3l3w
@あいうえお-y3l3w Жыл бұрын
Is there "advanced table calculation tutorial"? I couldn't find it.
@rubengeertvandenberg3336
@rubengeertvandenberg3336 2 жыл бұрын
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?
@sqlbelle
@sqlbelle 2 жыл бұрын
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.
@rubengeertvandenberg3336
@rubengeertvandenberg3336 2 жыл бұрын
@@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!
@lillresonates7081
@lillresonates7081 3 жыл бұрын
Madam i have stucked with.. I want to show previous year 2 nd quater june sales only.. How can i get that
@sqlbelle
@sqlbelle 3 жыл бұрын
Please have a look at this, this may help? kzbin.info/www/bejne/hF6vY2mEir2bhpI
@niteshsingh4377
@niteshsingh4377 4 жыл бұрын
mam i have so many question how can i ask you directly...............help me finding a job in this.
@sqlbelle
@sqlbelle 4 жыл бұрын
Please connect with me on LinkedIn Nitesh.
@niteshsingh4377
@niteshsingh4377 4 жыл бұрын
@@sqlbelle i have sent you request yesterday
@youavang1973
@youavang1973 4 жыл бұрын
Great explanation, but the music is rather loud and distracting.
@sqlbelle
@sqlbelle 4 жыл бұрын
Thank you Youa! I've noted the music and will fix in future videos. Thank you for letting me know!
Непосредственно Каха: сумка
0:53
К-Media
Рет қаралды 12 МЛН
Table Calculations in Tableau: Everything You Need to Know
24:54
Andy Kriebel
Рет қаралды 113 М.
Table Calculations: FIRST, LAST, INDEX, RANK | #Tableau Course #100
22:04
10 more Tableau tips and tricks you should know | sqlbelle
11:56
Fixing Tableau Calculation Aggregation Errors
9:36
OneNumber - Tableau Experts
Рет қаралды 6 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 284 М.