Why dashboards combine multiple views in Tableau - Formula Trace Breakdown

Sample Data

Sales and profit data by region for a company.

Cell	Value
A1	Region
B1	Sales
C1	Profit
A2	North
B2	10000
C2	3000
A3	South
B3	15000
C3	4000
A4	East
B4	12000
C4	3500
A5	West
B5	13000
C5	3200

Formula Trace

Dashboard = Combine(View1: Sales by Region, View2: Profit by Region, View3: Sales Trend)

Step 1: View1 = Bar chart showing Sales by Region

Step 2: View2 = Line chart showing Profit by Region

Step 3: View3 = Line chart showing Sales Trend over time (not in sample data)

Step 4: Dashboard = Combine(View1 + View2 + View3)

Cell Reference Map

    A       B       C
1 |Region | Sales | Profit |
2 | North | 10000 |  3000  |
3 | South | 15000 |  4000  |
4 | East  | 12000 |  3500  |
5 | West  | 13000 |  3200  |

Views use columns B and C for sales and profit by region.

The dashboard views pull data from Sales (B) and Profit (C) columns by Region (A).

Result

Dashboard Layout:
+----------------+----------------+----------------+
| Sales by Region| Profit by Region| Sales Trend    |
| (Bar Chart)    | (Line Chart)   | (Line Chart)   |
+----------------+----------------+----------------+
| North: 10000   | North: 3000    | Jan: 8000      |
| South: 15000   | South: 4000    | Feb: 9000      |
| East: 12000    | East: 3500     | Mar: 11000     |
| West: 13000    | West: 3200     | Apr: 12000     |
+----------------+----------------+----------------+

The dashboard shows three views side by side, allowing users to compare sales, profit, and sales trends easily.

Sheet Trace Quiz - 3 Questions

Why does the dashboard combine multiple views?

A To make the dashboard look colorful

B To show different data perspectives together for better insight

C To reduce the amount of data shown

D To confuse the user with many charts

Key Result

Dashboards combine multiple views to present different data perspectives together for comprehensive insight.