Dashboard Mode - Why time analysis reveals trends
Business Question
How do sales change over time and what trends can we see?
0
0
Why time analysis reveals trends in Tableau - Dashboard Impact
Sample Data
| Month | Sales | Region |
|---|---|---|
| 2024-01 | 100 | North |
| 2024-02 | 150 | North |
| 2024-03 | 130 | North |
| 2024-01 | 80 | South |
| 2024-02 | 90 | South |
| 2024-03 | 120 | South |
| 2024-01 | 200 | East |
| 2024-02 | 220 | East |
Dashboard Components
- KPI Card: Total Sales
Formula: SUM([Sales])
Result: 1090 - Line Chart: Sales Over Time
X-axis: Month
Y-axis: SUM(Sales)
Color: Region
Shows sales trend by region over months January to March 2024 - Bar Chart: Sales by Region
X-axis: Region
Y-axis: SUM(Sales)
Shows total sales per region for the period - Table: Monthly Sales Details
Columns: Month, Region, Sales
Shows raw sales data for detailed view
Dashboard Layout
+----------------------+----------------------+ | KPI Card | Sales Over Time | | (Total Sales) | (Line Chart) | +----------------------+----------------------+ | Sales by Region | Monthly Sales Table | | (Bar Chart) | (Data Table) | +----------------------+----------------------+
Interactivity
A filter for Region lets you select one or more regions. When you pick a region, the KPI card, line chart, bar chart, and data table update to show only sales for that region. This helps you focus on trends and totals for specific areas.
Self Check
If you add a filter to show only the North region, which components update and what changes do you see?
- All components update: KPI card shows total sales for North (380).
- Line chart shows sales trend for North only.
- Bar chart shows sales only for North.
- Data table lists only North region sales rows.
Key Result
Dashboard shows total sales and sales trends over time by region to reveal patterns.