Data Source Level of Detail Function in Tableau (Quick Tip)

An LOD that allows us to fix at the data source is so helpful when we need to hardcode an overall total, or create a filter that filters to the latest date in our dataset (that might not be today), and a myriad of other use cases!
By using the curly braces {} in an expression, we can tell Tableau that we want to fix our expression at the data source.
I'll walk you through several examples of how this might be helpful to you in this week's video!
Connect with us:
•Book an hour to work with Ollie: onenumber.biz/office-hours
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Resources:
•Example Tableau Workbook: public.tableau.com/views/Data...
•FIXED Expression: onenumber.biz/blog-1/2024/3/1...
•Unraveling the Mystery of LOD Expressions: onenumber.biz/blog-1/2020/5/1...
Chapters
0:00 FIXED vs. Data Source Level LOD
0:57 MAX Date Filter
2:42 Worksheet Title Totals
4:15 Order of Operations
4:55 Tableau Office Hours & Classes
5:25 Custom Worksheet Title Label
8:22 Hard-Coded % of Total

[@onenumbertableau]

Need help with Tableau? Schedule an hour with Ollie here: onenumber.biz/office-hours
Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes

[@jaqiehaas]

Nice examples! You guys are doing a great job.

[@onenumbertableau]

Thanks so much Jacques!

[@wendyware3064]

Extremely useful! Obtaining LOD at data source level was not in my toolkit!

[@onenumbertableau]

We're so glad this was useful!

[@wendyware3064]

Extremely helpful! Quickly obtaining LOD at data source level was not in my toolkit!

[@onenumbertableau]

Amazing, so glad to hear you can add this to your arsenal. Thanks Wendy!