AnalystReps

Tableau practice: Logical branching with IF and CASE

Chapter 6 · 5 questions · included in full access

  1. Question 1 · easy

    Order size tier

    Create Order Size: classify orders by Sales as Large (₹40,000+), Medium (₹15,000 to ₹39,999), or Small (under ₹15,000).

    Solve it in your browser

  2. Question 2 · easy

    Discount Band

    Create Discount Band: use CASE [Discount] to return None when 0, Standard when 0.05, and Deep for any other discount rate.

    Solve it in your browser

  3. Question 3 · easy

    CASE versus IF statements

    When is a CASE statement preferred over an IF statement in Tableau calculations?

    Solve it in your browser

  4. Question 4 · medium

    High value order flag

    Create High Value Flag: return True if Sales is at least ₹30,000, and False otherwise: [Sales] >= 30000.

    Solve it in your browser

  5. Question 5 · medium

    Tiered commission rate

    Create Commission Rate: return 0.08 (8%) if Sales >= ₹40,000, 0.05 (5%) if Sales >= ₹15,000, and 0.02 (2%) otherwise.

    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