Line charts in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a line chart by dragging the correct shelf to the Columns shelf.

Tableau

Drag the [1] field to the Columns shelf to create the x-axis.

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

ASales

BProduct Category

COrder Date

DCustomer Name

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging a measure like Sales to the Columns shelf instead of a date field.

Using a categorical field like Customer Name for the x-axis.

In a line chart, the x-axis usually represents time. 'Order Date' is the correct field to drag to the Columns shelf to show trends over time.

2fill in blank

medium

Complete the code to add the measure to the Rows shelf for the y-axis.

Tableau

Drag the [1] field to the Rows shelf to plot the values.

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

ASales

BOrder Date

CRegion

DCustomer ID

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging a dimension like Region instead of a measure.

Using a date field on the Rows shelf instead of Columns.

The y-axis in a line chart shows the measure values. 'Sales' is the measure to drag to the Rows shelf.

3fill in blank

hard

Fix the error in the line chart by choosing the correct mark type.

Tableau

Change the mark type to [1] to display a line chart.

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

ACircle

BSquare

CBar

DLine

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the mark type as Bar or Circle, which do not create line charts.

Not changing the mark type after adding data.

The mark type must be set to 'Line' to create a line chart in Tableau.

4fill in blank

hard

Fill both blanks to add a filter and color dimension to the line chart.

Tableau

Drag the [1] field to the Filters shelf and the [2] field to the Color shelf.

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

ARegion

BOrder Date

CProduct Category

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using measures like Sales for filters or colors instead of dimensions.

Not adding any filter or color dimension.

Filtering by 'Region' allows focusing on specific areas, and coloring by 'Product Category' differentiates lines by category.

5fill in blank

hard

Fill all three blanks to create a calculated field for cumulative sales over time.

Tableau

CREATE CALCULATED FIELD 'Cumulative Sales' AS RUNNING_[1](SUM([[2]])) OVER (ORDER BY [[3]])

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

ASUM

BSales

COrder Date

DCOUNT

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT instead of SUM for sales aggregation.

Ordering by a non-date field.

Using RUNNING_TOTAL instead of RUNNING_SUM in Tableau syntax.

RUNNING_SUM calculates cumulative sums. We sum 'Sales' ordered by 'Order Date' to get cumulative sales over time.