How to use Exclude Level of Detail LOD Calculations in Tableau Desktop ---- [Simple Visual Method]
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- To get your FREE Tableau Beginner Training course, check out my website at:
jellyman-educa...
-----------------------------------------------
SUBSCRIBE for new videos Tuesday-Thursday. Click the notification bell so you don't miss a single episode.
GOT A QUESTION/PROBLEM? Why not request a video using the Comments section below. I'll make a custom video just for you.
----------------
VIDEO DESCRIPTION:
Level of Detail calculations also known as LOD's can be very confusing even for seasoned Tableau users. A majority of the time the confusion begins because we are calculating at a different level to the visualization that is in front of us. Hence, it requires some imagination to do it sometimes.
In this video I'll show you how I build LOD's in steps so you don't confused and you can see where the calculation is applying itself. We'll also go through what Level of Detail means and why the lowest level of detail for aggregates is crucial in understanding LOD's
----------------
TRAINING COURSES:
Udemy - Complete Tableau Training Course
-Over 184k students and over 13k reviews!
-200 Lectures and 22 hours of Tableau Content
www.udemy.com/...
SkillShare Tableau Training
www.skillshare...
------------------------------------------------------------------
TH-cam PLAYLISTS:
Tableau for Beginners - A Quick Start TH-cam Course
• Tableau for Beginners ...
Tableau Desktop Accelerator TH-cam Course - A Beginners Guide for New Users
• Tableau Desktop Accele...
Tableau Online/Server Short Course - Site Creation, User Management and Licensing
• Tableau Online/Server ...
Tableau Online/Server - Complete Playlist
• Tableau Online/Server ...
Tableau Desktop - Complete Playlist
• Tableau Desktop - Comp...
Tableau Prep - Complete Playlist
• Tableau Prep - Complet...
------------------------------------------------------------------------------
RECORDING EQUIPMENT (Amazon Affiliate Program) -
VIDEO DESCRIBING EACH ( • My Recording Equipment... )
Headset: Sennheiser GSP 350 - Dolby 7.1 Surround, Noise Canceling, headset volume control
amzn.to/32N8vpz
Keyboard 1: Logitech Illuminated K830 Wireless Keyboard with Touchpad
amzn.to/2IIcHzn
Keyboard 2: Logitech MX Wireless Illuminated Keyboard
amzn.to/36BAIk4
Mouse: Logitech MX Master 2S
amzn.to/32KMaso (My current model)
amzn.to/2IF5C2G (Latest Model MX Master 3)
Laptop Stand: Adjustable/Tilting Laptop Stand Aluminum
amzn.to/2Uuj7F7
Monitor: BenQ 1080P 24-Inch Monitor
amzn.to/2Usen2T
Webcam: Logitech C920 HD Webcam 1080P
amzn.to/3kz7Ca3
LED Studio Lights: x2 Neewar 660 LED Video Lights with Barn Doors, Stand, Bag and Dimmer
amzn.to/3f3tuJr
Camera Tripod: Manfrotto Advanced Tripod 3-Way Head with Quick Release
amzn.to/3pvmg5V
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.4 (2/4)](http://i.ytimg.com/vi/MN-p1DHjPtI/mqdefault.jpg)
Once again you are the man!
Thank you for this informative video, learned a lot!
Thanks man, you made me understand in 4 minutes something that took my teacher 2 hours of class. I'm really grateful.
Glad I could help! Also, I have an Expert course on my website that does 15 in-depth examples of LODS!
jellyman-education.thinkific.com/courses/tableau-desktop-expert
Very clear with nice examples of the benefit this can bring. thanks!
Hi Brian, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
jellyman-education.thinkific.com/courses/getting-started-with-tableau
Just found you and love your explanations. Quick question. This also would've worked with a fixed on category, correct? Why/when would you choose exclude over fixed? I work with Tableau regularly but excited to take your classes as I understand the way you explain it!
Awww thanks. Yes that's correct. Depending on your skill with Tableau you can use any of the three depending on the situation.
Personally, I always go for Fixed as a default just from a long term maintenance point of view. However, if I need more efficiency and cleanliness, I'll go exclude/include if I have too many fields to deal with.
One more comment. I signed up for a bunch of your Udemy courses and I highly recommend them to everyone, I come across.
Keep up the good work, Jay!
Awesome, thank you so much! I really appreciate the support! I'll keep the content coming for you. By the way, a secret between you and me I have 47 videos lined up for you and all my other students ;-)
@@jellymaneducation6168 One day I will visit Australia, rent a Toyota Supra and drive up and down the coast. This will all be possible from my Tableau Developer Salary, that I will have, thanks to you.
Hey Mickey! Any particular reason a Supra? Yes come to Australia! Its the best. Where are you from?
@@jellymaneducation6168 I live in the U.S, Dallas Texas area.
I specifically stated "Supra" because ,if i remember correctly, a Supra was on your computer desktop background.
If that is correct then I was trying to make my comment more personable for you. To be be honest with you, I would tour Australia in a Toyota LandCruiser. I won't worry as much getting stuck as I tour the beaches and desert.
Oh cool. I always wanted to go Texas cause im a massive smoked bbq fan! I want to meet Aaron Franklin! Oh right the Supra. I drive one myself actually. Incredible car and so much fun! I actually work Toyota lols. Yes the Landcruiser is amazing! A lot of my colleagues have them
Thanks for this excellent explanation of EXCLUDE LOD.
I would like you to cover why FIXED LOD shows up with a SUM aggregation whereas INCLUDE and EXCLUDE LODs show up with ATTR around the field. It would be great if you could cover this in one of your videos.
Hi Deepak, I'm not going to lie. I'm not the expert when it comes to the ATTR() functionality. Reason being it's never gotten in the way of my work. However, if you want to know the exact behind the scenes details, here is a great article on it. kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function
By the way, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
jellyman-education.thinkific.com/courses/getting-started-with-tableau
Hello Jay, hope you do a video on the Fixed LOD.
In the meantime, can you show how to take a total of all Orders from the Consumer Segment then divide it by the Total of Segments, comprised of Consumer, Corporate and Home-Office?
Will do! I've got a few more LODs coming including FIXED! Also for the example you requested, basically, using LOD to compare two calculations which are filtered differently. Correct?
@@jellymaneducation6168 No worries. I figured it out. Thank you for your reply.
Hello! Im from Mexico and apreciatte your videos!! Question how can I split up a measure in individual objects for calculations: Example: Measure : Global/Local Want to split: Global and another dimension local
could you do the same thing with { FIXED [Category] : SUM( [Sales] ) }
is that equivalent result to using EXCLUDE in this case ?
edit: ok, I just tested it and it appears to give the same result -- I just don't see the use of EXCLUDE
Hello
May I ask a question? Is there any difference that compare to your last video if use "Fixed"?
Hello @Jellyman Education , thanks so much for the video!! One question could we combine Fixed and IF formula? What I want to do is upload some numbers at arrival date to my datasource (these numbers donot exist in the data source so I want to add them manually), we have different values depending on the year and arrival month...so I would like to build a formula such as:...If [Year]= 2020 and Month( [Arrival month])= 1 then 22000.....as I have millons of lines in the data source, I was wondering if I can combine in with fixed formula...just to add these numbers at year and arrival month level and later on, get a subtotal for quarters....is that possible?
thanks for your help and if you have a video on this would be great! thanks in advance
Samira
Hey Samira, no worries. Happy to take a look. Could yoy again send me an email with some examples of what you want. Maybe an excel file showing what the final result looks like would be great
@@jellymaneducation6168 Done! thanks so much for your help!
Hello, Jed. Great, simple explanation. I'm a Udemy student. Quick technical question. Which software you used to record the screen and the webcam with those cool transitions? - Hector
Hey Hector i use Screencast-o-matic. $15 per year from memory and very easy to use!
@@jellymaneducation6168 Wow teacher, that was fast. Inspired by you I'm been thinking on starting a Spanish Language Tableau Tutorial Channel. I'm a beginner but I can certainly explain basic concepts. Thanks Jed. You are a great teacher.
I see a big gap of Tableau videos in Spanish. What do you think?
That would be fantastic! I have an iranian friend who ive been encouraging to teach tableau in persian! You should definitely go for it!
@@jellymaneducation6168 That's encouraging. Honestly I think that while I learn I teach is the winning formula. You are a great role mole. I have day job, wife and kids and it is kind of difficult, hence I've been searching for a software similar to the one you shared to make this super simple. I don't want to lose time editing. I want to do it in one shot per video and then upload. We'll see.