Learn Tableau Basic Calculations (Calculated Fields) in Tableau (with 10+ examples) | Part 1

[@srv14evr]

I've gone through several videos on this topic already. Your video is the absolute best video on this topic! Very well put together....very easy to follow....therefore, easy to learn.

[@sqlbelle]

Thank you so much for your feedback Trey, very much appreciated!

[@cedenfie]

@@sqlbelle Could not agree more - this is by far the best Tableau calculation video.

[@ntorrente]

The most comprehensive Tableau Calculated Field Intro ever! Thank you Donabel!

[@sqlbelle]

Thank you Narciso! I am glad you found the video useful! 😀

[@ben-cb5er]

omg!!! I hope everyone reads this....I've bought many Udemy courses, as well as tableau official course! this video by far is the best and easiest to understand. Thank you for making this video and part 2, part 3 =) tableau goddess!! valuable content thank you again

[@sqlbelle]

Thank you Ben, I very much appreciate your comment.

[@pramodhanmi]

Relieved of 3 years of frustration. Very comprehensive yet crisp video. Highly recommended for strong foundation. 👍👍

[@sqlbelle]

Thank you for your kind feedback Pramod!

[@kennethwakhungu6513]

This lady is fire on Tableau.

[@viviensong3782]

Your tutorials are so much more indepth than paid Tableau courses! tysm!

[@manishagrawal417]

I don´t have words to express how I felt. Let´s just say beyond AMAZING. I never felt bored for a sec or thought when the vid is going to end or how much time is left. You just hooked me in. You were spot on, each second of the video was imp, this was literally 2 hours squeezed into 20 mins without any fatigue and all the details were captured. Just amazing

[@sqlbelle]

Hello Manish, I really appreciate your note and feedback. Thank you for taking the time to share with me - it means a lot. I hope you find other videos in the channel helpful as well. Thank you again!

[@aakashjaiswal2003]

I really like the way you explained the difference between row level and aggregate level calculation. It was really very useful.

[@rohitpawar9198]

The best video ever on tableau calculations. Even the online courses I purchased missed many key points and you covered it all in just 23 min.

[@sqlbelle]

Thank you Rohit!

[@hassanawodi5888]

Read a book and did some Tableau stuff but kept a full understanding of calculations till now and you really nailed it! Your presentations and examples makes it stick.

[@huy6135]

Hello sqlbelle! I wish you have a nice day

[@ridhihingu232]

I thank god that i came across your videos. You are a great teacher.

[@sqlbelle]

Thank you Ridhi!

[@1MinuteWithSharmaji]

You are the best teacher i have found on the internet, thank you for your efforts.

[@oludipe737]

There are not so many good teachers out there. Thanks for all you do in your Videos.

[@sqlbelle]

Thank you for your kind note, Oludipe!

[@MrStark-zy6cd]

I have been using tableau for a couple of years, but I have learned alot of new stuff, thank you 👍🏼

[@sqlbelle]

Glad to hear, thank you Mr Stark!

[@gravenoxnero]

By far, for me, you gave the best explanation for calculations, which helped me understand what Tableau was doing. Thanks, this helped me a lot.

[@gonzalofuste]

@sqlbelle I really like the way you explain tableau very easily; you also have a very nice and clear voice that helps a lot. Thank you very much for these videos !

[@sqlbelle]

Thank you so much for your comment, GonzaloFuste ! Hope you found them helpful 🙂

[@equiwave80]

Hi Donabel, I really liked the final part where you clearly mentioned the difference between the Row-Level and Aggregate calculations Row Level Cal: DIVIDE FIRST, THEN SUM Aggregate Cal: SUM FIRST, THEN DIVIDE Thanks for this excellent refresher. It was very useful for me as I will now be able to better understand how basic calculations work in Tableau.

[@stephenboyd2579]

These videos are so helpful in my Tableau journey! Thank you so much, your teaching and explanations of concepts is very easy to grasp, understand and retain.

[@sqlbelle]

So glad to hear, thank you so much for sharing Stephen! :)

[@sarahjanepena8027]

This channel is a gem for me! It helps me to easily understand Tableau esp. that I'm a beginner. More blessings to you, Ms. Belle :)

[@sqlbelle]

Thank you Sarah for your very nice comment and wishes. Thank you :) :) :)

[@akuasoftlife]

Hi, thanks a lot for your good tutorials, I really enjoyed them. However since you were using a different data source, I thought you would give us the link to download it so we can follow you in the practical work. I am using the Tableau data source, but I am unable to follow some of the examples you demonstrate in calculating the data fields.

[@megaankitshrivastava]

Hey. Your video is amazing. It will great if you make whole series of tableau video from beginning to advance . So that those who want to learn whole tableau can go through. They way of teaching is amazing.

[@jowiekid]

Out of the tableau tutorials I have tried out so far, this is the most helpful one. Progression was well laid out, pacing was just right, extremely useful tips and examples and lastly, it was very easy to follow. Thanks for this content! Subscribed.

[@sqlbelle]

Thank you Jowie for your kind comment, and thank you for sharing your thoughts. I am happy you found this video helpful :) .. Hope you will find the other ones in the channel helpful as well.

[@innovativeiinnovativei]

Hi, could you please share the data source which is used in video.

[@0nicks]

this is the best channel to learn Tableau from a fresher's perspective. easy to understand. Thank you @sqlbelle for sharing tableau tutorial :)

[@krishnay.233]

Thanks for putting this on KZbin. More power to you.

[@mohitroy2053]

This was the best part. Loved the explanation. "Aggregate Example #4 - Profit Ratio and the importance of order of operations"

[@sqlbelle]

Thank you Mohit! 🙂🙏

[@innovativeiinnovativei]

From where did you get the data sources?

[@Yogesh010Mishra]

Your videos are TO THE POINT and very very helpful. Thank you belle!

[@matthewwroblewski8752]

Calculations in Tableau have always been a bit of a mystery to me. Thank you for demystifying this important topic!

[@Carol-cb5yd]

This is the best content among videos I have been gone through. Thank you so much! Keep up your good work, please.

[@sqlbelle]

Thank you for your kind comment, Carol! Appreciate it!

[@shefalichand7177]

You are absolutely the best ! Huge respect 👏👏

[@sqlbelle]

Thank you Shefali!

[@boGodhuan]

This is so amazing! Thank you! Your video is so helpful for newbies like me! You are like a fairy🧚🧚‍♂️, make complicated things so simple and easy to understand!

[@sqlbelle]

Thank you Happy Cat :)

[@sobersabin]

I am your new fan.................excellent course material

[@sqlbelle]

Thank you Sabin!

[@jingpinhuicai]

Wow! I feel so motivated after watching your tutorials. Thank you

[@jannerick2]

Extremely good, you have a new fan.

[@sqlbelle]

Thank you, I am glad you found it helpful. 😀

[@shyamkumar-fh2fh]

U deserve more views and subscribers. Great work keep uploading videos on business scenarios please

[@sqlbelle]

Thank you for your kind note, Shyam! Appreciate it :)

[@damonreyes8719]

I'm going to watch all your videos right away

[@sqlbelle]

Thank you Damon!

[@dipankarbose4070]

Hi, I have seen lots of video in tableau but the information you have share that make you different from other..it is really informative.. Make one video on Data blending ... One suggestion ..whatever video you make on that video you should keep on question and answer session that will help us to understand what type of question will be ask by the interviewer on this topic. It will truly help your follower who are searching for job.. Thank you so much sharing your valuable knowledge with us....

[@sqlbelle]

Thank you for your note Dipankar, and for your suggestions. I will try to put additional content in future videos about what possible questions could be asked about the respective video topics. 🙂

[@dipankarbose4070]

@@sqlbelle Thank you. I am waiting for your next video...

[@StyleViewStudio]

Excellent tutorial!…🙏🙏🙏

[@billgarcia471]

I'm about to start a new job related to analytics and this explains a lot, Thank you!!

[@sqlbelle]

That's great to hear. Thank you for sharing Bill!

[@jishanchowdhury4597]

very detailed and hats off to the explaination

[@PlosoPlus]

Well explained, you are a natural at this, just saved me some time trying to translate some formulas from Salesforce to Tableau

[@MuhammadRizwan-vn6pz]

Excellent , Your video is the best of all that i watched on youtube on this topic Thanks.

[@torque6389]

Brand new subscriber; you are amazing!

[@russelllavery2281]

superlative explanation. Thanks for sharing your knowledge..

[@Ramon.83]

You are amazing! Greetings from Brazil!

[@sqlbelle]

Thank you Ramon! Hope you found it helpful!

[@sandeepsandy6190]

Thank you so much for the great insights Donabel.

[@sqlbelle]

Thank you Sandeep!

[@yolindaburns3447]

Love this video! clean and easy to follow!

[@sqlbelle]

Hi Yolinda, Thank you so much for your note! I am happy you found the video useful and easy to follow! Much appreciated, Donabel

[@kristiand3515]

very helpful, Donabel!

[@sqlbelle]

Thank you Kristian!

[@vuonghuynh1601]

the most calculation explain ever, thanks belle

[@sqlbelle]

Thank you Vuong!

[@AnantpadmanabhDivanji]

Would love to see a tutorial like this on power bi and tableau prep! Excellent explanation

[@sqlbelle]

For sure, I will include these in my planned videos.. I have one on Tableau prep coming in the next few weeks :) Thank you Anantpadmanabh!

[@oluremiabayomi5924]

@@sqlbelle I am also looking forward to the on eon tableau prep please. Excellent videos

[@comic2946]

Amazing .this channel is a gem for me! It helps me to easily understand Tableau esp. that I'm a beginner. More blessings to you, Ms. Belle :) Could you please provide the database link so that we can practice

[@6toolbaseball]

Practical advice. Well worth a subscribe!

[@sqlbelle]

Thank you so much Sonder!

[@shaiksaleem437]

I became big fan of u. what an explanation its really peaks

[@sqlbelle]

Thank you Shaik! Happy to hear you are finding the videos helpful!

[@DvACtOid]

Great content, I love the part you mention those small details like modeless and multiple ways of create calculated fields. I have downloaded your twbx but unable to find the composer fields, to keep up with the contains section, maybe you have forget it?

[@thennarasuthen9179]

Very clear explanation..and easy to follow....thank you

[@sqlbelle]

Thank you Thennarasu

[@imranshaikh-gt4tg]

great content ... you have simplified complex calculation topic in 100 times better way ......keep uploading more and also one request if u can provide dataset which u used while making ur videos then we can practice along with you.... keep going...awaiting for more videos ....

[@sqlbelle]

Thank you Imran. I will be posting the sources of the data in the description (majority are from Tableau Public and Kaggle). I hope you found the video useful!

[@sudeepsaxena8023]

Hi Belle, the concepts have been explained in a very simple but detailed way. Your language is clear too which makes it more easy to understand the concepts. I also like the background music. I was wondering if I can get the name of the soundtrack!!!! 😅

[@ramanamurty3366]

Thank you for your videos those are very helpful for learners

[@sqlbelle]

Thank you Ramana

[@ramyamohan4419]

I can say one word... SIMPLY SUPER..

[@adimasnarendraputra4924]

Thank you! Very helpful

[@sqlbelle]

Thank you Adimas!

[@laurenlin7478]

learned a lot, thank you!

[@sqlbelle]

Thank you Lauren!

[@marktan9009]

Very nice! Thank you very much!

[@sqlbelle]

Thank you Mark!

[@ahmedchakroun8980]

Thanks a lot for all your informative videos

[@sqlbelle]

Thank you Ahmed, hope you found them helpful!

[@hamamunashe]

You have saved me a lot of times

[@sqlbelle]

Thank you Visy

[@innovativeiinnovativei]

Thank you for your amazing videos. Very well explained. Could you please share the data sources you have used in the video as it gets easier to follow and learn. Thanks once again.

[@sqlbelle]

Thank you. I've added the starter workbook link in the description as well: public.tableau.com/app/profile/sqlbelle/viz/sqlbelle-TableauCalculationsforBeginners-Starter/Intro

[@lpdowdell]

You are a great instructor!

[@sqlbelle]

Thank you Linda. I appreciate your comment very much 🙂 I hope you found the video useful :)

[@lpdowdell]

@@sqlbelle I wonder if you are planning to create videos about formatting incoming text from fields that contain paragraphs. For example, I would like to indent an entire paragraph with a bullet point

[@sqlbelle]

Hi Linda, I was planning to do one or few videos about creating a resume in Tableau, which may have something similar to what you described. However for these ones, the data set will have blocks of text - basically each paragraph is in its own record. One way you can explore is to bring this in text, but have another column just before that has just a shape (for the bullet). I'll try to incorporate in the next couple videos that I am planning to publish. Thank you for your feedback and suggestion! Much appreciated! Donabel

[@vishalsvits]

I love you from India. Thank you

[@deepakgautam8958]

Really awesome video.

[@ontariobeaver9376]

Cool! Smart. Easy to follow!

[@sqlbelle]

Thank you, so happy to hear you found the video easy to follow :)

[@divyakuppusamy2196]

Informative and Useful. Thanks for sharing. Can you please post a video on security.

[@NiteshSingh-rv2sh]

very informative ......keep it up mam

[@sqlbelle]

Thank you Nitesh!

[@michaelalfred6912]

thank you. very very helpful

[@sqlbelle]

Thank you Michael, glad to hear you found the video helpful!

[@likhithvenkiteela4794]

Explanation is fabulous. I got the basic knowledge about calculations part. But, could you please provide me the path to download the data set that you had used in the video? Thank you and eagerly waiting for your response.

[@sqlbelle]

Thank you Likhith. The data set is discussed towards the beginning: kzbin.info/www/bejne/h5rQh4Siaqaij68

[@ChithiAmmaUSA]

wow, you explained it so well. Thank you

[@sqlbelle]

Thank you Chithi! I hope you found it useful 🙂

[@dikshachourasiya9749]

This is very Awesome,very nice explanation of each and every calculations.Thankyou so much :)

[@sqlbelle]

Thank you Diksha! :)

[@amber-di6il]

Really helpful!

[@tingtingshi9463]

thank you so much for your videos, easy to understand and follow, really appreciate :)

[@sqlbelle]

Thank you so much for sharing your feedback, Tingting! Glad you found the video helpful!

[@tingtingshi9463]

@@sqlbelle Are you considering to make a complete tableau series tutorial, and level from beginner to advanced level? thank you !

[@sqlbelle]

Thanks Tingting - yes I am hoping to do so :)

[@peterparker4358]

Thank u so much❤️ ur vidoes are really good please keep them coming

[@sqlbelle]

Thank you for your feedback Peter! Much appreciated!

[@sreetejaalam4932]

Hello Great content. But a request from my end to not add the background music since its a little distracting. Don't know if its only me or someone else facing this issue. Hope you make a note of this. Thanks.

[@sqlbelle]

Thank you Sreeteja

[@Hooleey]

Great video! Keep them coming!

[@sqlbelle]

Thank you daniel!

[@datafancy1361]

You are doing such a great Job 🙌

[@sqlbelle]

Thank you Data Fancy :)

[@maheshbarma]

thank you Donabel

[@sqlbelle]

Thanks Mahesh!

[@alice-nckucsielee8265]

Thanks for bring such a amazing lesson. Is it possible to get the Powerpoint if it's okay? Thanks again !!!

[@sqlbelle]

Thank you for your comment Alice! Hope you found the video helpful 😀

[@pattybaselines]

Thank you.

[@sqlbelle]

Thank you Patrick!

[@ttak83]

Thanks!

[@sqlbelle]

Thank you Shelley! Much appreciated :) I hope you found the video helpful!

[@lexinliu6660]

so helpful！

[@sqlbelle]

So glad to hear, thank you Lexin.

[@orugaaireen5890]

Hi Ms. Belle, I'm a Fan. I really love how you explain everything. I hope I could get your excel file so I can try it myself all your samples. I am newbie with Tableau. Thank you in advance.

[@sqlbelle]

Thank you Aireen. I am planning to put all the files together to be downloadable. But please feel free to email me or connect with me on LinkedIn if you'd like to have it soon.

[@orugaaireen5890]

@@sqlbelle Hi Ms. Belle. I already sent connection in LinkedIn. Looking forward to connect with you. Godspeed!

[@amolparbat6428]

Thank You Very much for this video

[@sqlbelle]

You are most welcome AMOL!

[@saisakshi5560]

Thank you

[@sqlbelle]

You are welcome Sai. Hope you found it helpful!

[@MIDRISSINTEGRATEDINTLLIMITED]

This is amazing.... Kindly provide the dataset for the Demo.

[@newpaige9435]

this was great!

[@ramyahmed9510]

Excellent

[@sqlbelle]

Thank you Ramy!

[@tzelichonok]

Hello Donabel, Thank you for your lessons. Very informative and very well presented. I have a question on COUNTD calculation with IF condition. It gives me an "cannot mix aggregate and non-aggregate comparisons" error when using Ration calculation in IF statement. How it can be solved?

[@sqlbelle]

Hi Tanya, Thank you for your note! Usually what you can do is embed the IF in the COUNTD, for example, something like this: COUNTD ( IF condition = True THEN yourfieldID END ) / COUNTD(yourfieldID) Hope this helps! Please give it a try, would love to hear how it goes. Donabel

[@michellebannon674]

This is very useful. Thank you!

[@sqlbelle]

Thank you Michelle! Glad you found the video helpful!

[@himanshudeliwal5437]

Hi This is very informative video, and also wanted to know how to extract last name or first name if we have only name and first and last name written together , Thanks

[@AlaeAloa-cn2kz]

JUST THANK YOUU

[@sanagaribabu7956]

@Sqlbee. Can u please post video on how to write calculations in power bi vs tableau

[@sqlbelle]

Thanks Sanagari, great suggestion

[@praveenkumarchidrawar9008]

Thankyou.

[@sanjaypalai6495]

This is vary helpful topic. Thank you for sharing. I have a question am stuck some where. Need your help. How can I create a calculated field of sum of sales for a particular year. Let's say I have sales for 2021 and sales of 2022. How can I create calculated field only for sum of all sales in 2022.

[@ducthanhnguyen8801]

Hello! I don't really know how to upload the chinook data to my tableau