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.
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
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.
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.
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
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!
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.
@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 !
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.
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.
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.
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.
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!
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....
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. 🙂
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?
@@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
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
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
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!!!! 😅
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 ....
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!
Good Morning Trainer, I am unable to download the spreadsheet from the website as you mentioned in the 1:40 time. can you share the spreadsheet which makes help for the practice.
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.
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.
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
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?
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
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.
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
Great video and very helpful! I am struggling to calculate the DOW four-week average. So comparing a Tuesday to the average of the previous 4 Tuesdays. Is there an easy way calculate this?
Hi Russ - there are a few ways we can do this. What kind of chart do you have? One strategy I can think of is using the LOOKUP function (something with an offset of -7 on a daily chart/worksheet) and that can help get 4w average.
I have download the chinook database but which tables have you joined to build the dashboard please? The Sale Amount field is not present in the database. Would you be able to share the link to the dataset used in the tutorial please?
I have a dataset that sales of June and July. I want to compare period A (from 10/06 to 24/06) with period B (from 1/7 to 14/07). Can you help me to create calculate?. Thank you so much
Hello Ty! Would this period change? If so, what would be the conditions? If the dates are fixed, you can do a couple calculations like this: //Calculated Field 1: Previous Period SUM (If Date >= '2021-06-10' AND Date < '2021-06-25' THEN YourMeasure END) //Calculated Field 2: Current Period SUM (If Date >= '2021-07-01' AND Date < '2021-07-14' THEN YourMeasure END) If it's a typical month over month calculation, you can consider table calculations: th-cam.com/video/3_DeQdE25Bc/w-d-xo.html Hope this helps.
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.
Thank you so much for your feedback Trey, very much appreciated!
@@sqlbelle Could not agree more - this is by far the best Tableau calculation video.
The most comprehensive Tableau Calculated Field Intro ever! Thank you Donabel!
Thank you Narciso! I am glad you found the video useful! 😀
This lady is fire on Tableau.
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
Thank you Ben, I very much appreciate your comment.
Relieved of 3 years of frustration. Very comprehensive yet crisp video. Highly recommended for strong foundation. 👍👍
Thank you for your kind feedback Pramod!
Your tutorials are so much more indepth than paid Tableau courses! tysm!
You are the best teacher i have found on the internet, thank you for your efforts.
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.
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.
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.
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.
Thank you Rohit!
this is the best channel to learn Tableau from a fresher's perspective. easy to understand. Thank you @sqlbelle for sharing tableau tutorial :)
I really like the way you explained the difference between row level and aggregate level calculation. It was really very useful.
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
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!
There are not so many good teachers out there. Thanks for all you do in your Videos.
Thank you for your kind note, Oludipe!
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.
Thanks for putting this on TH-cam. More power to you.
Hello sqlbelle! I wish you have a nice day
I thank god that i came across your videos. You are a great teacher.
Thank you Ridhi!
I have been using tableau for a couple of years, but I have learned alot of new stuff, thank you 👍🏼
Glad to hear, thank you Mr Stark!
Your videos are TO THE POINT and very very helpful. Thank you belle!
This was the best part. Loved the explanation. "Aggregate Example #4 - Profit Ratio and the importance of order of operations"
Thank you Mohit! 🙂🙏
From where did you get the data sources?
@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 !
Thank you so much for your comment, GonzaloFuste ! Hope you found them helpful 🙂
I am your new fan.................excellent course material
Thank you Sabin!
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.
So glad to hear, thank you so much for sharing Stephen! :)
Excellent , Your video is the best of all that i watched on youtube on this topic
Thanks.
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 :)
Thank you Sarah for your very nice comment and wishes. Thank you :) :) :)
Calculations in Tableau have always been a bit of a mystery to me. Thank you for demystifying this important topic!
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.
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.
Hi, could you please share the data source which is used in video.
I'm going to watch all your videos right away
Thank you Damon!
Wow! I feel so motivated after watching your tutorials. Thank you
This is the best content among videos I have been gone through. Thank you so much! Keep up your good work, please.
Thank you for your kind comment, Carol! Appreciate it!
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.
You are absolutely the best ! Huge respect 👏👏
Thank you Shefali!
the most calculation explain ever, thanks belle
Thank you Vuong!
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!
Thank you Happy Cat :)
I can say one word...
SIMPLY SUPER..
Well explained, you are a natural at this, just saved me some time trying to translate some formulas from Salesforce to Tableau
I'm about to start a new job related to analytics and this explains a lot, Thank you!!
That's great to hear. Thank you for sharing Bill!
I became big fan of u. what an explanation its really peaks
Thank you Shaik! Happy to hear you are finding the videos helpful!
superlative explanation. Thanks for sharing your knowledge..
Extremely good, you have a new fan.
Thank you, I am glad you found it helpful. 😀
very detailed and hats off to the explaination
U deserve more views and subscribers. Great work keep uploading videos on business scenarios please
Thank you for your kind note, Shyam! Appreciate it :)
Excellent tutorial!…🙏🙏🙏
You are amazing! Greetings from Brazil!
Thank you Ramon! Hope you found it helpful!
Very clear explanation..and easy to follow....thank you
Thank you Thennarasu
Practical advice. Well worth a subscribe!
Thank you so much Sonder!
Thank you so much for the great insights Donabel.
Thank you Sandeep!
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....
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. 🙂
@@sqlbelle Thank you. I am waiting for your next video...
Love this video! clean and easy to follow!
Hi Yolinda,
Thank you so much for your note! I am happy you found the video useful and easy to follow!
Much appreciated,
Donabel
I love you from India. Thank you
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?
Thank you for your videos those are very helpful for learners
Thank you Ramana
Thanks a lot for all your informative videos
Thank you Ahmed, hope you found them helpful!
very helpful, Donabel!
Thank you Kristian!
You are a great instructor!
Thank you Linda. I appreciate your comment very much 🙂 I hope you found the video useful :)
@@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
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
Brand new subscriber; you are amazing!
Would love to see a tutorial like this on power bi and tableau prep! Excellent explanation
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!
@@sqlbelle I am also looking forward to the on eon tableau prep please. Excellent videos
You are doing such a great Job 🙌
Thank you Data Fancy :)
Really awesome video.
Cool! Smart. Easy to follow!
Thank you, so happy to hear you found the video easy to follow :)
very informative ......keep it up mam
Thank you Nitesh!
Great video! Keep them coming!
Thank you daniel!
You have saved me a lot of times
Thank you Visy
This is very Awesome,very nice explanation of each and every calculations.Thankyou so much :)
Thank you Diksha! :)
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
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!!!!
😅
Very nice! Thank you very much!
Thank you Mark!
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 ....
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!
wow, you explained it so well. Thank you
Thank you Chithi! I hope you found it useful 🙂
Good Morning Trainer,
I am unable to download the spreadsheet from the website as you mentioned in the 1:40 time. can you share the spreadsheet which makes help for the practice.
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.
Thank you Likhith. The data set is discussed towards the beginning: th-cam.com/video/QimVQl5AoYM/w-d-xo.html
Thank u so much❤️ ur vidoes are really good please keep them coming
Thank you for your feedback Peter! Much appreciated!
This is amazing.... Kindly provide the dataset for the Demo.
thank you so much for your videos, easy to understand and follow, really appreciate :)
Thank you so much for sharing your feedback, Tingting! Glad you found the video helpful!
@@sqlbelle Are you considering to make a complete tableau series tutorial, and level from beginner to advanced level? thank you !
Thanks Tingting - yes I am hoping to do so :)
thank you. very very helpful
Thank you Michael, glad to hear you found the video helpful!
Very helpful thank you !
learned a lot, thank you!
Thank you Lauren!
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.
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
Informative and Useful. Thanks for sharing. Can you please post a video on security.
This is very useful. Thank you!
Thank you Michelle! Glad you found the video helpful!
Hello! I don't really know how to upload the chinook data to my tableau
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?
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
Excellent
Thank you Ramy!
Thank You Very much for this video
You are most welcome AMOL!
Really helpful!
@Sqlbee. Can u please post video on how to write calculations in power bi vs tableau
Thanks Sanagari, great suggestion
Thanks for bring such a amazing lesson.
Is it possible to get the Powerpoint if it's okay?
Thanks again !!!
Thank you for your comment Alice! Hope you found the video helpful 😀
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.
Your starter workbook does not have all the example sheets you cover here. How can I get the rest of them?
its mentioned as part 1, are there any sequel parts of this videos?? if yes please share the link....
Thanks Harish, the full calculations playlist is here: th-cam.com/video/QimVQl5AoYM/w-d-xo.html
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
hi donabelle, do we need to get chinook databse first in sql then excel. as i didnt get any excel file in github
Great video and very helpful! I am struggling to calculate the DOW four-week average. So comparing a Tuesday to the average of the previous 4 Tuesdays. Is there an easy way calculate this?
Hi Russ - there are a few ways we can do this. What kind of chart do you have? One strategy I can think of is using the LOOKUP function (something with an offset of -7 on a daily chart/worksheet) and that can help get 4w average.
nice vid .
can you provide the dataset. I was unable to find it the way it is in your video.
Can u upload the sqlbelle - Tableau Calculations for Beginners - Starter 2 in Public
and pls add the link.
I have download the chinook database but which tables have you joined to build the dashboard please? The Sale Amount field is not present in the database. Would you be able to share the link to the dataset used in the tutorial please?
Thanks Jagjit. I will put together the resources and will provide them in the description.
@@sqlbelle awesome. Thank you.
I have a dataset that sales of June and July. I want to compare period A (from 10/06 to 24/06) with period B (from 1/7 to 14/07). Can you help me to create calculate?. Thank you so much
Hello Ty! Would this period change? If so, what would be the conditions?
If the dates are fixed, you can do a couple calculations like this:
//Calculated Field 1: Previous Period
SUM (If Date >= '2021-06-10' AND Date < '2021-06-25' THEN YourMeasure END)
//Calculated Field 2: Current Period
SUM (If Date >= '2021-07-01' AND Date < '2021-07-14' THEN YourMeasure END)
If it's a typical month over month calculation, you can consider table calculations:
th-cam.com/video/3_DeQdE25Bc/w-d-xo.html
Hope this helps.
From where I can download this dataset. Pls, provide a link.
Hello Sourabh - this video uses the Superstore data set: th-cam.com/video/3_DeQdE25Bc/w-d-xo.html