Tableau Level of Detail for Sales Aggregation
A sales manager wants a dashboard that shows sales aggregated by region and identifies high-volume sales by salesperson per region. Which of the following techniques best displays this information?
Community Insight
The question tests the ability to select data visualization techniques that handle mixed granularity, specifically avoiding options that only filter or parameterize rather than compute.
Level of detail expressions are the correct technique to display aggregated sales by region while simultaneously identifying high-volume sales per salesperson. This approach allows for multiple granularities within a single view.
Candidates often confuse Level of Detail with Filter options. Filters restrict data but do not calculate specific aggregations across different dimensions like region and salesperson independently.
Community Discussion (1 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Level of Detail (LOD) expressions in Tableau allow you to compute values at a level of detail different from the view's current level of detail. By using an LOD expression, the dashboard can aggregate sales by region (e.g., SUM(Sales) FIXED BY Region) while also evaluating individual salesperson performance against those regional totals. This dual-granularity requirement is precisely what LOD expressions are designed to solve.Why the Other Options Are Wrong
Defined parameters (A) are used for user input, such as selecting a date range or a specific value, not for calculating aggregations. Filter options (B) restrict the data displayed in the view but do not enable the calculation of metrics at a different grain than the visual elements shown. User persona (D) is a conceptual design element describing the target audience, not a technical feature for displaying data aggregation.Community Comment Notes
As Amelia233 noted, "Level of Detail (LOD) allows a dashboard to display data at different levels of granularity," which directly addresses the need to show both regional aggregates and individual salesperson volumes. The community consensus strongly supports this interpretation of how LOD functions in reporting scenarios.Exam Strategy
When a question asks to display data at two different granularities (e.g., aggregate vs. individual), immediately look for 'Level of Detail' or 'LOD' as the answer. Avoid filters if the goal is to show calculated relationships between different data grains.
Frequently Asked Questions
Why is a filter option incorrect for showing regional sales and individual performance?
Filters only restrict the dataset shown; they cannot calculate a metric at one granularity (region) while displaying it alongside another (salesperson).
Can defined parameters replace level of detail for aggregation?
No. Parameters accept user input values (like a number or text string) but do not perform mathematical aggregations on the underlying data.
Related Analysis
Practice All DA0-002 Questions
Access 100 questions with complete answers and detailed explanations.
View Full DA0-002 Practice Test →