AnalystReps

Tableau practice: Level of detail with INCLUDE and EXCLUDE

Chapter 13 · 5 questions · included in full access

  1. Question 1 · easy

    INCLUDE versus EXCLUDE

    What is the fundamental difference in granularity between INCLUDE and EXCLUDE LOD expressions?

    Solve it in your browser

  2. Question 2 · medium

    Average customer sales by region

    Create Avg Customer Sales: compute average customer spend by region using AVG({INCLUDE [Customer] : SUM([Sales])}).

    Solve it in your browser

  3. Question 3 · medium

    Product share of category

    Create Category Share: compute each product share of category sales by excluding Product: SUM([Sales]) / SUM({EXCLUDE [Product] : SUM([Sales])}).

    Solve it in your browser

  4. Question 4 · easy

    Filter inheritance in EXCLUDE

    Unlike FIXED expressions, how do INCLUDE and EXCLUDE expressions behave when a user adjusts a standard dimension filter?

    Solve it in your browser

  5. Question 5 · hard

    Regional total excluding segment

    Create Region Sales Excl Segment: compute territory sales by excluding Segment: SUM({EXCLUDE [Segment] : SUM([Sales])}).

    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