Exclude Level of Detail Calculation: Tableau Functions

#tableau​ #salesforce​ #analytics​
In this video, I take on one of the most requested videos and that is level of detail calculations specifically the Exclude LOD:
Top 15 LODs j.mp/3lCvqvG​
How the level of detail expressions work: j.mp/3rbAhoM​
How to create level of detail expressions: j.mp/3caOuOF
0:00 Intro
0:50 Setting up our example
3:00 Writing the Exclude level of detail calculation.
3:50 Understanding the Exclude level of detail calculation.
5:45 A more practical example of the Exclude LOD with Parameters
12:24 Building out the Exclude LOD example
15:30 Using Exclude to achieve the final result
23:34 Resources and summary Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

[@shafiqahmeddoddamani5921]

Well explained and now i am clear about include and exclude . Thanks you so much.

[@geragzzc]

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.

[@marktossell8461]

I am prepping for the new Tableau Certified Consultant exam, and needed to review LODs - thank you!

[@TableauTim]

Happy to help!

[@ummeist]

Thanks a lot Tim

[@derekl2882]

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.

[@melanyrodriguez2066]

Can I use this to exclude a sub-category where its values are null?

[@DebayanKar7]

Awesome explanation Tim, 2021 version is out, can you please share the new features

[@TableauTim]

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.

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

[@chandlerrosenthal3914]

Great content as always! What’s the annotations app you use?

[@TableauTim]

presentify.compzets.com/ i sue this for mac

[@gastondev4919]

Hello Tim! could you make a video aboute Tableau 2021? I want to explore Einsten... thank you!

[@TableauTim]

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.

[@jacobs4985]

What if you want to exclude "Tables" and "Paper" in the LOD calculation? How to do so?

[@TableauTim]

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.

[@jacobs4985]

@@TableauTim I see. I'm planning to use LOD to make the waffle chart. That's why. But, that's good to know. thanks

[@rileyorscheln412]

@@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.