Dashboard Mode - Continuous vs discrete dates
Business Question
How do sales trends change over time when using continuous versus discrete dates in Tableau?
0
0
Continuous vs discrete dates in Tableau - Dashboard Approaches Compared
Sample Data
| Date | Region | Sales |
|---|---|---|
| 2024-01-01 | North | 100 |
| 2024-01-02 | North | 150 |
| 2024-01-03 | South | 200 |
| 2024-01-04 | South | 250 |
| 2024-01-05 | East | 300 |
| 2024-01-06 | East | 350 |
| 2024-01-07 | West | 400 |
| 2024-01-08 | West | 450 |
Dashboard Components
- KPI Card: Total Sales = SUM([Sales]) = 2200
- Line Chart (Continuous Dates): Shows sales trend over time with a smooth timeline axis using continuous dates (Date as a green pill). This axis treats dates as a continuous timeline, showing gaps if any dates are missing.
- Bar Chart (Discrete Dates): Shows sales by each date as separate bars using discrete dates (Date as a blue pill). Each date is a separate category on the axis.
- Table: Lists Date, Region, and Sales for detailed view.
Dashboard Layout
+----------------------+-----------------------+
| Total Sales | Line Chart (Continuous) |
| (KPI Card) | |
+----------------------+-----------------------+
| Bar Chart (Discrete Dates) |
| |
+----------------------------------------------+
| Data Table |
+----------------------------------------------+
Interactivity
A date filter allows selecting a date range. Both charts and the table update to show only data within the selected dates.
Selecting a region from a region filter updates all components to show sales only for that region.
Hovering over points or bars highlights the corresponding date and sales value.
The continuous date line chart smoothly shows trends over time, while the discrete date bar chart shows exact sales per date.
Self Check
If you add a filter to show only the dates from 2024-01-03 to 2024-01-06, which components update and what changes do you see?
- All components update: KPI card total sales changes to 1100 (200+250+300+350).
- Line chart shows a continuous timeline only for these dates.
- Bar chart shows bars only for these four dates.
- Data table lists only rows with dates 2024-01-03 to 2024-01-06.
Key Result
Dashboard comparing sales trends using continuous and discrete dates in Tableau with interactive filters.