The best Tableau content I have ever come across on TH-cam. You explained the formulas and the logics behind them in a manner anyone can understand. Thank you!
Great content bro. Very well explained. But as you said it would make more sense to do all the work in a data prep tool. i would do this in SQL before transferring my data over.
Sure that's quite a big ask so I've setup a roadmap system where you can maybe add some suggestions on topics you'd like to see. If you can post them there thats much easier for everyone to track. shrtm.nu/XC6B
Thank you very much. I have one question which is. I want to use "If" function in Tableau but I want to choose part of the discription( not the whole) to set a new category. Appreciate your help.
Content Quality is mind-blowing and the way you explain the details are amazing!! Thanks a lot for the content. Do you have any structured courses online?
I have a LinkedIn learning course. If you follow my profile there’s a link to access it free for 24hours but beyond that not yet. All my time and effort goes into the 490 plus videos on the channel. That’s more than any course anywhere so I’d recommend you check out my playlists as those are structure like courses. I also have a tableau crash course on TH-cam that’s 4 hours long just browse my channel page playlist and videos.
Hello Tableau Tim, your content has been very useful and I was wondering of you can help me fix a calculation error? The error says expected then to match case at character 14. Thank you for being so helpful CALCULATION SUM([weight]) * (CASE [NumeratorFlag] WHEN [NumeratorFlag])’1’ THEN ‘1’ ELSE ‘0’ END
Hi Tim! Thanks so much for your videos! I have a question regarding nulls: When I'm using the NULL statement on the Superstore dataset, it returns text saying "Null" instead of actually removing the values. Would you happen to know why? I appreciate your help!
Hi @Tableau Tim I'm currently in a data analytics course at my university and I'm having trouble with creating a calculated field that uses a logical statement to change the Borough field from numbers to the name of the Borough. In short how do you create a logical formula to translate from one data type to another I.E (if number = X then name should change to Y) Please advise if you can, would be greatly appreciated.
It’s really hard to use these comments for this. Could you create a suggestion here if you’d like a little more support? Add screenshots and we can maybe figure out a video that will help everyone. tableautim.canny.io/suggestions
Yes you could do this just by writing an if statement that groups the data. If age is greater than 0 and less then or equal to 5 then age 0-5 else-if age is greater than 5 but less than equal to 10 then age 6-10 etc etc. The other way is to turn ages into whole numbers and create groupings using group function or lastly use the bin function.
@@TableauTim thanks for the quick response I will give another try, by the way am new to Tableau thanks to your videos now I can create great dashboards. I hope in the near future you will make a video about this case.
for example If [DATA] > 10, then "Max" else [DATA] end. I tried this, but shows error, can you please suggest..(I want data which is greater than 10 to print as Max, if not to show those values less than 10.
youre mixing data types. text and numbers cant come from the same calculation. Make your values into text by doing this. if [DATA] > 10, then "Max" else STR([DATA]) end the STR function makes a value into text. But bear in mind you then cant aggregate these.
You need to check your calculation. Your missng and end clause somewhere or you have one too many IFs... common error on Google as well with lots of tips. www.google.com/search?q=Expected+%27End%27+to+match+%27IF%27+at+character+0+tableau&oq=Expected+%27End%27+to+match+%27IF%27+at+character+0+tableau&aqs=chrome..69i57j0i22i30j0i390l2.3029j0j7&sourceid=chrome&ie=UTF-8
![[TH]FFWS SEA 2024 Fall - Knockout Stage Day 5](http://i.ytimg.com/vi/N2tl9xkQyyU/mqdefault.jpg)
This is the best Tableau training I have found! My own professor doesn't explain it this simply and straightforward
The best Tableau content I have ever come across on TH-cam. You explained the formulas and the logics behind them in a manner anyone can understand. Thank you!
I can't stop watching your tableau videos. Thanks a lot keep up with the good work.
Thank you so much, Tim, for the simplification and understanding you bring to your tableau tutorials.
Glad you like them!
@@TableauTim Hero
Awesome job! You really clear the air with all these tips. Thanks a lot and greeting from Brazil.
Wonderful content! Very clear explanation! Keep up the good work mate.
Tks for uploading your video, which is useful and helpful for my job career
Great Work Tim. Really liked it!
This video just saved my life, Mucho grazia amico
Nice 1440p and 4K quality video. many thanks
Thank you! This was great! Had to subscribe. Keep the videos coming!!!
Thank you so much for this! Your videos are awesome!
Pleasure
Great content bro. Very well explained. But as you said it would make more sense to do all the work in a data prep tool. i would do this in SQL before transferring my data over.
I really liked it! The content and the way you explain. Thanks for doing this! :-)
solid and simple explanationsl
As usual best video Tim...Please make some videos on server side also ..very less content on server admin part , it will ne helpful to us..Thanks
Sure that's quite a big ask so I've setup a roadmap system where you can maybe add some suggestions on topics you'd like to see. If you can post them there thats much easier for everyone to track. shrtm.nu/XC6B
@@TableauTim thanks
Beautiful explanation 🙂
Glad you liked it
Thank you very much. I have one question which is. I want to use "If" function in Tableau but I want to choose part of the discription( not the whole) to set a new category. Appreciate your help.
Nice one 😄
Content Quality is mind-blowing and the way you explain the details are amazing!! Thanks a lot for the content. Do you have any structured courses online?
I have a LinkedIn learning course. If you follow my profile there’s a link to access it free for 24hours but beyond that not yet. All my time and effort goes into the 490 plus videos on the channel. That’s more than any course anywhere so I’d recommend you check out my playlists as those are structure like courses. I also have a tableau crash course on TH-cam that’s 4 hours long just browse my channel page playlist and videos.
excellent video
Thankyou.
You're welcome
iif stands for "if and only if" 🦋
Good work, keep it going.. Tim
Hey Tim, would you mind checking the link for mock data, i am not able to access it seems to be deleted. Thanks Tim !
Fixed shorturl.at/VUgzJ
Thanks!
No problem! and thank you for your generosity!
fantastic we are expecting lenghty vieos :) thanks lot :)
Superb !!
👌👌👌👌👌👌👌👌,grt keep going on, pls take use cases also
Hi Tim, Do you have a video for date function calculations in your playlist? Thank You
Not yet I skipped that one but it’s still on the to do list
Ver Well done!! IIF called as Immediate IF
Not sure everyone on Twitter agrees twitter.com/tableautim/status/1359585430610599941?s=21 aha
Do you provide online lessons for specific areas or 1 on 1?
Hello Tableau Tim, your content has been very useful and I was wondering of you can help me fix a calculation error?
The error says expected then to match case at character 14. Thank you for being so helpful
CALCULATION
SUM([weight]) * (CASE [NumeratorFlag]
WHEN [NumeratorFlag])’1’
THEN ‘1’
ELSE ‘0’
END
Hi Tim! Thanks so much for your videos! I have a question regarding nulls: When I'm using the NULL statement on the Superstore dataset, it returns text saying "Null" instead of actually removing the values. Would you happen to know why? I appreciate your help!
I figured it out - it's because I put the calculation as discreet and not continuous in the text table!
Hi @Tableau Tim I'm currently in a data analytics course at my university and I'm having trouble with creating a calculated field that uses a logical statement to change the Borough field from numbers to the name of the Borough. In short how do you create a logical formula to translate from one data type to another I.E (if number = X then name should change to Y) Please advise if you can, would be greatly appreciated.
It’s really hard to use these comments for this. Could you create a suggestion here if you’d like a little more support? Add screenshots and we can maybe figure out a video that will help everyone. tableautim.canny.io/suggestions
Hi @TableauTim is it possible to display the age range in tableau, let's say Iike display only data for ages between 24-30 using the IF Statement?
Yes you could do this just by writing an if statement that groups the data. If age is greater than 0 and less then or equal to 5 then age 0-5 else-if age is greater than 5 but less than equal to 10 then age 6-10 etc etc.
The other way is to turn ages into whole numbers and create groupings using group function or lastly use the bin function.
@@TableauTim thanks for the quick response I will give another try, by the way am new to Tableau thanks to your videos now I can create great dashboards. I hope in the near future you will make a video about this case.
for example If [DATA] > 10, then "Max" else [DATA] end. I tried this, but shows error, can you please suggest..(I want data which is greater than 10 to print as Max, if not to show those values less than 10.
youre mixing data types. text and numbers cant come from the same calculation. Make your values into text by doing this.
if [DATA] > 10, then "Max" else STR([DATA]) end
the STR function makes a value into text. But bear in mind you then cant aggregate these.
I am getting error:-
Expected 'End' to match 'IF' at character 0
What will be the solution to make it correct?
You need to check your calculation. Your missng and end clause somewhere or you have one too many IFs... common error on Google as well with lots of tips. www.google.com/search?q=Expected+%27End%27+to+match+%27IF%27+at+character+0+tableau&oq=Expected+%27End%27+to+match+%27IF%27+at+character+0+tableau&aqs=chrome..69i57j0i22i30j0i390l2.3029j0j7&sourceid=chrome&ie=UTF-8
hello, how to do to get the best workers in performance, I hope your help
sorry could you explain your idea in more detail here shrtm.nu/XC6B thanks.
Do you provide private lessons or mentoring?
The Videos on this channel is enough Mentoring if you ask me
Sexy Music at the Back ! Vibing really good XD