Exclude Level of Detail Calculation: Tableau Functions

Подписаться 177 тыс.

Просмотров 8 тыс.

50% 1

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

Опубликовано:

17 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@shafiqahmeddoddamani5921 3 года назад

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

@geragzzc 3 года назад

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.

@ummeist Год назад

Thanks a lot Tim

@marktossell8461 8 месяцев назад

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

@TableauTim 8 месяцев назад

Happy to help!

@DebayanKar7 3 года назад

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

@TableauTim 3 года назад

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.

@chandlerrosenthal3914 3 года назад

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

@TableauTim 3 года назад

presentify.compzets.com/ i sue this for mac

@melanyrodriguez2066 Год назад

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

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

@gastondev4919 3 года назад

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

@TableauTim 3 года назад

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.

@derekl2882 3 месяца назад

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.

@jacobs4985 2 года назад

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

@TableauTim 2 года назад

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 2 года назад

@@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 2 года назад

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