Tableau-Desktop-Found Exploring and Analyzing Data Practice Question
You want to show the distribution of Sales across different states and highlight the ones that are performing above the national average. What is the most straightforward way to visualize this?
⚠ Common exam trap
Candidates often attempt to build complex dual-axis charts or calculated fields to compare against an average, ignoring the simplicity of the built-in Analytics pane.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use a Reference Line
Reference lines are the most efficient way to add a benchmark to a visualization. By adding a reference line representing the average of the data, users can immediately identify states that fall above or below the threshold. This provides instant visual context and helps stakeholders make data-driven decisions regarding performance, avoiding the need for complex calculations or extra visual clutter.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create a calculated field to flag values above average
Why it's wrong here
While a calculated field can flag states, it is a backend operation. A reference line is a superior front-end solution because it provides an immediate, interactive visual benchmark that can be adjusted or toggled by the user without modifying the underlying data structure.
- ✓
Use a Reference Line
Why this is correct
A reference line allows you to add an 'Average' line to the axis, providing a clear visual threshold. This is the standard, built-in method for highlighting data points that exceed a specific benchmark, making it the most direct and effective approach for comparing states to an average.
- ✗
Use a Trend Line
Why it's wrong here
Trend lines are used to show the direction and relationship of data over a continuous variable, usually in a scatter plot. They do not provide a fixed benchmark for average values, making them inappropriate for comparing categorical state performance against a national average threshold.
- ✗
Change the mark color to red and blue
Why it's wrong here
While color coding can represent performance, it does not provide the reference point needed to define what the average actually is. Without a visual line or indicator for the average itself, the color-coded categories lack the context necessary for the user to understand the benchmark.
About these practice questions
This Tableau-Desktop-Found question is part of Courseiva's 126-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.