Free Tableau Course for Data Analytics

// 1. Customer Acquisition Cohort (Level of Detail LOD Expression)
// Finds the very first order date for each customer, regardless of current date filters
[Customer First Order Date] =
{ FIXED [Customer ID] : MIN([Order Date]) }

// 2. Cohort Retention Flag (Row-Level Logic)
// Classifies whether each transaction was made by a first-time or returning buyer
[Customer Type] =
IF [Order Date] = [Customer First Order Date] THEN
    "New Customer"
ELSE
    "Repeat Customer"
END

// 3. Dynamic KPI Selector (Parameter-Driven Switch)
// Allows business users to toggle dashboard metrics between Revenue, Profit, and Margin
[Selected Metric Value] =
CASE [Parameters].[Metric Selector]
    WHEN 'Revenue' THEN SUM([Sales])
    WHEN 'Profit' THEN SUM([Profit])
    WHEN 'Margin %' THEN [Total Profit Margin]
    ELSE SUM([Sales])
END

// 4. Benchmark Variance vs Category Average (LOD + Table Calc)
// Quantifies performance against the fixed regional category benchmark
[Profit vs Category Benchmark] =
SUM([Profit]) - ATTR({ FIXED [Category] : AVG([Profit]) })