Sets for dynamic grouping in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a set that includes all customers with sales over $10,000.

Tableau

IF SUM([Sales]) [1] 10000 THEN 'High Value' ELSE 'Other' END

Drag options to blanks, or click blank then click option'

A>

B=

C<=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using <= instead of > causes the set to include customers with sales less than or equal to 10,000.

Using = will only include customers with exactly 10,000 sales.

We use the greater than operator (>) to select customers with sales over $10,000.

2fill in blank

medium

Complete the code to create a set that dynamically groups products with sales less than $5,000.

Tableau

IF SUM([Sales]) [1] 5000 THEN 'Low Sales' ELSE 'Others' END

Drag options to blanks, or click blank then click option'

A>=

B>

C=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using >= includes products with sales equal or above 5,000, which is incorrect.

Using = only includes products with exactly 5,000 sales.

The less than operator (<) selects products with sales below $5,000 for the set.

3fill in blank

hard

Fix the error in the set calculation to group customers with sales between $5,000 and $15,000.

Tableau

IF SUM([Sales]) [1] 5000 AND SUM([Sales]) [2] 15000 THEN 'Mid Value' ELSE 'Other' END

Drag options to blanks, or click blank then click option'

A>=

B<

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using > excludes sales exactly equal to 5,000.

Using < for the upper bound excludes sales exactly equal to 15,000.

Use >= 5000 for the lower bound and <= 15000 for the upper bound.

4fill in blank

hard

Fill both blanks to create a set that groups products with sales between $1,000 and $4,999 inclusive.

Tableau

IF SUM([Sales]) [1] 1000 AND SUM([Sales]) [2] 4999 THEN 'Target Group' ELSE 'Others' END

Drag options to blanks, or click blank then click option'

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using > excludes sales exactly equal to 1,000.

Using < excludes sales exactly equal to 4,999.

Use >= 1000 to include sales starting at 1,000 and <= 4999 to include sales up to 4,999.

5fill in blank

hard

Fill the blanks to create a set that groups customers with sales above $20,000 and orders count greater than 50.

Tableau

IF SUM([Sales]) [1] 20000 AND COUNT([Order ID]) [2] 50 THEN 'Top Customers' ELSE 'Others' END

Drag options to blanks, or click blank then click option'

A>=

B>

C<=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using >= includes customers with exactly 20,000 sales or 50 orders, which is incorrect here.

Using < or <= reverses the logic and excludes the intended customers.

Use > 20000 for sales above 20,000 and > 50 for orders count greater than 50. The option <= is a distractor and not used here.