Detail level of marks in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate total sales at customer level using detail level of marks

You have a sales dataset with fields: CustomerID, OrderID, and SalesAmount. You want to calculate total sales per customer regardless of the view's aggregation level.

Which Tableau calculation correctly uses the detail level of marks to sum sales by customer?

A {INCLUDE [CustomerID]: SUM([SalesAmount])}

B SUM([SalesAmount])

C {FIXED [CustomerID]: SUM([SalesAmount])}

D {EXCLUDE [CustomerID]: SUM([SalesAmount])}

💡 Hint

Think about how to fix the aggregation at the customer level regardless of the view.

The {FIXED [CustomerID]: SUM([SalesAmount])} expression calculates total sales per customer ignoring other dimensions in the view, ensuring the detail level is at customer.

❓ visualization

intermediate

Identify correct detail level of marks for a scatter plot

You create a scatter plot showing SalesAmount on the Y-axis and Profit on the X-axis. You want each point to represent a unique OrderID. Which detail level of marks setting should you use?

A Add <strong>OrderID</strong> to the Detail shelf

B Add <strong>CustomerID</strong> to the Color shelf

C Add <strong>Region</strong> to the Size shelf

D Add <strong>Category</strong> to the Tooltip shelf

💡 Hint

Think about how Tableau defines each mark uniquely.

Adding OrderID to the Detail shelf ensures each mark represents a unique order, controlling the detail level of marks.

🧠 Conceptual

advanced

Effect of adding dimensions to Detail shelf on mark count

In Tableau, what happens to the number of marks in a view when you add more dimensions to the Detail shelf?

A The number of marks increases because each mark represents a more detailed combination of dimensions

B The number of marks decreases because Tableau groups data more

C The number of marks stays the same regardless of Detail shelf changes

D The number of marks becomes zero until you add measures

💡 Hint

Think about how adding dimensions affects granularity.

Adding dimensions to the Detail shelf increases granularity, so Tableau creates more marks representing finer detail combinations.

🔧 Formula Fix

advanced

Identify why marks are aggregated unexpectedly

You created a view with Category and Sub-Category on Rows and SUM(Sales) on Columns. You want each mark to represent individual products, but the marks aggregate at sub-category level. What is the likely cause?

A SUM(Sales) measure is not aggregated properly

B Category and Sub-Category fields are on Columns shelf instead of Rows

C Data source does not contain product-level data

D Product dimension is missing from the Detail shelf or Rows shelf

💡 Hint

Think about what controls the granularity of marks in Tableau.

Without adding the Product dimension to the view or Detail shelf, Tableau aggregates marks at the highest dimension level present, here Sub-Category.

🎯 Scenario

expert

Design a dashboard showing sales by customer and product with correct detail level

You need to build a dashboard that shows total sales by Customer and Product. The dashboard has two sheets: one lists customers with their total sales, and the other lists products with sales filtered by the selected customer. How should you set the detail level of marks and filters to ensure correct interaction?

A Use only SUM(Sales) without LOD; rely on quick filters for interaction

B Use FIXED LOD expressions for sales by customer and product; set dashboard filter action from customer sheet to product sheet

C Use EXCLUDE LOD expressions to remove product detail; no filter actions needed

D Use INCLUDE LOD expressions for sales; apply global filters on customer and product fields

💡 Hint

Consider how to fix aggregation levels and enable filtering between sheets.

FIXED LOD expressions ensure sales are calculated at the correct granularity regardless of view filters. Setting a dashboard filter action from customer to product sheet enables filtering products by selected customer.