Tableau LOD (Level of Detail) Expressions Explained - FIXED, INCLUDE, EXCLUDE - Complete Tutorial

LET'S CONNECT

#tableau #analytics #lod #calculation
Practice Questions and other digital products

This is a complete and comprehensive tutorial that explains Tableau Level of Detail (LOD) Expressions. We will cover what LODs are, the types of LODs (FIXED, INCLUDE, EXCLUDE), the syntax for LODs, and the significance of Tableau's order of operations.

Sections:
0:00 - Intro
1:24 - What are LODs or Level of Detail Expressions?
4:30 - How level of detail works in Tableau
7:36 - Types of LODs
8:22 - Syntax for LODs
9:21 - Trick to learning LODs
10:33 - Overview of complete demo
11:59 - FIXED LOD
16:41 - Tableau's Order of Operations
19:00 - EXCLUDE LOD
22:27 - INCLUDE LOD
26:56 - Putting it all together: complete demo

We will walk through each type of LOD with examples, and explained step-by-step. Whether you are a beginner looking for basics, or advanced and looking for a refresher, this video will give you a good refresher on LODs.

If you want to understand LODs, and get yourself ready to tackle more complex calculations in Tableau, this video is for you.

Practical LOD Examples - Part 1

Tableau Calculations Series in sqlbelle channel:
Part 1 - Basic and Aggregate Calculations

Part 2 - Level of Detail Expressions - FIXED, INCLUDE, EXCLUDE - Complete Tutorial

Part 3 - Table Calculations

Related Videos:
10 Tableau tricks you should know

[ravivijay]

I have followed multiple masters of tableau but no one is able break down and explain things so easily like you. You are truly amazing!! Loved your teaching style . I think you should seriously think about making a comprehensive Bootcamp on tableau! I will be the first one to buy it. Great stuff!!! BTW, any books you can recommend on Tableau?

[mahuamoti]

No one else so far on youtube has explained LOD that well. Your videos have taken teaching tableau on another level. Thanks a lot

[equiwave]

My mind was blown away from 10 minutes of this video. I will never ever look at LODs the same way again. Thanks for this video!!!

[yitianwang]

The best and clearest LOD explanation I have ever seen! Thanks for your brilliant video!

[noueruz-zaman]

This was one of the best videos I have seen on Tableau teaching. Others just talk lot of waffle and talk and talk and talk for ages before coming to the point.

You get right to the point straightaway.

[huytruong]

This video is a gift to the world. Your teaching skill is at the genius level. Thank you!

[ashishish]

This video should be in Tableau's official training list, the perfect start to understanding LOD so far. Appreciate your efforts to make it very simple.

[DestineeCushing]

I came here because I've never seen my professor for my Data Science program recommend so vehemently that we go watch a video that explains something so well. He honestly based his whole lecture off of it and constantly mentioned how good it was. I was curious why, so I watched the whole thing – even though he covered a lot of the same things! You did such an amazing job that I seriously feel 10x more confident about LOD expressions now. Thank you so much!

[dishaparkhi]

It was always a barrier in my mind about LODs .. how hard to understand.. but after watching your video.. now I am confident enough to write LOD expressions on my own... thank you so much

[AyanDas-rxol]

I was very much frustrated after going to many renowned tutorial on LOD but they were so complex and ambiguous. I am very lucky that I found this video. This is called teaching a complex topic in simple words. thanks you ma'am

[surajchhetri]

i have searched alot for an explanation on LOD and finally i got one i can understand.
NO one else on youtube has explained LOD as good as you, ,

[sarajantas]

I was so overwhelmed with other tutorials and explanations of LOD expressions but this video made everything so clear and approachable. You are great!

[russianspy]

Yet another wonderful explanation on a subject. You are quickly becoming my favorite Tableau teacher. Please keep it coming!

[vijayakanthgonnabathula]

I have watched many videos to understand LOD concepts including community videos made by Tableau team but didn't get understand the actual purpose and use of LOD's but this video made my day happy and boosts my confidence on these calculations. I can say my heartful thanks and requesting to make these kind of videos.

[jollycolours]

I can't thank you enough for taking the effort and time to create this video, your explanation is very clean and easy to understand, appreciate that you walked us through a real example instead of just glossing over the terms. <3 Hope you don't mind having a panda as your subscriber :D

[regonomics]

Wow! This was a better explanation than even the official Tableau material on their website! I'm glad I came across your video.

[nishantsinghpal]

Thank god I found this video. I watched a lot of videos but did not understand these expressions. Great work.

[vinodpandey]

I have been working on tableau for more than 5 years now and have been using LOD, but was struggling to explain this to my team members, therefore thought to refer some notes, I went thru multiple channel but trust me your explanation is the best, you made it very simple.. I am going to copy your style to explain it to my team now :) THANK YOU SO MUCH for putting this together..

[dxwallace]

Very good explanation. Very "granular" You're a good teacher, very clear and thorough, and "easy to digest". Best explanation I've run across on the web. And all the important "tidbits" to expand you understating, like "scalar", "ATTR", how the order of operations/pipeline affects when to use FIXED vs. Exclude. All these little things help you get your head around LOD in a more comprehensive way. This is the LOD video I'll share with others. Thanks!!!!

[shivamshinde]

starting from the basic terminologies like "what is granularity" was fantastic approach..!! Very Helpful !! Thanks!!