The IF, THEN, ELSE, ELSEIF, IFNULL, IIF, AND & OR functions in Tableau
Вставка
- Опубліковано 22 лип 2024
- Mock data : shorturl.at/VUgzJ
Logical functions allow you to check whether certain conditions have been met than carry out specific calculations as a result. the form the most fundamental basis for basic calculations in Tableau and in this video I cover 8 of the most used logical functions in one video.
0:00 Intro
0:23 Setting up
1:23 How to use the IF, ELSE, THEN statements
6:47 ELSEIF statement
11:40 OR statement
16:39 AND Logical statement
20:57 IFNULL Statement
23:32 IIF Statement
26:16 Outro -
#tableau #salesforce #analytics Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
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!
This is the best Tableau training I have found! My own professor doesn't explain it this simply and straightforward
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.
Great Work Tim. Really liked it!
Thank you so much, Tim, for the simplification and understanding you bring to your tableau tutorials.
Glad you like them!
@@TableauTim Hero
Thank you! This was great! Had to subscribe. Keep the videos coming!!!
Tks for uploading your video, which is useful and helpful for my job career
Nice 1440p and 4K quality video. many thanks
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.
This video just saved my life, Mucho grazia amico
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.
Good work, keep it going.. Tim
Thank you so much for this! Your videos are awesome!
Pleasure
fantastic we are expecting lenghty vieos :) thanks lot :)
I really liked it! The content and the way you explain. Thanks for doing this! :-)
Beautiful explanation 🙂
Glad you liked it
solid and simple explanationsl
👌👌👌👌👌👌👌👌,grt keep going on, pls take use cases also
excellent video
Do you provide online lessons for specific areas or 1 on 1?
Nice one 😄
Superb !!
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
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
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 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 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
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.
iif stands for "if and only if" 🦋
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.
Thanks!
No problem! and thank you for your generosity!
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
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.
Ver Well done!! IIF called as Immediate IF
Not sure everyone on Twitter agrees twitter.com/tableautim/status/1359585430610599941?s=21 aha
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
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