thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Level of Detail Expression (LOD)

A Tableau calculation that computes aggregates at a specified level of detail independent of the view: FIXED, INCLUDE or EXCLUDE.

Definition

FIXED computes at the specified dimensions regardless of view dimensions, though context filters apply first. INCLUDE adds dimensions to the view's level. EXCLUDE removes dimensions from it.

Example

{FIXED [Customer ID] : MIN([Order Date])} -- first purchase date per customer

Exam tip

FIXED LODs ignore dimension filters unless they are added to context; INCLUDE and EXCLUDE respect them.

Related terms