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.