Study guide
8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs
Salesforce Certified Tableau Data Analyst Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Connecting to Data & The Logical Data Model
1.1 Data Connections: Live Connections vs. Hyper Extracts 1.2 The Tableau Data Model: Relationships vs. Physical Joins 1.3 Combining Data: Data Blending vs. Cross-Database Joins
2 Chapter 2: Tableau Prep Builder & Data Wrangling
2.1 Tableau Prep Architecture & Data Cleaning 2.2 Reshaping Data in Prep: Pivots, Splits & Wildcard Unions 2.3 Joins, Aggregations & Output Destinations in Prep
3 Chapter 3: Data Quality, Metadata & Field Configuration
3.1 Data Types, Roles, Organization & Default Properties 3.2 In-Desktop Data Cleaning: Splits, Data Interpreter & Source Replacement 3.3 Managing Slowly Changing Dimensions & Data Quality Warnings
4 Chapter 4: Tableau Fundamentals & Calculations
4.1 Dimensions vs. Measures & Discrete vs. Continuous 4.2 Mastering Dates: Discrete Date Parts vs. Continuous Date Truncations 4.3 Calculations: Logic, Strings, Nulls & Type Conversion 4.4 Aggregation Rules, Granularity & Dealing with the Asterisk (ATTR)
5 Chapter 5: Level of Detail (LOD) Expressions
5.1 Level of Detail Architecture & Scoping Syntax 5.2 FIXED LOD Expressions: Scoping & Baseline Benchmarks 5.3 INCLUDE & EXCLUDE LOD Expressions: Dynamic Granularity 5.4 Real-World LOD Patterns: Cohorts, First/Last Dates & Binning
6 Chapter 6: Table Calculations & Directionality
6.1 Table Calculation Mechanics: Addressing vs. Partitioning 6.2 Essential Table Calculations: Running, Window & Percent of Total 6.3 Navigation & Ranking Functions: LOOKUP, INDEX & RANK 6.4 Secondary & Nested Table Calculations: Multi-Level Scoping
7 Chapter 7: Statistical Analytics, Filtering & Order of Operations
7.1 The Tableau Order of Operations: From Extract to Display Filters 7.2 Sets, Set Actions & Combined Sets vs. Groups 7.3 Parameters, Parameter Actions & Dynamic What-If Analysis 7.4 Analytics Pane: Totals, References, Trends & Forecasts
8 Chapter 8: Chart Types & Comparative Visualizations
8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs 8.2 Part-to-Whole & Correlation Charts: Treemaps, Scatter Plots & Bubbles 8.3 Trend & Distribution Visualizations: Dual-Axis, Combos & Histograms
9 Chapter 9: Advanced Visualizations & Spatial Analysis
9.1 Specialized Visualizations: Waterfall, Gantt, Sparklines & Bump Charts 9.2 Spatial Data & Mapping: Geographic Layers & Spatial Functions 9.3 Visual Polish: Custom Palettes, Annotations & Viz in Tooltip
10 Chapter 10: Dashboard Design & Interactive Actions
10.1 Dashboard Layout, Devices & Visibility 10.2 Filter, Highlight & URL Actions 10.3 Advanced Interactivity: Parameter, Set & Navigation Actions 10.4 Stories & Visual Storytelling: Sequencing Analytical Narratives
11 Chapter 11: Tableau Server & Cloud: Architecture & Publishing
11.1 Tableau Server & Cloud: Sites, Projects, Roles & Permissions 11.2 Publishing Workbooks, Data Sources & Flows
12 Chapter 12: Data Governance, Security & Operations
12.1 Certification, Data Quality, Lineage & Permissions 12.2 Row-Level Security, Schedules, Subscriptions & Alerts
8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs
Key Takeaways Explain This Topic AI
Horizontal bar charts leverage common baseline alignment and accommodate lengthy categorical labels without truncation, whereas vertical column charts are best suited for sequential, ordinal, or chronological categories.
Stacked bar charts illustrate part-to-whole relationships across categories, but comparing non-baseline (secondary and tertiary) segments across bars is perceptually inaccurate without 100% normalization or small multiples.
Diverging bar charts align survey distributions or Likert scales around a central neutral baseline, using calculated negative offsets to project negative sentiments leftward while positive sentiments extend rightward.
Highlight tables require a cross-tab structure with a measure on Color, a measure on Text, and an explicit mark type of Square, contrasting with heat maps which encode data simultaneously through mark size and color.
Bullet graphs provide a compact, data-dense alternative to radial dashboard gauges by combining a primary performance bar (actuals), a target reference line, and qualitative background distribution bands (e.g., 60% and 80% of goal).
Last updated: September 2026
8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs
Comparative visual analytics forms the bedrock of business intelligence reporting. When stakeholders evaluate performance, their primary analytical questions center on comparison: How did Region A perform against Region B? Did actual revenue meet budgeted expectations? Which customer segments generate the highest transaction volume? For the Salesforce Certified Tableau Data Analyst, selecting the precise chart type to answer these comparative questions is not merely an aesthetic choice—it is a rigorous scientific decision grounded in human visual perception, mark encoding rules, and cognitive efficiency.
Anatomy and Mechanics of Bar Charts in Tableau
Bar charts are the workhorse of data visualization. According to graphical perception research pioneered by William Cleveland and Robert McGill, human vision decodes quantitative values encoded as position along a common scale with higher accuracy than any other visual attribute (such as length, angle, area, or color saturation). In Tableau Desktop, bar charts translate discrete categorical dimensions on one shelf and continuous measures on the opposing shelf into rectangular marks originating from a shared baseline.
1. Horizontal vs. Vertical Bar Charts
The choice between horizontal and vertical bar orientations depends on dimensional cardinality, label length, and the nature of the data:
Horizontal Bar Charts (Measure on Columns, Dimension on Rows) : Horizontal bar charts represent the industry standard for categorical comparisons where dimension members possess lengthy descriptive names (e.g., Sub-Category , Department Name , or Job Title ). Placing the discrete dimension on Rows creates horizontal rows where text labels render left-to-right without truncation, rotation, or awkward 45-degree angling. Furthermore, vertical scrolling on dashboards feels natural to users navigating long lists of items.
Vertical Bar Charts / Column Charts (Dimension on Columns, Measure on Rows) : Vertical bar charts are preferred when the categorical dimension represents an ordinal, sequential, or temporal sequence (e.g., Fiscal Quarter , Month , Age Tier , or Survey Rating 1 to 5 ). Human cognitive mental models associate time and progression with left-to-right movement along an X-axis. Horizontal Layout: [Columns: SUM(Sales) ] [Rows: Sub-Category ] -> Best for long labels
- Vertical Layout: [Columns: Fiscal Quarter] [Rows: SUM(Sales) ] -> Best for ordinal/time sequences
- 2. Stacked Bar Charts: Power and Perceptual Pitfalls
A Stacked Bar Chart is generated when an author places a continuous measure on one shelf, a primary dimension on the opposing shelf, and drops a secondary categorical dimension onto the Color shelf on the Marks card. Tableau segments each bar into colored blocks whose lengths correspond to the contribution of each dimensional member.
The Baseline Alignment Limitation
While stacked bar charts effectively display total volume across bars and provide a rough sense of part-to-whole breakdown, they introduce severe perceptual limitations for comparative analysis:
The Primary Segment (Baseline) : The segment resting directly on the zero baseline (at the bottom of vertical bars or the far left of horizontal bars) is easy to compare across categories because all instances share a common alignment.
The Secondary and Floating Segments : Every segment stacked above or to the right of the baseline segment suffers from a floating baseline . Because the starting position of the second segment depends entirely on the height of the first segment, comparing the lengths of the middle or top segments across different bars is cognitively taxing and prone to misinterpretation.
The 100% Stacked Bar Solution
When relative percentage share is more critical than absolute volume, authors convert the view into a 100% Stacked Bar Chart :
Apply a Quick Table Calculation to the measure pill: Percent of Total .
Configure Compute Using to Cell or the appropriate partition dimension (e.g., Table (Across) or Table (Down) ).
Every bar expands to 100%, aligning both the 0% baseline and the 100% top/right boundary, enabling accurate evaluation of the boundary segments. Absolute Stacked Bar: [Bar 1: Furniture $100 | Office $50 | Tech $200] = Total $350 (Floating internal baselines)
- 100% Stacked Bar: [Bar 1: Furniture 28.6% | Office 14.3% | Tech 57.1%] = Total 100% (Normalized scales)
- 3. Diverging Bar Charts for Survey & Likert Scale Data
When analyzing Likert scale sentiment surveys (e.g., ratings ranging from Strongly Disagree to Strongly Agree ), standard stacked bars obscure the divide between positive and negative sentiment. A Diverging Bar Chart aligns survey responses around a central neutral baseline (zero axis), projecting negative sentiments to the left (negative X-values) and positive sentiments to the right (positive X-values).
Construction Mechanics:
Splitting Sentiment : Create calculated fields separating counts into negative and positive components. For neutral responses (e.g., Neither Agree nor Disagree ), standard practice divides the count in half, allocating 50% to the negative side and 50% to the positive side: // Negative Offset Calculation
- IF [Response] = 'Strongly Disagree' THEN -[Count]
- ELSEIF [Response] = 'Disagree' THEN -[Count]
- ELSEIF [Response] = 'Neutral' THEN -([Count] / 2)
- END
- Positive Extension : Author a complementary calculation for positive responses: // Positive Offset Calculation
- IF [Response] = 'Strongly Agree' THEN [Count]
- ELSEIF [Response] = 'Agree' THEN [Count]
- ELSEIF [Response] = 'Neutral' THEN ([Count] / 2)
- END
Dual-Axis Alignment : Place both calculated measures on Columns, synchronize the axes, and color by Response . The result is a clean diverging visualization where stakeholders instantly spot whether overall sentiment leans positive or negative across survey prompts.
Highlight Tables vs. Heat Maps: Architectural and Visual Distinctions
A frequent source of confusion on the Salesforce Certified Tableau Data Analyst examination is the distinction between a Highlight Table and a Heat Map . While both present tabular, grid-based arrangements of dimensions, their Marks card encodings, visual channels, and Show Me definitions differ fundamentally. +-----------------------------------------------------------------------------------------+
- | CROSS-TAB GRID LAYOUT |
- | |
- | HIGHLIGHT TABLE HEAT MAP |
- | +-----------------------+ +-----------------------+ |
- | | [ $45,200 ] | <- Full cell colored | [ ■ ] | <- Mark |
- | | (Square mark + Text) | background | (Size = Sales | size |
- | +-----------------------+ | Color = Profit) | varies
- | +-----------------------+ |
- +-----------------------------------------------------------------------------------------+
- 1. Highlight Tables: Color-Encoded Text Cross-Tabs
A Highlight Table is a cross-tab (pivot table) whose individual grid cells are shaded with background color corresponding to a continuous measure, while the numerical values remain displayed as text inside each cell.
Step-by-Step Construction in Tableau Desktop:
Drag one or more discrete dimensions to Rows (e.g., Department ) and Columns (e.g., Region ) to establish the grid framework.
Drag a continuous measure (e.g., SUM(Sales) ) to the Color shelf on the Marks card.
Drag the same continuous measure (or another metric) to the Label (Text) shelf on the Marks card.
Critical Configuration Step : In the Marks card dropdown menu, change the mark type from Automatic (or Text ) explicitly to Square .
Why this matters : If left on Automatic or Text , Tableau colors only the font digits of the text, leaving the background white. Explicitly selecting Square expands the mark to fill the entire geometric cell boundaries.
Adjust the Size slider to maximum so the square marks tile seamlessly across the grid without white gutters.
2. Heat Maps: Multi-Metric Grid Encodings (Size & Color)
In Tableau's formal terminology (and within the Show Me panel), a Heat Map is a visualization where marks within a dimensional grid are encoded simultaneously by Color and Size :
Show Me Requirements : 1 or more dimensions, 1 or 2 measures.
Encoding Structure : One measure is placed on the Size shelf (controlling the physical dimensions of the square or shape), while a second measure is placed on the Color shelf.
Use Case : Comparing two distinct quantitative dimensions across a two-dimensional matrix. For example, plotting Order Priority vs. Ship Mode , where the size of each square represents SUM(Sales) (volume) and the color represents AVG(Discount) or SUM(Profit) (efficiency).
Comprehensive Comparison Matrix: Highlight Table vs. Heat Map
- Architectural Attribute Highlight Table Heat Map (Tableau Native Definition)
- Primary Visual Mark Square mark type sized to fill the entire cell Square , Circle , or custom Shape mark
- Marks Card Shelves Used Measure on Color AND Measure on Label (Text) Measure on Color AND Measure on Size
- Show Me Requirements 1+ Dimensions, exactly 1 Measure 1+ Dimensions, 1 to 2 Measures
Text Values Displayed Yes; numerical figures are permanently visible inside cells Optional; labels can be added but often omitted to avoid crowding
Data Density Moderate; cell size must accommodate legible text strings High; marks can scale down to compact matrix dots
Color Palette Best Practice Diverging palette if crossing zero; Sequential if strictly positive Diverging palette for margin/profit; Sequential for volume
Primary Analytical Intent Rapid identification of extreme values within an exact cross-tab Spotting multi-variable patterns, clusters, and anomalies
Bullet Graphs: Performance vs. Target
Traditional executive dashboards frequently rely on speedometer-style radial gauges or dial widgets. Data visualization expert Stephen Few designed the Bullet Graph specifically to overcome the physical limitations of gauges, which consume massive screen real estate, hide historical context, and exhibit very low data-ink ratios.
A bullet graph is a specialized variation of a standard bar chart engineered specifically for evaluating performance against predefined targets and historical benchmarks within a compact footprint. +-----------------------------------------------------------------------------------------+
- | BULLET GRAPH ANATOMY |
- | |
- | 0k 20k 40k 60k 80k 100k 120k |
- | +----------+----------+----------+----------+---------+----------+ |
- | | | | | |
- | | ██████████████████████████████████ | | | |
- | | (Primary Bar: Actual Sales $72k) | | | |
- | | | | | |
- | +--------------------------------------|------|------------------+ |
- | [========== 60% Band ==========] | | |
- | [================ 80% Band ============] | |
- | [====================== 100% Target Line =====] ($95k Target) |
- +-----------------------------------------------------------------------------------------+
- Core Structural Components of a Bullet Graph
Every bullet graph in Tableau Desktop integrates three structural layers:
The Primary Bar Mark (Actual Performance) : A solid horizontal or vertical bar representing the current actual quantitative measurement (e.g., YTD Sales , Actual Revenue , or Headcount ).
The Target Reference Line (Benchmark / Goal) : A distinct, perpendicular reference line cutting across the bar axis at the exact coordinate of the target measure (e.g., Sales Quota , Budgeted Revenue , or Prior Year Sales ).
Qualitative Distribution Reference Bands (Contextual Tiers) : Background shaded bands that divide the performance space into qualitative categories. By default, Tableau establishes these bands at 60% and 80% of the target measure value (representing 'Poor' and 'Satisfactory' thresholds), with the region beyond the target representing 'Exceeding'.
- Building Bullet Graphs via Show Me and Manual Assembly
- Method 1: Using Show Me
In the Data pane, hold Ctrl (or Cmd on macOS) and multi-select at least two continuous measures (e.g., Actual Sales and Sales Target ) plus one or more discrete dimensions (e.g., Sales Region ).
Open the Show Me pane and click the Bullet Graph icon.
Tableau automatically designates one measure as the bar and the other as the reference line.
The Inversion Problem: 'Swap Reference Line Fields'
A frequent occurrence during Show Me generation is measure inversion: Tableau places the target on the bar and actuals on the reference line. Rather than tearing down the worksheet, Tableau provides a dedicated context menu shortcut:
Right-click the numeric value axis on the canvas.
Select Swap Reference Line Fields .
Tableau instantly swaps the underlying measure assignments, re-establishing Actuals on the primary bar and Target on the reference line and distribution bands.
Method 2: Manual Assembly via the Analytics Pane
Understanding manual bullet graph construction is tested on the certification exam because it unlocks custom thresholds and formatting:
Place the discrete dimension (e.g., Sales Region ) on Rows and the actual measure ( SUM(Sales) ) on Columns to generate a standard horizontal bar.
Drag the target measure ( SUM(Target Sales) ) to the Detail shelf on the Marks card. Placing it on Detail injects the field into the worksheet's underlying data table without visually altering the marks.
Switch to the Analytics pane on the left sidebar.
Drag Reference Line onto the canvas, dropping it on the Cell scope for the numeric axis. Set the line value to SUM(Target Sales) aggregated as SUM (or Average ).
Drag Reference Band (or Distribution Band ) from the Analytics pane to the Cell scope. Under Computation, configure the distribution as Percentages with values 60, 80 of SUM(Target Sales) . Check Fill Below and select a soft gray palette.
- Exam Traps & Practical Scenarios
- Critical Pitfalls
Warning
Exam Trap: Automatic Mark Type on Highlight Tables When asked how to convert a text table into a highlight table, exam options will often suggest "drag the measure to Color". If the Mark type remains set to Automatic , Tableau only colors the text font numbers. The correct answer requires explicitly selecting Square on the Marks card dropdown and placing the measure on both Color and Label.
Caution
Exam Trap: Bullet Graph Inversion Fix If an exam question describes a bullet graph where the target quota is mistakenly rendered as the solid bar and actual sales as the line, look for the option that specifies "Right-click the axis and choose Swap Reference Line Fields" . Manually deleting and rebuilding the calculation is an inefficient distractor.
Note
Exam Trap: Secondary Segment Comparison in Stacked Bars When comparing sub-category trends across multiple years, stacked bar charts fail because internal segments lack a shared baseline. To compare secondary segments accurately, the author must either convert the view into a 100% Stacked Bar (if comparing relative proportions) or disassemble the stack into Small Multiples (separate bar charts per sub-category) to restore a common baseline.
- Practical Scenarios
- Scenario 1: Enterprise Sales Quota Monitoring
A commercial sales director oversees 150 enterprise account executives. Each representative has an individual quarterly quota. The dashboard must fit on a single laptop screen, allowing the director to immediately identify underperforming reps without reading numeric tables.
Architectural Solution : A horizontal Bullet Graph . Account Executives on Rows, Actual Sales on Columns (Bar), Quota on Detail (Reference Line at 100%, bands at 60% and 80%). Reps whose bars fall short of the 80% band are immediately flagged for intervention.
Scenario 2: Hospital Emergency Room Utilization Matrix
A healthcare operations team needs to monitor patient volume and average wait times across 7 days of the week and 24 hourly shift windows. Hospital leadership wants to quickly spot congestion hotspots while retaining the exact patient count for staffing models.
Architectural Solution : A Highlight Table . Day of Week on Rows, Hour of Day on Columns, Patient Count on Label, and Patient Count on Color with a sequential Red palette and Mark type set to Square . Exact staffing counts remain readable while color saturation directs operational attention to peak triage windows.
Sorting and Crosstabs
Sort categorical headers alphabetically, by a field such as SUM(Sales), manually, or with a nested sort when each pane needs its own order. A one-click descending sort commonly orders the dimension by the measure displayed in the view; inspect the Sort dialog when another field or aggregation is required. Manual order is useful for a fixed business sequence but does not adapt automatically to changing measures.
To build a crosstab, place dimensions on Rows and Columns and put Measure Names and Measure Values where multiple measures are needed. Use text marks for exact values, then add totals or subtotals if the business question requires them. View Data exposes summary data for selected marks and, when permissions allow, underlying data. A crosstab is appropriate for lookup and reconciliation; a chart is often clearer for pattern detection.