AnalystReps

Tableau practice: Advanced FIXED and nested cohorts

Chapter 12 · 5 questions · included in full access

  1. Question 1 · easy

    Customer first order date

    Create First Order Date: find the earliest Order Date for each customer using {FIXED [Customer] : MIN([Order Date])}.

    Solve it in your browser

  2. Question 2 · medium

    Customer order tenure

    Create Days Since First Order: elapsed days between the customer first order date and the current order line.

    Solve it in your browser

  3. Question 3 · medium

    Multi-dimension regional segment baseline

    Create Region Segment Total: calculate total sales locked to both Region and Segment simultaneously.

    Solve it in your browser

  4. Question 4 · easy

    FIXED evaluation order

    In the Tableau Order of Operations pipeline, do FIXED expressions evaluate before or after standard dimension filters?

    Solve it in your browser

  5. Question 5 · hard

    Segment average order baseline

    Create Segment Avg Order: the average order sales value fixed strictly at the Segment level.

    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