Thanks a lot Tim. I usually used LOD functions in a "trial and error" sort of way. Thanks to you I now understand how each of them works. You got a new suscriber.
If I wanted to Exclude two categories, how would I do that? if there were three levels of granularity. We can call them Category, Sub category, and Sub sub category. I wish to have all 3 in my view but I still only wish to include "Category" in my calculation. How can I remove Sub category and sub sub category from the calculation?
The excluding sub-category to sum the selected subcat sales seem convoluted. It seems like there should be a single formula that simply returns the subcat sales without the exclude gymnastics.
Thats just a filter if you want to remove them. They are attributes of the category and subcategory so you cant write an LOD to exclude them on their own. As the video shows your excluding a dimension from the detail for the aggregation of the view.
@@TableauTim What about excluding two dimension such as in a hierarchy? I have total Sales, and I want to exclude Category & Sub-Category. How do I exclude both? Essentially, I'm looking for % of Total to be adaptive to a hierarchy.
Hi Gaston unfortunately Tableau didn't have a beta so I only just got my hands on it today like everyone else. I'll be updating the channel with features as I go but thats on the list. Einstein is also a little hard to get your hands on without setting up the right setup on salesforce so might take a little longer than usual.
Well explained and now i am clear about include and exclude . Thanks you so much.
Thanks a lot Tim. I usually used LOD functions in a "trial and error" sort of way. Thanks to you I now understand how each of them works. You got a new suscriber.
I am prepping for the new Tableau Certified Consultant exam, and needed to review LODs - thank you!
Happy to help!
Awesome explanation Tim, 2021 version is out, can you please share the new features
There was no beta for 2021.1 so i've only had it for 9 hours so it will take time. I usually have it for 3 months before release.
Thanks a lot Tim
If I wanted to Exclude two categories, how would I do that? if there were three levels of granularity. We can call them Category, Sub category, and Sub sub category. I wish to have all 3 in my view but I still only wish to include "Category" in my calculation. How can I remove Sub category and sub sub category from the calculation?
Can I use this to exclude a sub-category where its values are null?
The excluding sub-category to sum the selected subcat sales seem convoluted. It seems like there should be a single formula that simply returns the subcat sales without the exclude gymnastics.
What if you want to exclude "Tables" and "Paper" in the LOD calculation? How to do so?
Thats just a filter if you want to remove them. They are attributes of the category and subcategory so you cant write an LOD to exclude them on their own. As the video shows your excluding a dimension from the detail for the aggregation of the view.
@@TableauTim I see. I'm planning to use LOD to make the waffle chart. That's why. But, that's good to know. thanks
@@TableauTim What about excluding two dimension such as in a hierarchy? I have total Sales, and I want to exclude Category & Sub-Category. How do I exclude both? Essentially, I'm looking for % of Total to be adaptive to a hierarchy.
Hello Tim! could you make a video aboute Tableau 2021? I want to explore Einsten... thank you!
Hi Gaston unfortunately Tableau didn't have a beta so I only just got my hands on it today like everyone else. I'll be updating the channel with features as I go but thats on the list. Einstein is also a little hard to get your hands on without setting up the right setup on salesforce so might take a little longer than usual.
Great content as always! What’s the annotations app you use?
presentify.compzets.com/ i sue this for mac