LOD #4 - Percent of Total - LOD vs Table Calculations

Sign up for weekly bite-sized tips, lessons and practical tutorials.
sqlbelle.ck.page/posts
#tableau #analytics #lod #calculation
Practice Questions and other digital products
sqlbelle.gumroad.com
Use Case #4 - Percent of Total - LOD vs Table Calculations
This step-by-step, easy-to-follow tutorial shows the difference between table calculations and LOD when calculating percent of total. It also showcases the difference between FIXED and EXCLUDE LOD expressions.
- Discover how to use fixed Level of Detail (LOD) expressions to keep your calculations consistent, regardless of the filters applied.
- Understand the nuanced differences between fixed and exclude LOD expressions when filters are applied, and how this impacts your data visualization and analysis.
-----
This is part of the Top 15 Level of Detail (LOD) Examples, based on the Tableau Whitepaper written by Bethany Lyons.
Each use case is explained in detail, with additional discussion on how LODs compare against regular calculated fields and table calculations, and things to watch out for. Some examples will use combinations of these types of calculations.
A variety of other topics and tidbits/tips and tricks will also be covered - applications of blue vs green, creating bins, drop field window, and many more
Accompanying Workbook to this Video:
public.tableau.com/app/profil...
Whitepaper: Top 15 LOD Expressions (Practical Examples)
www.tableau.com/about/blog/LO...
Need an LOD Refresher? Here is a complete and comprehensive tutorial
• Tableau LOD (Level of ...
LOD Series:
Part 1 - Top 1-5 LOD Expressions - Practical Examples
• Tableau Tutorial - Top...
Part 2 - Top 6-10 LOD Expressions - Practical Examples
• Tableau Tutorial - Top...
Additional Related Videos:
Tableau Calculations Series in sqlbelle channel:
Part 1 - Basic and Aggregate Calculations
• Learn Tableau Basic Ca...
Part 2 - Level of Detail Expressions - FIXED, INCLUDE, EXCLUDE - Complete Tutorial
• Tableau LOD (Level of ...
Part 3 - Table Calculations
• Tableau Table Calculat...
10 Tableau tricks you should know
• 10 Tableau tricks you ...
10 Use Cases for Parameters
• Tableau Tutorial - Par...

[@jphd21]

Love your videos, I have learned a lot from you!! Just one respectful comment, on Minute 5:00, the two percentages will change because they have a dependency on the Sales Variable, although the other variables are fixed, and you can see them changing on the video, so just the totals will remain the same in this particular example when you filter by segment.

[@sqlbelle]

Yes, you are absolutely right, and thank you for pointing it out. The totals would not have changed if there was another LOD (curly brace) on the outermost expression or if, as you suggested, the filter was by segment. Thank you.