Detail level of marks in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a dimension to the Detail shelf in Tableau.

Tableau

Drag the [1] field to the Detail shelf to increase the detail level of marks.

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

AAverage Discount

BSUM(Sales)

CProfit Ratio

DCategory

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging a measure instead of a dimension to Detail.

Confusing Detail with Color or Size shelves.

Dimensions like 'Category' add detail to marks, while measures like 'SUM(Sales)' aggregate data.

2fill in blank

medium

Complete the sentence to explain the effect of adding a field to Detail.

Tableau

Adding a field to Detail [1] the level of granularity in the view without changing the aggregation.

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

Aincreases

Breduces

Cremoves

Dignores

Attempts:

3 left

💡 Hint

Common Mistakes

Thinking Detail changes aggregation.

Confusing Detail with filters.

Adding a field to Detail increases granularity by splitting marks but does not aggregate data differently.

3fill in blank

hard

Fix the error in the sentence about Detail shelf usage.

Tableau

The Detail shelf [1] the color of marks in Tableau.

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

Acontrols

Bdoes not control

Csorts

Dfilters

Attempts:

3 left

💡 Hint

Common Mistakes

Assuming Detail changes color.

Mixing up Detail and Color shelves.

The Detail shelf controls mark granularity, not color. Color is controlled by the Color shelf.

4fill in blank

hard

Fill both blanks to complete the explanation about Detail and aggregation.

Tableau

Adding [1] to Detail increases the number of marks, but the [2] of each mark remains unchanged.

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

Aa dimension

Baggregation

Ccolor

Dfilter

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing color or filter with dimension.

Thinking aggregation changes when adding Detail.

Adding a dimension to Detail splits marks into more granular pieces, but aggregation like SUM or AVG stays the same.

5fill in blank

hard

Fill all three blanks to complete the Tableau calculation for count distinct customers at detail level.

Tableau

COUNTD([1]) is used to count distinct [2] when marks are detailed by [3].

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

ACustomer ID

Bcustomers

CRegion

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales instead of Customer ID for count distinct.

Confusing what field to add to Detail.

COUNTD(Customer ID) counts unique customers. Adding Region to Detail splits marks by region.

Practice

1. What does adding a field to the Detail shelf on the Marks card in Tableau do?

easy

A. It increases the granularity of data shown inside each mark without changing the axes.

B. It changes the axes to include the new field.

C. It filters the data to only show that field.

D. It removes all other fields from the view.

Solution

1. Step 1: Understand the role of Detail on Marks card

   Adding a field to Detail increases the data granularity inside each mark but does not affect the axes.

2. Step 2: Differentiate from axis changes

   Changing axes would require dragging fields to Rows or Columns, not Detail.

3. Final Answer:

   It increases the granularity of data shown inside each mark without changing the axes. -> Option A

4. Quick Check:

   Detail adds granularity without axis change [OK]

Hint: Detail adds data inside marks, not on axes [OK]

Common Mistakes:

• Confusing Detail with Rows or Columns shelf
• Thinking Detail filters data
• Assuming Detail changes axis labels

2. Which of the following is the correct way to add a field to increase detail level in Tableau?

easy

A. Drag the field to Rows shelf

B. Drag the field to Color on the Marks card

C. Drag the field to Detail on the Marks card

D. Drag the field to Filters shelf

Solution

1. Step 1: Identify the correct shelf for detail level

   The Detail shelf on the Marks card controls granularity inside marks.

2. Step 2: Understand other shelves' roles

   Rows changes axes, Filters limit data, Color changes mark color.

3. Final Answer:

   Drag the field to Detail on the Marks card -> Option C

4. Quick Check:

   Detail shelf controls mark granularity [OK]

Hint: Detail shelf is for granularity, not Rows or Filters [OK]

Common Mistakes:

• Dragging fields to Rows instead of Detail
• Using Filters to add detail instead of limit data
• Confusing Color with Detail

3. Given a scatter plot with Sales on Columns and Profit on Rows, what happens if you drag Category to Detail on the Marks card?

medium

A. The color of marks changes based on Category.

B. The axes change to include Category as a dimension.

C. The plot filters to show only one Category at a time.

D. Each mark now represents a unique combination of Sales, Profit, and Category, showing more detailed points.

Solution

1. Step 1: Understand effect of adding Category to Detail

   Adding Category to Detail breaks marks into more granular points by Category without changing axes.

2. Step 2: Confirm axes remain Sales and Profit

   Axes remain unchanged because Category is not on Rows or Columns.

3. Final Answer:

   Each mark now represents a unique combination of Sales, Profit, and Category, showing more detailed points. -> Option D

4. Quick Check:

   Detail adds granularity inside marks, axes unchanged [OK]

Hint: Detail adds granularity, axes stay same [OK]

Common Mistakes:

• Thinking axes change when adding to Detail
• Assuming filter or color change happens
• Confusing Detail with Color or Filter shelves

4. You added Region to Detail on the Marks card but the marks did not change. What is the most likely reason?

medium

A. Region has the same value for all data points, so no new detail is added.

B. Region was added to Filters shelf instead of Detail.

C. You need to add Region to Rows or Columns for it to affect marks.

D. Detail shelf only works with numeric fields.

Solution

1. Step 1: Check data uniqueness of Region

   If Region has the same value for all points, adding it to Detail won't change marks.

2. Step 2: Understand Detail shelf behavior

   Detail adds granularity only if the field has multiple distinct values.

3. Final Answer:

   Region has the same value for all data points, so no new detail is added. -> Option A

4. Quick Check:

   Detail needs distinct values to change marks [OK]

Hint: Detail needs varied values to affect marks [OK]

Common Mistakes:

• Assuming Detail only works with numeric fields
• Confusing Detail with Filters or Rows
• Not checking data uniqueness

5. You want to create a tooltip that shows Customer Name details on a sales scatter plot without changing the axes. How should you use the Detail shelf?

hard

A. Drag Customer Name to Rows shelf to add it to the axes.

B. Drag Customer Name to Detail on the Marks card to add granularity and enable detailed tooltips.

C. Drag Customer Name to Color to differentiate marks by customer.

D. Add Customer Name to Filters to limit data shown.

Solution

1. Step 1: Identify how to add detail without changing axes

   Dragging Customer Name to Detail adds granularity inside marks without changing axes.

2. Step 2: Understand effect on tooltips

   Adding Customer Name to Detail enriches tooltips with that information.

3. Final Answer:

   Drag Customer Name to Detail on the Marks card to add granularity and enable detailed tooltips. -> Option B

4. Quick Check:

   Detail adds granularity and tooltip info without axis change [OK]

Hint: Use Detail for tooltips without axis change [OK]

Common Mistakes:

• Adding Customer Name to Rows changes axes
• Using Color instead of Detail for tooltips
• Filtering data instead of adding detail