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

@ijaen

4 жыл бұрын

Me too!

Wow this is the best LOD tutorial on KZread 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!

Excellent video sir thank you so much your explanation 👍

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

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.

Awesome video

Thanks for Helping me out with this one👍👍👍

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

Thanks Andy

@vizwiz

Жыл бұрын

You bet

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.

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

3 жыл бұрын

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

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?

The Workout Wednesday part got me.

@vizwiz

3 жыл бұрын

What do you mean?

@9i9ja

3 жыл бұрын

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

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

@vizwiz

5 жыл бұрын

ask on the forums if you need additional help.

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?

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

@YEM_

7 жыл бұрын

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.

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

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?

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

@neilvanasselt7107

3 жыл бұрын

Once its a dimension it is discrete with no aggregation