AnalystReps

Tableau practice: The FIXED Level of Detail expression

Chapter 11 · 5 questions · included in full access

  1. Question 1 · easy

    FIXED Level of Detail basics

    What does the FIXED keyword do in an LOD expression like {FIXED [Region] : SUM([Sales])}?

    Solve it in your browser

  2. Question 2 · easy

    Customer lifetime sales

    Create Customer Total Sales: total historical sales for each customer using {FIXED [Customer] : SUM([Sales])}.

    Solve it in your browser

  3. Question 3 · easy

    Regional baseline sales

    Create Region Total Sales: total sales locked at the Region level using {FIXED [Region] : SUM([Sales])}.

    Solve it in your browser

  4. Question 4 · medium

    Customer share of regional sales

    Create Share of Region: each mark sales divided by the fixed regional total: SUM([Sales]) / ATTR({FIXED [Region] : SUM([Sales])}).

    Solve it in your browser

  5. Question 5 · easy

    LOD syntax requirements

    What syntax component is strictly mandatory after the colon : in every Level of Detail expression?

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing