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?
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?
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?
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?