Tableau LOD Expressions [Overview of Tableau Level of Detail Calculation]

Рет қаралды 94,369

6 жыл бұрын

What are LODs? How do I use them?
Free Tableau LOD Expressions Guide - vizual.consulting/lodblog
Tableau LOD Expressions are probably the hardest topic to fully understand, or at least it was for me when it first came out. To be honest I dodge this explanation as much as possible haha, probably why it took me so long to write a blog about it. It’s just one of those topics that is very hard to explain, you just have to show someone what it does then the light bulb turns on. So if you are reading this and at the end you’re still confused, please watch the video. I promise it’s a much better way to learn this concept.
#tableau #tableautraining #tableaututorial #tableautiptuesday

Пікірлер: 86

@TheArjit 4 жыл бұрын

One of best possible explanations for LOD expressions. Thank You.

@engineermajidd 4 жыл бұрын

been confused and lost for a long time until i saw this video, thank you for clearing fog for me! Best LOD explanation, gonna forward this to many people lol

@natashasen3548 2 жыл бұрын

One of the best explanation of LOD. Finally I understand the concept. Thank you very much.

@johnsauer9156 4 жыл бұрын

Great video with concise details, much appreciated!

@archanaprajapati6784 3 жыл бұрын

Thank you so much for explaining LOD. I guess this is the best explanation available on youtube.

@Coolthoom 3 жыл бұрын

Thank you so much for breaking this down so clearly. I have a much better understanding of LODs now.

@ankitamitkari188 3 жыл бұрын

soo good! I cant believe I finally got it!! Thank you so much for explaining so clearly!!

@ducjoshnguyen Жыл бұрын

Great explanations and examples. You made it so easy to follow and understand. Thank you!

@romyli5159 4 жыл бұрын

This video is excellent! Reading a lot of the articles on LOD only made me more confused. This video clearly distinguishes the concepts. Big thanks!

@tina09eg 4 жыл бұрын

this is by far the best simplest explanation of LOD I have come across. great... but how does one know when to use an LOD? thanks

@vaibhavbansal7 2 жыл бұрын

Thanks a lot! This helped me understand LOD way quickly. Very clear and easy to understand. 😃

@jeffrey6124 Жыл бұрын

This Tableau LOD video deserves 1M 👍

@jmtz7460 5 жыл бұрын

very helpful explanation! Thankyou and congratulations

@ipsa1234 3 жыл бұрын

one of d best LOD videos explained, thank you :)

@yvettehicks4822 3 жыл бұрын

Best tutorial of LOD. Thanks!

@rhishikeshjoshi3209 4 жыл бұрын

Nicely Explained. Loved it!

@huiqingxu5286 3 жыл бұрын

Thank you very much! This is very helpful for me to understand LOD.

@2612karthik 3 жыл бұрын

Wonderful explanation.. Thanks for saving my time researching..

@miteshbagwe9765 3 жыл бұрын

Great explanation. Thank you for sharing.

@richisancheti6871 5 жыл бұрын

This was extremely helpful and lucid. Thanks a lot :)

@vizualIntelligence 5 жыл бұрын

You are very welcome!

@charlesabboud1613 3 жыл бұрын

Concise and very helpful thank you sir!

@lekhsharma4448 4 жыл бұрын

Very good and detail video. Appreciated presenter.

@alexprykhodko3097 5 жыл бұрын

Thanks for a clear explanation! A very helpful video.

@vizualIntelligence 5 жыл бұрын

Your welcome Alex, I am releasing an good one about tableau stories next week

@duztv5370 4 жыл бұрын

Thanks for this sir. You absolutely did justice to it. thanks

@angellavado763 2 жыл бұрын

Thanks a lot! I better understand now the difference between these LOD functions. Thanks once again.

@9833020183 3 жыл бұрын

You saved my 1 hour by making this video. Thanks!

@the_learner12 5 жыл бұрын

excellent explanation!

@MissFSimoes 2 жыл бұрын

Thanks for sharing your knowledge!!

@syedzeeshan6697 3 жыл бұрын

Thank you for clear explanation.

@Atlas-ck9vm 5 жыл бұрын

Great and concise explanation, thanks for the video :)

@vizualIntelligence 5 жыл бұрын

You are very welcome

@rohitprajapati2303 3 жыл бұрын

You made it easy to understand. Thanks man

@joseluismietta6018 5 жыл бұрын

Great video!!!! Very clear. :)

@ravulasandeep2512 2 жыл бұрын

Super Clear!!!

@drummersaad 2 жыл бұрын

Excellent. Thank you.

@My191185 5 жыл бұрын

Thank you! Thank you! Thank you! very well explained, had been looking for a video like this for days...

@vizualIntelligence 5 жыл бұрын

Thanks stay with us. 🙂

@My191185 5 жыл бұрын

@@vizualIntelligence Do you also have a video on types of filters in tableau? I couldn't find it...

@P2Tmedia 5 жыл бұрын

heartfully I suggest this video for LODs nice video than so many experts for LODs remaining I have to see

@vizualIntelligence 5 жыл бұрын

Thanks, put a lot of time into it hope your learned a lot!

@mtro.alfonsodominguezsalci9976 6 жыл бұрын

very clear, thank you!!!

@vizualIntelligence 6 жыл бұрын

Awesome glad you liked it man

@kishorchindhe1930 2 жыл бұрын

Nice Explanation

@victorbepositive6825 4 жыл бұрын

Thank you for the video. Very detailed and intuitive. I have one question, how can I show the vendor with the Max (ave) sales?

@navinkrishnan9419 4 жыл бұрын

Thank you!

@emilordonez 5 жыл бұрын

What an excellent explanation man. Thanks a lot

@vizualIntelligence 5 жыл бұрын

Your welcome man! You have another topic you think will be a good one?

@vizualIntelligence 5 жыл бұрын

Your welcome man! You have another topic you think will be a good one?

@rajeshtukdeo 5 жыл бұрын

Nice video !!

@vizualIntelligence 5 жыл бұрын

Thanks Rajesh, appreciate it!

@sputnikfish3389 3 жыл бұрын

Tableau should post this video on their website instead of those confusing explanations.

@shakendramichelle6295 6 ай бұрын

I loved the video, I can't get the guide downloaded though

@andreaberta9111 3 жыл бұрын

Great explanation, Thank you! However, would you please tell me how to get 'Manufacturer" linked to Superstore data source? My version does not have it.

@riginetay5017 3 жыл бұрын

Thank U!

@xinwen4886 3 жыл бұрын

thanks a lot

@1UniqueAcademy 5 жыл бұрын

Great Video. In BusinessObjects we achieve same thing using ForEach , ForAll, In

@vizualIntelligence 5 жыл бұрын

Thanks! I honestly never used BusinessObjects, how do you like it?

@pranavireddypakala2861 2 жыл бұрын

Hi, Ca you please let me know how did you get the Manufacturer field in dimensions?

@manishjain8091 4 жыл бұрын

very simple and easy explanation as compare to edureka . thanks

@tareqnaushad1967 3 жыл бұрын

thanks. Now i know what is LOD

@teenanandwani8823 5 жыл бұрын

Hey, please tell me what exactly a Tableau server is and what's the difference between Tableau server and Tableau online

@romyli5159 4 жыл бұрын

A brief sum of the video: FIXED is most powerful, does NOT depend on what's in the view, and can replicate all the functions of INCLUDE/EXCLUDE; INCLUDE/EXCLUDE depends on the level of detail already in the view, INCLUDE adds additional dimensions to the calculation, whereas EXCLUDE removes some existing dimensions from the calculation.

@lauraallen8768 3 жыл бұрын

Great vid! I need more help, trying to nest an IF statement into Fixed LOD calculation and going in circles. Summary of Desired outcome: Dimension "Ind" represents a transaction type, of which I only want to view for values "ABD", "YTD" and "ENC." The measure "Amount" contains the values which should be aggregated at these levels: • If dimension "Ind" is "ABD" include sum of all values in measure "Amount" • If dimension "Ind" is "YTD" include sum of all values in measure "Amount" • If dimension "Ind" is "ENC" include only sum of current year (21) values in measure "Amount" Anyone?! :)

@liftcombr 4 жыл бұрын

It's like sql cube?

@michafabich4372 3 жыл бұрын

any chances to resume publishing new videos? this content is tremendous :)

@danchips9588 3 жыл бұрын

Has anyone ever used the Fixed LOD expression to calculate average monthly sales for a listing of account IDs? I am struggling to do so because within my data not all accounts have transactions in every month which is causing the calculation to return higher that average monthly sales.

@stanislavezhevski2877 3 жыл бұрын

LOD = window functions in SQL am I right ?

@LoganNinefingers 3 жыл бұрын

I can’t seem to get the AVERAGE of the SUM of sales of different product categories (each category contains hundreds of different products). So it would just be one number, the average sales of each category. Anybody got any hints? I feel like it’s super easy but My brain has dried up..Much appreciated!

@michaelcheung6290 3 жыл бұрын

LOD is like window functions in SQL?

@mr_smilegaming8842 2 жыл бұрын

Yep same concept different syntax

@chrisjfox8715 3 жыл бұрын

At 9:47 when you removed Manufacturer from the shelf, and before you took the averages, why didn't the Include column values remain "the same" best they could considering the fact that the Include calculated field was supposed to always use the Manufacter LOD?

@AnuragTK 4 жыл бұрын

sanks brahhh

@scoutsden7193 3 жыл бұрын

Great, I was thinking why would you not always use fixed, then you said you almost always do. Otherwise, someone could absent mindedly drag something on to the grid and the numbers would change. 😠

@radouaneelberrak8636 5 жыл бұрын

Thanks for the video. The link is not working: Free Tableau LOD Expressions Guide - vizual.consulting/lodblog

@vizualIntelligence 5 жыл бұрын

Due to vulnerability in social warfare plugin of wordpress many sites including our site has been affected by hacker. Our developer team is working to fix it. Soon you can download.