Scatter plots in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a scatter plot by placing the correct field on the Columns shelf.

Tableau

Drag the [1] field to the Columns shelf to start building a scatter plot.

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

ASales

BRegion

COrder ID

DCustomer Name

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a text field like Customer Name for the axis.

Using a categorical field like Region on the axis.

In a scatter plot, numeric fields like Sales are placed on the Columns shelf to represent one axis.

2fill in blank

medium

Complete the code to add the correct field to the Rows shelf for the scatter plot.

Tableau

Drag the [1] field to the Rows shelf to complete the scatter plot axes.

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

AOrder Date

BCustomer Segment

CProduct Category

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting a date or categorical field for the axis.

Using non-numeric fields on the Rows shelf.

Scatter plots use numeric fields on both axes. Profit is a numeric measure suitable for the Rows shelf.

3fill in blank

hard

Fix the error in the calculation to create a calculated field for average sales.

Tableau

AVG([1])

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

ACOUNT(Sales)

BSales

CSUM(Sales)

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM(Sales) inside AVG() causes an error.

Using COUNT(Sales) instead of AVG(Sales).

The AVG() function expects a field name, not an aggregation. Use Sales directly inside AVG().

4fill in blank

hard

Fill both blanks to color the scatter plot points by category and size them by sales.

Tableau

Drag the [1] field to Color and the [2] field to Size on the Marks card.

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

ACategory

BSales

CRegion

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Using numeric fields for Color or categorical for Size.

Mixing up the fields for Color and Size.

Color by Category groups points visually. Size by Sales shows magnitude differences.

5fill in blank

hard

Fill all three blanks to filter the scatter plot to show only sales greater than 1000 and profit less than 500, and to label points by product name.

Tableau

Add a filter where [1] > 1000 and [2] < 500, then drag [3] to Label on the Marks card.

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

ASales

BProfit

CProduct Name

DCategory

Attempts:

3 left

💡 Hint

Common Mistakes

Using categorical fields in numeric filters.

Labeling with numeric fields instead of names.

Filter by Sales and Profit to limit data points. Label points with Product Name for clarity.