Grouping members in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a group of selected members in Tableau.

Tableau

GROUP([1])

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

AOrder Date

BSUM(Sales)

CRegion

DCustomer Name

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure like SUM(Sales) instead of a dimension.

Trying to group on a date field without aggregation.

In Tableau, grouping members is done by selecting the dimension you want to group, such as Customer Name.

2fill in blank

medium

Complete the code to create a calculated field that groups 'East' and 'West' regions together.

Tableau

IF [Region] = [1] OR [Region] = 'West' THEN 'West & East' ELSE [Region] END

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

A'South'

B'East'

C'North'

D'Central'

Attempts:

3 left

💡 Hint

Common Mistakes

Using a region name not included in the group.

Forgetting to include the ELSE part to keep other regions unchanged.

This calculation groups the 'East' and 'West' regions into one group called 'West & East'.

3fill in blank

hard

Fix the error in the calculated field to group customers with sales above 1000 as 'High Value'.

Tableau

IF SUM([Sales]) [1] 1000 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 '<' which would group low sales as 'High Value'.

Using '=' which only matches exactly 1000.

The condition should check if sales are greater than 1000 to classify as 'High Value'.

4fill in blank

hard

Fill both blanks to create a group that combines 'Furniture' and 'Office Supplies' categories.

Tableau

IF [Category] = [1] OR [Category] = [2] THEN 'Combined Group' ELSE [Category] END

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

A'Furniture'

B'Technology'

C'Office Supplies'

D'Clothing'

Attempts:

3 left

💡 Hint

Common Mistakes

Using categories not meant to be grouped.

Forgetting to use quotes around category names.

This calculation groups 'Furniture' and 'Office Supplies' into one group called 'Combined Group'.

5fill in blank

hard

Fill all three blanks to create a calculated field grouping customers by sales range.

Tableau

IF SUM([Sales]) [1] 500 THEN 'Low' ELSEIF SUM([Sales]) [2] 1500 THEN 'Medium' ELSE [3] END

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

A<=

B<

C'High'

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up comparison operators causing overlapping ranges.

Not returning a string in the ELSE part.

This calculation groups sales into 'Low' if less than 500, 'Medium' if less or equal to 1500, and 'High' otherwise.