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?
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.
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?
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?
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.
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.
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?
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?
![Tableau LOD Expressions [Overview of Tableau Level of Detail Calculation]](/img/n.gif)
Thank you So much Andy. When you said "change For each by Fixed" understood perfectly the Fixed Function. God Job!
Me too!
Wow this is the best LOD tutorial on TH-cam for sure!
Andy...thanks soo much for explaining and showing how LOD works!
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?
Thank you for these videos!
Thanks for Helping me out with this one👍👍👍
So glad you posted this, because I was thinking "I use Include for that". I was really confused...
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.
Excellent video sir thank you so much your explanation 👍
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?
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?
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.
@Andy, How to swap the sheets with multi value selection using parameters or filters dashboard level
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.
Thanks for ur detail explaination 👏👏my trainer failed to explain. When I asked about lod
Thanks Andy
You bet
The Workout Wednesday part got me.
What do you mean?
I was referring to the notification that popped up during the tutorial. Wonderful breakdown of LODs, Andy!
Could you do it for include and exclude as well ?, so that we can understand it in plain English
Question Andy ( I love your videos BTW) - after creating the fixed LOD (Customer order frequency), why did you make it a dimension?
Once its a dimension it is discrete with no aggregation
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?
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?
Yes, but I prefer fixed LODs because I have more control over them and where they compute in the order of operations.
Awesome video
hey @andy can you please answer the questions asked below??.. it would help us alot. Thanks
ask on the forums if you need additional help.