How I Understand LODs

LODs in Tableau can be very difficult to wrap your head around. In this blog I outline my way of understanding the syntax behind them so that I can hopefully help others!

The Syntax

{ FIXED [Customer Name]: MIN([Order Date]) }

My Understanding

In my head, I like to replace the word "FIXED" with "for each". Then, after the colon I like to read it as "Work out this calculation for this field."

My Translation

So, I would read the example syntax as: for each customer name, work out their minimum (i.e. first) order date.

Author:
Tom Gould
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab