LODs in Tableau: The Ultimate Guide to Level of Detail Expressions

[@frandc4499]

Thank you So much Andy. When you said "change For each by Fixed" understood perfectly the Fixed Function. God Job!

[@ijaen]

Me too!

[@sj8648]

Wow this is the best LOD tutorial on KZbin for sure!

[@kevinhenry1681]

Andy...thanks soo much for explaining and showing how LOD works!

[@AliciaMarkoe]

Thank you for these videos!

[@cameronsmith7758]

Thanks! I don't think I understand why adding Region to the Fixed Customer Name expression changed the numbers. I would have thought Tableau was already dividing up the Customers after you dragged the Region pill in and then counting up the unique orders of the customers in each of those regions?

[@mikarshdataanalyst4086]

Thanks for Helping me out with this one👍👍👍

[@nareshmuppala4399]

Excellent video sir thank you so much your explanation 👍

[@YEM_]

So glad you posted this, because I was thinking "I use Include for that". I was really confused...

[@YEM_]

The way you name the measures though, I would still use Include, so you don't need to edit the measure when adding a dimension. I would use fixed when I want Tableau to ignore a dimension in the body of the report.

[@suneelkumar5912]

@Andy, How to swap the sheets with multi value selection using parameters or filters dashboard level

[@prikha16]

Hi Andy, all your videos are very helpful. In the last example here , including region in the fixed Lod did not change anything in the view, it is the same as it was without region in the calculation. Is it showing correct numbers?

[@ZoeyXWang]

Hello Andy, thanks so much for giving us such a valuable and practical lesson on LOD. However, I do have one question. After the Regions By Product Calculated Field being created, you dragged Quarters and Years on the shelves, the view was divided by Years and Quarters. The question is what is the difference between this view (without further Datetrunc functions added ) and the view with Datetrunc functions added in the Calculated Fields in the end? Thanks again:) If my question does not make sense to you please let me know.

[@DanielWeikert]

Thanks a lot. I build something similar but I do not really understand why to use LOD. What is the main advantage. I built the same visualization with the "normal" count. Still a beginner so your answer is highly appreciated. Thanks And what exactly was the difference in the last question.Even without using region in lod the numbers seperated by colour were correct, but the chart changed slightly? Why?

[@omkar8101]

Hi Andy, I used fixed for customer name, region and category and counted distinct order id. But it is giving me wrong results when I include category in fixed calculation. Without the 'region' in 'fixed', I am getting 3 count for 1st customer and with 'region' in 'fixed' calculation, I am getting 5 as count.

[@9i9ja]

The Workout Wednesday part got me.

[@vizwiz]

What do you mean?

[@9i9ja]

I was referring to the notification that popped up during the tutorial. Wonderful breakdown of LODs, Andy!

[@bhavi9826]

Thanks for ur detail explaination 👏👏my trainer failed to explain. When I asked about lod

[@jsx0328]

Awesome video

[@MichaelApau-xb3xb]

Thanks Andy

[@vizwiz]

You bet

[@codygarcia8976]

For the last example, could you bring in region into the Page's LOD and use the Include LOD exp. for Customer instead of adding it to the Dimension List?

[@vizwiz]

Yes, but I prefer fixed LODs because I have more control over them and where they compute in the order of operations.

[@satishchaudhary7875]

Could you do it for include and exclude as well ?, so that we can understand it in plain English

[@MrAsanni]

Question Andy ( I love your videos BTW) - after creating the fixed LOD (Customer order frequency), why did you make it a dimension?

[@neilvanasselt7107]

Once its a dimension it is discrete with no aggregation

[@neelmanishrivastava]

hey @andy can you please answer the questions asked below??.. it would help us alot. Thanks

[@vizwiz]

ask on the forums if you need additional help.

[@Green89_]

I’m not understanding the difference between the answers before you add region to the calculation and after for the first problem. For example, once you add region, the count of orders column goes up to 8 max for East but before you add region, the count of orders columns go up to 13 for East. Can you explain the difference more clearly?