Tableau Tutorial - Top 1-5 LOD Expressions - Practical Examples (Part 1 LOD calculations)

Introduction

This tutorial covers the top five Level of Detail (LOD) expressions in Tableau, as presented in a video by sqlbelle. LOD expressions allow you to control the granularity of your data calculations, offering powerful insights that regular calculated fields and table calculations may not provide. This guide will walk you through practical examples to enhance your Tableau analytics skills.

Step 1: Understanding Customer Order Frequency

• Objective: Calculate how often customers place orders.
• Action:
  1. Use the COUNTD function to determine the distinct number of orders per customer.
  2. Create a calculated field named Customer Order Frequency:

     { FIXED [Customer ID]: COUNTD([Order ID]) }
     

  3. Drag this field to your visualization to see customer engagement patterns.

Step 2: Performing Cohort Analysis

• Objective: Analyze customer behavior over time by grouping them into cohorts.
• Action:
  1. Identify your cohorts by using the order date.
  2. Create a new field for the cohort:

     { FIXED [Customer ID]: MIN(DATEPART('year', [Order Date])) }
     

  3. Use this field to segment customers and analyze their purchasing patterns over time.

Step 3: Calculating Daily Profit KPI

• Objective: Track daily profit to gauge business performance.
• Action:
  1. Create a calculated field for daily profit:

     { FIXED [Order Date]: SUM([Profit]) }
     

  2. Visualize this field over time to identify trends and spikes in profit.

Step 4: Determining Percent of Total

• Objective: Calculate the percentage contribution of each item to the overall total.
• Action:
  1. Create a field for total sales:

     { SUM([Sales]) }
     

  2. Calculate the percent of total for each item:

     SUM([Sales]) / { SUM([Sales]) }
     

  3. Format the result as a percentage and display it in your dashboard.

Step 5: Analyzing New Customer Acquisition

• Objective: Measure the number of new customers acquired within a specific time frame.
• Action:
  1. Create a calculated field to identify new customers:

     IF FIRST_ORDER_DATE = [Order Date] THEN 1 ELSE 0 END
     

  2. Sum this field to get the total new customers for the desired period.

Conclusion

In this tutorial, we explored five essential LOD expressions in Tableau, demonstrating their application in real-world scenarios. By mastering these calculations, you can enhance your data analysis capabilities and drive more informed business decisions. For further learning, consider reviewing the accompanying workbook and exploring additional parts of the LOD series.