Well explained and now i am clear about include and exclude . Thanks you so much.
@geragzzc3 жыл бұрын
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.
@marktossell846110 ай бұрын
I am prepping for the new Tableau Certified Consultant exam, and needed to review LODs - thank you!
@TableauTim10 ай бұрын
Happy to help!
@ummeist Жыл бұрын
Thanks a lot Tim
@DebayanKar73 жыл бұрын
Awesome explanation Tim, 2021 version is out, can you please share the new features
@TableauTim3 жыл бұрын
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.
@derekl28825 ай бұрын
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.
@chandlerrosenthal39143 жыл бұрын
Great content as always! What’s the annotations app you use?
@TableauTim3 жыл бұрын
presentify.compzets.com/ i sue this for mac
@josephkerlin4467 Жыл бұрын
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?
@melanyrodriguez20662 жыл бұрын
Can I use this to exclude a sub-category where its values are null?
@gastondev49193 жыл бұрын
Hello Tim! could you make a video aboute Tableau 2021? I want to explore Einsten... thank you!
@TableauTim3 жыл бұрын
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.
@jacobs49852 жыл бұрын
What if you want to exclude "Tables" and "Paper" in the LOD calculation? How to do so?
@TableauTim2 жыл бұрын
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.
@jacobs49852 жыл бұрын
@@TableauTim I see. I'm planning to use LOD to make the waffle chart. That's why. But, that's good to know. thanks
@rileyorscheln4122 жыл бұрын
@@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.