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

FIXED LOD

A Tableau LOD expression that aggregates at exactly the listed dimensions, ignoring the view's dimensions.

Definition

FIXED is evaluated before dimension filters in the order of operations, so it ignores them unless they are context filters. It is used for cohort analysis, customer-level metrics and percent-of-total denominators.

Example

{FIXED [Region] : SUM([Sales])}

Exam tip

To make a dimension filter affect a FIXED LOD, add the filter to context.

Related terms