Data Source Level of Detail Function in Tableau (Quick Tip)
🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8
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: https://onenumber.biz/office-hours
•Upcoming Tableau Classes: https://onenumber.biz/onenumber-table...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Resources:
•Example Tableau Workbook: https://public.tableau.com/views/Data...
•FIXED Expression: https://onenumber.biz/blog-1/2024/3/1...
•Unraveling the Mystery of LOD Expressions: https://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
