LOD with date dimensions in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows sales amounts for different order dates.

Cell	Value
A1	Order Date
B1	Sales
A2	2024-01-01
B2	100
A3	2024-01-01
B3	150
A4	2024-01-02
B4	200
A5	2024-01-02
B5	50
A6	2024-01-03
B6	300

Formula Trace

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

Step 1: Group data by each unique Order Date

Step 2: Sum Sales for 2024-01-01

Step 3: Sum Sales for 2024-01-02

Step 4: Sum Sales for 2024-01-03

Step 5: Assign summed values back to each row by Order Date

Cell Reference Map

     A           B
1 | Order Date | Sales
2 | 2024-01-01 | 100  
3 | 2024-01-01 | 150  
4 | 2024-01-02 | 200  
5 | 2024-01-02 | 50   
6 | 2024-01-03 | 300  

Arrows: LOD groups by column A (Order Date) and sums column B (Sales).

The formula uses Order Date (column A) to group sales (column B) and sum them.

Result

     A           B      C
1 | Order Date | Sales | LOD Sales
2 | 2024-01-01 | 100   | 250      
3 | 2024-01-01 | 150   | 250      
4 | 2024-01-02 | 200   | 250      
5 | 2024-01-02 | 50    | 250      
6 | 2024-01-03 | 300   | 300      

The LOD Sales column shows total sales per Order Date repeated for each row of that date.

Sheet Trace Quiz - 3 Questions

What does the LOD expression { FIXED [Order Date] : SUM([Sales]) } do?

A Calculates average sales per row

B Calculates total sales for all dates combined

C Calculates total sales for each Order Date ignoring other filters

D Filters sales to only one date

Key Result

LOD FIXED groups data by specified dimension(s) and calculates aggregation ignoring other filters.