Tableau Table Calculations Explained - Complete Tutorial with Examples | sqlbelle

Подписаться 120 тыс.

Просмотров 78 тыс.

50% 1

Practice Questions and other digital products
sqlbelle.gumroad.com
This is a comprehensive tutorial that explains Table Calculations in Tableau, Part 3 of the calculations series.
Tableau Calculations Series in sqlbelle channel:
Part 1 - Basic and Aggregate Calculations
• Learn Tableau Basic Ca...
Part 2 - Level of Detail Expressions - FIXED, INCLUDE, EXCLUDE - Complete Tutorial
• Tableau LOD (Level of ...
Part 3 - Table Calculations
• Tableau Table Calculat...
We will cover what table calculations are, how to add to use quick table calculations, some gotchas in using table calculations. We will also look at the significance of Tableau's order of operations for table calculations, and the concept of table filtering. We will walk through different examples using running total, moving average, percent difference and secondary table calculations. Each example is explained step-by-step. Whether you are a beginner looking for basics, or advanced and looking for a refresher, this video will give you a good foundation on Tableau Table Calculations.
Related Videos:
10 Tableau tricks you should know
• 10 Tableau tricks you ...
Sections:
0:00 - Intro
1:52 - What are Table Calculations?
2:56 - Simplified Walkthrough of Table Calculations
7:21 - Factors that affect table calculations
8:21 - First Tableau Walkthrough - Percent of Total
12:03 - Demo - Factors that affect table calculations
16:52 - Recommendation when working with table calculations
19:00 - Specific Dimensions
19:36 - Bigger Demo - Moving Average, Percent Difference, Running Total
24:05 - Secondary Table Calculations
24:47 - Tableau Order of Operations - Late Filtering

Наука

Опубликовано:

7 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 207

@McRaeJim 3 года назад

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 3 года назад

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 3 года назад

which university? you spent a year only learning tableau?

@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 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 2 года назад

totally agree... sqlbelle is top 3 best tableau teachers I've ever came across

@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 Год назад

This was so clear. I loved that you took us through a sample dataset to demonstrate these functions.

@kirikiran Год назад

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!

@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.

@teachingntraining Год назад

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.

@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 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 :)

@ravss25 Год назад

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! ❤️👌👏

@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 RU-vid.

@equiwave80 2 года назад

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!!!

@user-rf5yk5hz6d Год назад

The best tableau tutorial video I’ve ever seen❤ from Macau subscriber

@collardgreens1275 2 года назад

This video is incredible! This is literally making my day I feel like I am actually understanding and processing the information!

@sqlbelle 2 года назад

Thank you! So happy to hear you found it helpful.

@luisgerardor943 2 года назад

Sqlbelle, that was great. I join the crowd to praise the work you are doing. Thank you so much!

@sqlbelle 2 года назад

Thank you Luis Gerardo! Glad you found the video helpful :)

@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 3 года назад

Thank you Nellie! Happy you found the video helpful :)

@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 2 года назад

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 2 года назад

Thank you Chenna! I am glad you found the video helpful!

@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 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 3 года назад

Looking forward to your advanced table calculations video. You really know how to explain something complex in a simple way. Thank you.

@sqlbelle 3 года назад

Thank you for your kind note KDB324!

@bimerap5735 2 года назад

@@sqlbelle Can we have it ?

@michellebannon674 3 года назад

Wow, that was a lot of great information to help me understand the calculations. Thank you.

@sqlbelle 3 года назад

Thank you Michelle! Glad you found it helpful 🙂

@MekanJuma 3 года назад

Now everything is clear in my mind. Thanks a lot @sqlbelle, you are great instructor

@sqlbelle 3 года назад

Thank you - so happy to hear :)

@jordantoups3248 Год назад

thank you sql belle! you are awesome - so calm and clear in your explanations

@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? 😀

@sony88hify Год назад

you are the best teacher of tableau..

@srem1971 3 года назад

Great video(s), professionally done. Thanks a lot!

@sqlbelle 3 года назад

Thank you @srem1971. I hope you found it useful! :)

@jraj2380 2 года назад

Awesome explanation about Table calculations. Thank you so much.

@sqlbelle 2 года назад

Thank you Jayaraju D!

@ahmadkhateeb2519 2 года назад

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 2 года назад

Thank you for your comment, Ahmad!

@karlyvanvieux4386 3 года назад

Keep them coming, to me this is best Channel on Tableau.

@sqlbelle 3 года назад

Thank you Karl! Happy you're finding the channel informative :)

@ko3584 2 года назад

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)

@fakeersabnadaf3775 3 года назад

Thank you so much for detail explained table calculations.. awaiting for advanced table calculations blog.. Thank you so much for ur effort..

@sqlbelle 3 года назад

Thank you for your comment and your feedback fakeersab!

@nikhithcheavi1665 3 года назад

Thanks for making it so easy to understand. Waiting for your advanced table calculations. Thanks again

@sqlbelle 3 года назад

Thank you Nikhith! :)

@jolson1204 2 года назад

Really good content. Looking forward to an advanced table calc video soon. Super helpful looking at financials over time

@sqlbelle 2 года назад

Thank you John!

@michafabich9213 2 года назад

recommend this for anyone who want to learn tableau, amazing video

@sqlbelle 2 года назад

Thank you Michal! :)

@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).

@yitianwang4233 3 года назад

Awesome tutorials, much better than some paid ones.

@sqlbelle 3 года назад

Thank you for your feedback, Etienne! Much appreciated, as always 🙂

@suganthimadhu8703 2 года назад

All your videos are amazing! Thank you for your wonderful teaching

@sqlbelle 2 года назад

Thank you Suganthi!

@AdrianaPerez-ev5cj 2 года назад

Very clear explanation of table calculations. Thank you!

@sqlbelle 2 года назад

Thank you Adriana :)

@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.

@2688Micha 2 года назад

awesome. very comprehensive and easy to follow!

@sqlbelle 2 года назад

Thank you Micha!

@GuruprakashAcademy Год назад

Thank you. Well explained.

@vivianhorak 2 года назад

This is so clear. Help me a lot. Thank you so much for sharing your knowledge.

@sqlbelle 2 года назад

Thank you Vivian

@nikhilsakhare639 3 года назад

Excellent explanation... Love it. Thank you for making such video which easy to understand.

@sqlbelle 3 года назад

Thank you for your comment, Nikhil! Glad you found the video helpful!

@SwethaNandyala-sf9lt Год назад

THANK YOU SO MUCH FOR YOUR INFORMATIVE VIDEO

@jose-alberto-salazar-jimenez 2 года назад

Your explanations are awesome. Thanks for sharing your knowledge.

@sqlbelle 2 года назад

Thank you Jose-Alberto!

@magnumbi8396 2 года назад

Simply Wow!what a magnific lesson!

@sqlbelle 2 года назад

Thank you :)

@Blablabla-rq3to Год назад

Gosh, you are so amazing! Thank you so much!

@roshanshah5831 3 года назад

Nice way of teaching !!thank you.

@sqlbelle 3 года назад

Thank you Roshan! :) :)

@ImranAmiKh4n 2 года назад

Thank you. Very clear and informative

@sqlbelle 2 года назад

Thank you Ami!

@chandrakumarreddyvennapusa7806 3 года назад

Thank you very much for sharing videos like this :)

@sqlbelle 3 года назад

Glad you like them chandra!

@santhoshvnr 2 года назад

Fantastic tutorial, and good preparation for the explanation too.

@sqlbelle 2 года назад

Thank you Santhosh!

@shashank1337 3 года назад

Awesome as ever :) Loved this one. I would also love if you make some videos about LODs :)

@sqlbelle 3 года назад

Thank you @Shashank Ohja! I have one LOD video for Part 2 of the Calculations Series: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yush1yNz9VM.html Thank you for your support and feedback!

@jingli5141 3 года назад

Excellent explanation, love it.

@sqlbelle 3 года назад

Thank you Jing!

@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 3 года назад

Thank you Guna! Glad you found the video helpful!

@1973youness 3 года назад

Really, one of the best explination I've never seen on the net ... Thanks a lot :-)

@sqlbelle 3 года назад

Thank you Youness!

@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 : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p18o6ZkafRU.html at the 43:07 minutes Thanks :-)

@Wardaddy3 2 дня назад

Great video. Thank you so much!

@anaghadamame196 2 года назад

You helping me a lot ...thank you so much for these detailed videos 😊🙏

@sqlbelle 2 года назад

Thank you, I am glad to hear Anagha!

@uttamburnwal4662 2 года назад

Thank you so much for this amazing explaination, you are the best.

@sqlbelle 2 года назад

Thank you Uttam! Glad you found the video helpful!

@kloidulent 3 года назад

Another excellent video. Thanks 😊

@sqlbelle 3 года назад

Thank you kloidulent!

@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 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!

@nehabhatia9520 Год назад

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?

@vdn5716 3 года назад

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 3 года назад

Thank you VDN! Appreciate your comments and support .. thank you 🙂

@shalinigarg859 2 года назад

Thank you so much for this informative video. It's really helpful. 👍

@sqlbelle 2 года назад

Thank you Shalini. Glad to hear you found the video helpful!

@rupasingla9494 2 года назад

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 2 года назад

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 :)

@jaitiwari241 3 года назад

Nice explanation.. Love from india

@sqlbelle 3 года назад

Thank you Jai! :)

@maheshbarma 3 года назад

It is vary useful one , Thanks a lot!

@sqlbelle 3 года назад

Happy you found it useful, Mahesh! Thank you for sharing!

@AJaditya123 3 года назад

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 3 года назад

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

@bernardarhin2628 10 месяцев назад

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.

@georginafung7119 2 года назад

ありがとうございます！

@sqlbelle 2 года назад

Thank you very much Georgina!

@fuscone 2 года назад

crazy and amazing that this is free

@sqlbelle 2 года назад

Thank you :)

@sharanchuraky6356 2 года назад

It was very useful …..thanks

@sqlbelle 2 года назад

Thank you Sharan!

@jimmyf.x.9526 2 года назад

You are amazing!

@sqlbelle 2 года назад

Thank you Jimmy!

@lillresonates7081 2 года назад

Madam I'm daily learning my self with your class.. Thanks you..

@sqlbelle 2 года назад

Thank you Venugopola, glad to hear :)

@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 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.

@jayasreecarey7843 3 года назад

thank you !

@sqlbelle 3 года назад

Thank you for your support Jayasree, and your kind comments!

@butchdavis2062 2 года назад

Thanks!

@sqlbelle 2 года назад

Thank you so much, Butch!

@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

@theswarajratan3714 3 года назад

Awesome..

@sqlbelle 3 года назад

Thank you ankur!

@tarun007 2 года назад

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 2 года назад

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!

@rymensymen1994 3 года назад

Very useful :)

@sqlbelle 3 года назад

Thank you Simon🙂

@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.

@Universe-xg7ou 3 года назад

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 3 года назад

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 3 года назад

@@sqlbelle Thank you so much!!

@sqlbelle 3 года назад

These are great points. I'll make sure to try and address this clearly in the next table calc videos - thank you for this!

@travellerclick2558 Год назад

that's nice video bella

@sqlbelle Год назад

Thank you :)

@travellerclick2558 Год назад

@@sqlbelle bella i have sent u mail also

@chandrakumarreddyvennapusa7806 3 года назад

Wonderfull but I request you to do more videos on LOD's IN details with real life scenarios :)

@sqlbelle 3 года назад

Thanks Chandra! There will be additional videos on LODs

@chandrakumarreddyvennapusa7806 3 года назад

Subscribed and Liked waiting for more vidoes :)Mam

@sqlbelle 3 года назад

Thank you so much chandra! Another one coming up in a few hours :) Appreciate your note!

@roopali3369 2 года назад

can you please a do small session on marks , tooltips in tableau how to use and whats the use of them exactly

@sqlbelle 2 года назад

Great suggestion, thank you. There may be pieces in here that can help as well : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iSsQVSXfFck.html

@sienna_personal Год назад

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 Год назад

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 Год назад

@@sqlbelle I see! Thank you so much for the quick reply!

@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.

@hamidyazdi399 Месяц назад

Great video! Is there a more advance Table Calc video that you've done?

@hamidyazdi399 Месяц назад

I'm looking for how to Edit the table calculations manually

@JP-kh6sv 3 года назад

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 3 года назад

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 3 года назад

@@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 3 года назад

@@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!

@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 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 2 года назад

@@sqlbelle thank you so much!! I appreciate your efforts and they are all helpful! Looking forward to your next videos!

@Asuresh392 3 года назад

did you uploaded advanced table calculation?. I couldn't find . Please provide link. Thanks for your video its really useful.

@sqlbelle 3 года назад

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!

@sabyasachiadhikary7138 4 месяца назад

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.

@pradeepp9126 3 года назад

Intro BGM brought me back good old memories... from the show "HOW IT'S MADE" National geography science channel.

@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 3 года назад

Super cool! I will have to re-listen the background music again :) Thank you Pradeep!

@havefundrawing 3 года назад

Do you have the advanced table calc already up? Or is it still in the works?

@sqlbelle 3 года назад

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 :)

@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 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.

@anasnaser7042 2 года назад

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 2 года назад

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 ..

@lillresonates7081 2 года назад

Madam i have stucked with.. I want to show previous year 2 nd quater june sales only.. How can i get that

@sqlbelle 2 года назад

Please have a look at this, this may help? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N-L26NUXhP0.html

@karlyvanvieux4386 3 года назад

Do you have another channel for Sql? I do not see any sql videos and I am very interested in improving my skills.

@sqlbelle 3 года назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4k5ODpvDZrY.html

@orxancamalov6716 2 года назад

You are just magnificent

@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 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 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.

@youavang1973 3 года назад

Great explanation, but the music is rather loud and distracting.

@sqlbelle 3 года назад

Thank you Youa! I've noted the music and will fix in future videos. Thank you for letting me know!

@rubengeertvandenberg3336 Год назад

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 Год назад

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 Год назад

@@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!