✅ Tableau LOD Expressions Level of Detail 📊🔥

👉 LOD Level of Detail Expressions are one of the most powerful and frequently asked Tableau interview topics. 
They allow you to perform calculations at a different level of granularity than what is currently shown in the visualization.

🔹 1. What are LOD Expressions? 
LOD Expressions let you control how data is aggregated. 
👉 Normally, Tableau calculates values based on the current view. 
👉 LOD lets you calculate values independently of the visualization.

🔥 2. Why Use LOD Expressions? 
✔ Calculate metrics at different levels 
✔ Compare individual values to totals 
✔ Create advanced KPIs 
✔ Improve dashboard flexibility 

🔹 3. Types of LOD Expressions ⭐ 
There are three main types:

✅ FIXED 
Calculates values at a specific level. 
{ FIXED [Region] : SUM([Sales]) } 
👉 Calculates total sales for each region regardless of what's in the view.

✅ INCLUDE 
Adds dimensions to the current view. 
{ INCLUDE [Customer Name] : SUM([Sales]) } 
👉 Includes customer-level calculations.

✅ EXCLUDE 
Removes dimensions from the current view. 
{ EXCLUDE [Product] : SUM([Sales]) } 
👉 Ignores product-level detail.

🔹 4. Example of FIXED LOD 
Suppose you want: 
👉 Total Sales by Region 
Even when viewing sales by product. 
{ FIXED [Region] : SUM([Sales]) } 
This value remains constant for the region.

🔹 5. Real-World Example 
Calculate each customer's contribution to total regional sales: 
SUM([Sales]) / { FIXED [Region] : SUM([Sales]) }

🔹 6. Difference Between Aggregate & LOD 
Aggregate: Depends on current view, Simple calculations, Dynamic with visualization 
LOD: Independent of current view, Advanced calculations, Fixed granularity control 

🔹 7. When to Use LOD? 
✔ Customer contribution analysis 
✔ Regional benchmarking 
✔ Advanced KPIs 
✔ Performance comparisons 

🔹 8. Common Interview Question ⭐ 
Q: Which LOD expression ignores the dimensions in the current view? 
✅ Answer: FIXED 

🔹 9. Why LOD is Important? 
✔ Advanced Tableau skill 
✔ Frequently asked in interviews 
✔ Used in enterprise dashboards 
✔ Makes complex calculations easier 

🎯 Today's Goal 
✔ Understand FIXED, INCLUDE, EXCLUDE 
✔ Learn granularity concepts 
✔ Build advanced Tableau calculations 

👉 Double Tap ❤️ For More