Bird
Raised Fist0
Tableaubi_tool~8 mins

Why dashboards combine multiple views in Tableau - Dashboard Impact

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Dashboard Mode - Why dashboards combine multiple views
Business Question

How can combining different views in a dashboard help us understand sales performance better?

Sample Data
RegionProductSalesProfitMonth
EastChair10030Jan
WestTable20050Jan
EastDesk15040Feb
WestChair30090Feb
EastTable25070Mar
WestDesk350100Mar
Dashboard Components
  • KPI Card: Total Sales
    Formula: SUM([Sales])
    Result: 1350
  • KPI Card: Total Profit
    Formula: SUM([Profit])
    Result: 380
  • Bar Chart: Sales by Region
    Shows total sales for East and West regions.
    East: 500, West: 850
  • Line Chart: Sales Over Months
    Shows sales trend from Jan to Mar.
    Jan: 300, Feb: 450, Mar: 600
  • Table: Sales and Profit by Product
    Aggregated sales and profit for each product.
    Chair: Sales 400, Profit 120
    Table: Sales 450, Profit 120
    Desk: Sales 500, Profit 140
Dashboard Layout
+----------------+----------------+----------------+
| Total Sales    | Total Profit   | Sales by Region|
| (KPI Card)    | (KPI Card)     | (Bar Chart)    |
+----------------+----------------+----------------+
|                Sales Over Months (Line Chart)               |
+------------------------------------------------------------+
|                Sales and Profit by Product (Table)          |
+------------------------------------------------------------+
Interactivity

A filter for Region lets you select East or West. When you pick a region:

  • KPI cards update to show sales and profit for that region only.
  • Bar chart highlights the selected region.
  • Line chart shows sales trend for the selected region.
  • Table updates to show sales and profit by product only for the selected region.
Self Check

If you add a filter for Month = Feb, which components update and what do they show?

  • KPI Cards: Show sales = 450, profit = 130 (sum of Feb rows)
  • Bar Chart: Sales by Region for Feb: East = 150, West = 300
  • Line Chart: Sales Over Months shows only Feb point (450)
  • Table: Sales and Profit by Product for Feb:
    Desk: Sales 150, Profit 40
    Chair: Sales 300, Profit 90
Key Result
A dashboard combining KPIs, bar chart, line chart, and table to show sales and profit by region, product, and month.

Practice

(1/5)
1. Why do dashboards combine multiple views in Tableau?
easy
A. To reduce the amount of data shown
B. To make the dashboard load slower
C. To provide a complete picture by showing data from different angles
D. To confuse the user with too much information

Solution

  1. Step 1: Understand the purpose of multiple views

    Multiple views allow users to see different aspects of data in one place.

  2. Step 2: Recognize the benefit of combining views

    Combining views gives a fuller, clearer understanding of the data story.

  3. Final Answer:

    To provide a complete picture by showing data from different angles -> Option C

  4. Quick Check:

    Multiple views = complete picture [OK]
Hint: Think: multiple views = full story in one place [OK]
Common Mistakes:
  • Thinking dashboards slow down on purpose
  • Believing more views confuse users
  • Assuming dashboards reduce data shown
2. Which of the following is the correct way to add multiple views to a Tableau dashboard?
easy
A. Drag multiple worksheets onto the dashboard canvas
B. Write SQL queries inside the dashboard
C. Use only one worksheet per dashboard
D. Add views by typing formulas in the dashboard

Solution

  1. Step 1: Identify how Tableau dashboards are built

    Tableau dashboards are created by dragging worksheets (views) onto the canvas.

  2. Step 2: Eliminate incorrect methods

    SQL queries and formulas are not added directly to dashboards; only worksheets are placed.

  3. Final Answer:

    Drag multiple worksheets onto the dashboard canvas -> Option A

  4. Quick Check:

    Drag worksheets = add views [OK]
Hint: Drag worksheets to dashboard, not code or formulas [OK]
Common Mistakes:
  • Trying to write SQL inside dashboards
  • Using only one worksheet per dashboard
  • Typing formulas directly on dashboard
3. Consider a dashboard with a sales map and a sales table. If you click a region on the map, what happens to the table if the views are linked by an action?
medium
A. The table filters to show sales only for the selected region
B. The table shows sales for all regions regardless of selection
C. The map zooms out automatically
D. The dashboard refreshes and clears all selections

Solution

  1. Step 1: Understand dashboard actions linking views

    Actions connect views so selecting data in one filters or highlights related data in another.

  2. Step 2: Apply this to the map and table example

    Clicking a region on the map filters the table to show only that region's sales.

  3. Final Answer:

    The table filters to show sales only for the selected region -> Option A

  4. Quick Check:

    Linked views filter related data [OK]
Hint: Click map region filters table if linked [OK]
Common Mistakes:
  • Thinking table ignores map selection
  • Assuming map zooms out automatically
  • Believing dashboard clears selections on click
4. You created a dashboard with multiple views but clicking on one view does not filter the others. What is the most likely reason?
medium
A. The views are on different dashboards
B. The data source is missing
C. Tableau does not support interactive filtering
D. Dashboard actions linking the views are not set up

Solution

  1. Step 1: Check interactive filtering setup

    Interactive filtering between views requires dashboard actions to be configured.

  2. Step 2: Identify missing setup

    If clicking does not filter others, likely the dashboard actions are not created or enabled.

  3. Final Answer:

    Dashboard actions linking the views are not set up -> Option D

  4. Quick Check:

    Missing actions = no filtering [OK]
Hint: Set dashboard actions to link views [OK]
Common Mistakes:
  • Assuming data source is missing
  • Thinking views on different dashboards still filter each other
  • Believing Tableau lacks interactive filtering
5. You want to create a dashboard that shows sales by region, product category, and time. How does combining multiple views help users understand the data better?
hard
A. It hides details so users only see total sales
B. It lets users explore sales trends by time, compare categories, and see regional differences all in one place
C. It forces users to look at one view at a time
D. It slows down the dashboard and confuses users

Solution

  1. Step 1: Identify the benefit of multiple views for complex data

    Showing sales by region, category, and time separately helps users see patterns and relationships clearly.

  2. Step 2: Explain how combined views improve understanding

    Users can explore data from different angles without switching dashboards, gaining deeper insights.

  3. Final Answer:

    It lets users explore sales trends by time, compare categories, and see regional differences all in one place -> Option B

  4. Quick Check:

    Multiple views = better exploration [OK]
Hint: Multiple views show different data angles together [OK]
Common Mistakes:
  • Thinking multiple views hide details
  • Believing users must view one chart at a time
  • Assuming multiple views confuse users