Very informative video, so I am doing this for an assignment for my class, and I was wondering, what exactly is the major difference between include and exclude?
Thank you for the video! If I wanted to compare the YTD monthly sum of 2020 to the historical average monthly sum from 2016-2019, how would I accomplish that? I've successfully created an LOD calc that compares YTD 2020 to the average monthly sum, but it includes 2020. Any help is appreciated!
What if you wanted to exclude Both Province and Product Sub-category? IE - ability to compare sales against product category while keeping both the sub category and the province.
This is really helpful! But I am wondering why not just do a fixed LOD on Province instead of an Exclude LOD specifying sub-category? I'm learning and trying to wrap my head around when it's most useful to use each type of LOD expression. Thank you!
Same here…even dimensions filter have higher priority over exclude then what is the use of using it …I mean why can get results without using it too can anyone explain it
When I try to use "Exclude" in the Calculated Field, it doesn't recognize that it exists or is a function! Do you know why this is happening and how I can fix this?
Which version of Tableau are you using? If you're using a very early one, it may not be available. When you go to create a calculated field, there's a little list of functions you can pop out on the right hand side (there's a little arrow). Is Exclude available in there? Remember too that it has { } around it (curly brackets) not ( ). I'm not sure if that could be your challenge?
Thanks for replying! It turns out I need to "Extract Data" from my datasets because I imported them from Microsoft Access. I couldn't see the "Exclude" function at all in the little list of functions that pop out on the right hand side but just extracting it fixed my issue.
![Tableau LOD Expressions [Overview of Tableau Level of Detail Calculation]](http://i.ytimg.com/vi/IvZd1L9zWxo/mqdefault.jpg)
Why have you stopped making videos? These are gold!
Thank you for getting your point across so quickly love these short videos !
Very informative video, so I am doing this for an assignment for my class, and I was wondering, what exactly is the major difference between include and exclude?
Thank you for the video! If I wanted to compare the YTD monthly sum of 2020 to the historical average monthly sum from 2016-2019, how would I accomplish that? I've successfully created an LOD calc that compares YTD 2020 to the average monthly sum, but it includes 2020. Any help is appreciated!
What if you wanted to exclude Both Province and Product Sub-category? IE - ability to compare sales against product category while keeping both the sub category and the province.
I want to get vice versa. how can we do that?
This is really helpful! But I am wondering why not just do a fixed LOD on Province instead of an Exclude LOD specifying sub-category? I'm learning and trying to wrap my head around when it's most useful to use each type of LOD expression. Thank you!
Same here…even dimensions filter have higher priority over exclude then what is the use of using it …I mean why can get results without using it too can anyone explain it
What if I only want to exclude the "Tables"?
Clear and concise.
display category wise max subcategory sales where view should contain two columns category and max sales sub-category.Can you give this solution
{ FIXED {[Sub-Category]: MAX([Sales])}
I can't download the data.
When I try to use "Exclude" in the Calculated Field, it doesn't recognize that it exists or is a function! Do you know why this is happening and how I can fix this?
Which version of Tableau are you using? If you're using a very early one, it may not be available. When you go to create a calculated field, there's a little list of functions you can pop out on the right hand side (there's a little arrow). Is Exclude available in there?
Remember too that it has { } around it (curly brackets) not ( ). I'm not sure if that could be your challenge?
Thanks for replying! It turns out I need to "Extract Data" from my datasets because I imported them from Microsoft Access. I couldn't see the "Exclude" function at all in the little list of functions that pop out on the right hand side but just extracting it fixed my issue.
Ah - nice! I didn't know that was a problem. Always learnin'
Glad you figured it out!
Thank you very much,
very helpful
Bingo!! :)