Mark types (automatic, bar, line, circle) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the mark type to a bar chart in Tableau.

Tableau

worksheet.mark_type = '[1]'

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

Abar

Bline

Ccircle

Dautomatic

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'line' instead of 'bar' for bar charts.

Using 'circle' which creates scatter plots.

In Tableau, setting the mark type to 'bar' creates a bar chart visualization.

2fill in blank

medium

Complete the code to set the mark type to a line chart in Tableau.

Tableau

worksheet.mark_type = '[1]'

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

Acircle

Bautomatic

Cbar

Dline

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'circle' which creates scatter plots.

Choosing 'bar' which creates bar charts.

Setting the mark type to 'line' in Tableau creates a line chart, useful for showing trends over time.

3fill in blank

hard

Fix the error in the code to set the mark type to circle in Tableau.

Tableau

worksheet.mark_type = '[1]'

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

Acircle

Bline

Cbar

Dautomatic

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'bar' or 'line' which create different chart types.

Using 'automatic' which lets Tableau decide the mark type.

The correct mark type for circle marks in Tableau is 'circle'. This creates scatter plot points.

4fill in blank

hard

Fill both blanks to set the mark type to automatic and then to bar in Tableau.

Tableau

worksheet.mark_type = '[1]'
worksheet.mark_type = '[2]'

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

Aautomatic

Bbar

Cline

Dcircle

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order of mark types.

Using 'circle' or 'line' instead of 'bar' for the second mark type.

First setting mark type to 'automatic' lets Tableau choose the best mark type. Then setting it to 'bar' explicitly changes it to a bar chart.

5fill in blank

hard

Fill all three blanks to set the mark type to circle, then line, then bar in Tableau.

Tableau

worksheet.mark_type = '[1]'
worksheet.mark_type = '[2]'
worksheet.mark_type = '[3]'

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

Acircle

Bline

Cbar

Dautomatic

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the order of mark types.

Using 'automatic' instead of specific mark types.

This sequence sets the mark type first to circle (scatter points), then line (trend lines), and finally bar (bar chart) in Tableau.

Practice

1. In Tableau, what does the Automatic mark type do?

easy

A. It converts all data points into circles.

B. It always shows data as bars regardless of data type.

C. It lets Tableau choose the best mark type based on the data.

D. It forces the data to be displayed as a line chart.

Solution

1. Step 1: Understand the Automatic mark type purpose

   The Automatic mark type allows Tableau to decide the best way to show data visually based on the data's structure and fields used.

2. Step 2: Compare with fixed mark types

   Unlike fixed types like Bar, Line, or Circle, Automatic adapts to the data, choosing the most suitable mark type automatically.

3. Final Answer:

   It lets Tableau choose the best mark type based on the data. -> Option C

4. Quick Check:

   Automatic = Tableau chooses mark type [OK]

Hint: Automatic means Tableau picks the best mark type for you [OK]

Common Mistakes:

• Thinking Automatic always shows bars
• Confusing Automatic with a fixed mark type
• Assuming Automatic forces circles or lines

2. Which of the following is the correct way to set a mark type to Bar in Tableau?

easy

A. Drag a measure to Rows and select 'Circle' from the Marks card.

B. Double-click the data field and Tableau sets it to Automatic.

C. Right-click the axis and select 'Line'.

D. Click the Marks card dropdown and choose 'Bar'.

Solution

1. Step 1: Locate the Marks card in Tableau

   The Marks card controls how data is visually represented. To change mark type, you use the dropdown on this card.

2. Step 2: Select the Bar mark type

   Clicking the dropdown and choosing 'Bar' sets the visualization to bar marks.

3. Final Answer:

   Click the Marks card dropdown and choose 'Bar'. -> Option D

4. Quick Check:

   Marks card dropdown -> Bar [OK]

Hint: Use Marks card dropdown to pick Bar mark type [OK]

Common Mistakes:

• Selecting Circle instead of Bar
• Right-clicking axis to change mark type (wrong place)
• Assuming double-click sets Bar automatically

3. Given a time series data with dates on Columns and sales on Rows, which mark type will Tableau choose automatically to best show trends?

medium

A. Line

B. Bar

C. Circle

D. Automatic will always choose Pie

Solution

1. Step 1: Understand data type and visualization goal

   Time series data with dates and sales is best shown as a trend over time, which is usually a line chart.

2. Step 2: Know Tableau's Automatic behavior

   Tableau's Automatic mark type detects time series and picks Line marks to show trends clearly.

3. Final Answer:

   Line -> Option A

4. Quick Check:

   Time series + Automatic = Line [OK]

Hint: Automatic picks Line for time series trends [OK]

Common Mistakes:

• Choosing Circle for trend data
• Thinking Bar is default for time series
• Assuming Automatic picks Pie charts

4. You set the mark type to Line but your visualization shows disconnected points instead of a continuous line. What is the most likely cause?

medium

A. The date field is treated as a string, not a date.

B. You forgot to select Circle mark type.

C. The measure is on Columns instead of Rows.

D. Automatic mark type was selected instead of Line.

Solution

1. Step 1: Check data type of the date field

   If the date is treated as text (string), Tableau cannot connect points in order, so lines appear disconnected.

2. Step 2: Understand effect on line marks

   Line marks require a continuous axis like dates. Strings break continuity, causing points to show separately.

3. Final Answer:

   The date field is treated as a string, not a date. -> Option A

4. Quick Check:

   Disconnected lines = date as string [OK]

Hint: Ensure date fields are date type for continuous lines [OK]

Common Mistakes:

• Switching to Circle mark type unnecessarily
• Thinking measure placement causes disconnected lines
• Assuming Automatic mark type causes this issue

5. You want to compare sales amounts across product categories using a clear visual. Which mark type should you choose and why?

hard

A. Line, because it shows trends over categories.

B. Bar, because it compares quantities across categories clearly.

C. Circle, because it highlights individual data points.

D. Automatic, because it always picks Circle for categories.

Solution

1. Step 1: Identify the data and comparison goal

   Comparing sales amounts across categories is about comparing quantities side by side.

2. Step 2: Choose the best mark type for comparison

   Bar charts are best for comparing amounts across categories because bars show length differences clearly.

3. Step 3: Understand why other marks are less suitable

   Line marks show trends over time, circles highlight points but don't compare sizes well, Automatic may not pick Bar.

4. Final Answer:

   Bar, because it compares quantities across categories clearly. -> Option B

5. Quick Check:

   Category comparison = Bar chart [OK]

Hint: Use Bar marks to compare amounts across categories [OK]

Common Mistakes:

• Using Line marks for category comparison
• Choosing Circle marks for quantity comparison
• Relying on Automatic without checking mark type