pbPassingBI
/
tableau/quizzes/level-of-detail-tableau-practice-quiz
advanced 10 questions

Level of Detail Practice

FIXED, INCLUDE and EXCLUDE drills.

  1. Which LOD ignores the dimensions in the view entirely?

    1. INCLUDE
    2. FIXED
    3. EXCLUDE
    4. All of them

    Answer: FIXED — FIXED uses only the dimensions you name.

  2. Which LOD uses the view dimensions plus the ones you name?

    1. FIXED
    2. INCLUDE
    3. EXCLUDE
    4. None

    Answer: INCLUDE — INCLUDE adds to the view level, letting you compute finer then re-aggregate.

  3. You need a total that stays constant while the view breaks down by Region. Use:

    1. {FIXED [Region] : SUM([Sales])}
    2. {EXCLUDE [Region] : SUM([Sales])}
    3. {INCLUDE [Region] : SUM([Sales])}
    4. SUM([Sales])

    Answer: {EXCLUDE [Region] : SUM([Sales])} — EXCLUDE removes Region from the computation, holding the value at the higher level.

  4. {FIXED : SUM([Sales])} with no dimensions returns:

    1. Null
    2. A grand total across the filtered data
    3. Sales per row
    4. An error

    Answer: A grand total across the filtered data — With no dimensions it computes a single total over the whole (filtered) data set.

  5. An LOD expression is written with:

    1. Square brackets
    2. Curly braces
    3. Parentheses
    4. Angle brackets

    Answer: Curly braces — The syntax is {FIXED [Dim] : AGG([Measure])}.

  6. Average customer spend per region is best written as:

    1. AVG([Sales])
    2. AVG({INCLUDE [Customer ID] : SUM([Sales])})
    3. {FIXED [Region] : AVG([Sales])}
    4. SUM([Sales])/COUNTD([Customer ID])

    Answer: AVG({INCLUDE [Customer ID] : SUM([Sales])}) — Compute per customer with INCLUDE, then average those results at the view level.

  7. A FIXED expression ignores your quick filter. The fix is to:

    1. Change to INCLUDE
    2. Add the filter to Context
    3. Use an extract
    4. Sort the view

    Answer: Add the filter to Context — Context filters run before FIXED in the order of operations.

  8. In the order of operations, FIXED is evaluated:

    1. Before all filters
    2. After dimension filters but before measure filters
    3. After table calculations
    4. Last

    Answer: After dimension filters but before measure filters — That position is exactly why FIXED appears to ignore view-level dimension filters.

  9. To label each customer by the year of their first purchase:

    1. YEAR(MIN([Order Date]))
    2. YEAR({FIXED [Customer ID] : MIN([Order Date])})
    3. {EXCLUDE [Customer ID] : MIN([Order Date])}
    4. MIN(YEAR([Order Date]))

    Answer: YEAR({FIXED [Customer ID] : MIN([Order Date])}) — The FIXED gives each customer their own first date; wrapping in YEAR makes the cohort.

  10. Which LOD types respond to what is on the shelves?

    1. FIXED only
    2. INCLUDE and EXCLUDE
    3. All three equally
    4. None

    Answer: INCLUDE and EXCLUDE — INCLUDE and EXCLUDE are relative to the view; FIXED is not.