The best Tableau content I have ever come across on UA-cam. You explained the formulas and the logics behind them in a manner anyone can understand. Thank you!
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 UA-cam that’s 4 hours long just browse my channel page playlist and videos.
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.
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!
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.
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.
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
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.
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
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
This is the best Tableau training I have found! My own professor doesn't explain it this simply and straightforward
Thank you so much, Tim, for the simplification and understanding you bring to your tableau tutorials.
Glad you like them!
@@TableauTim Hero
The best Tableau content I have ever come across on UA-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.
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.
This video just saved my life, Mucho grazia amico
Thank you! This was great! Had to subscribe. Keep the videos coming!!!
Great Work Tim. Really liked it!
Tks for uploading your video, which is useful and helpful for my job career
Thanks!
No problem! and thank you for your generosity!
Nice 1440p and 4K quality video. many thanks
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 UA-cam that’s 4 hours long just browse my channel page playlist and videos.
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
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
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
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.
Thank you so much for this! Your videos are awesome!
Pleasure
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!
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.
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.
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
Beautiful explanation 🙂
Glad you liked it
I really liked it! The content and the way you explain. Thanks for doing this! :-)
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.
solid and simple explanationsl
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.
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
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
👌👌👌👌👌👌👌👌,grt keep going on, pls take use cases also
Good work, keep it going.. Tim
Do you provide online lessons for specific areas or 1 on 1?
Nice one 😄
fantastic we are expecting lenghty vieos :) thanks lot :)
Do you provide private lessons or mentoring?
The Videos on this channel is enough Mentoring if you ask me
excellent video
Superb !!
Ver Well done!! IIF called as Immediate IF
Not sure everyone on Twitter agrees twitter.com/tableautim/status/1359585430610599941?s=21 aha
Thankyou.
You're welcome
iif stands for "if and only if" 🦋
Sexy Music at the Back ! Vibing really good XD