Continuous vs discrete dates in Tableau - Business Scenario Comparison

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to understand monthly sales trends and compare sales by specific months over multiple years. They ask you to create two views: one using continuous dates to see smooth sales trends over time, and one using discrete dates to compare sales month by month distinctly.

📊 Data: You have sales data with columns: Order Date (date), Sales Amount (number), and Region (text). The data covers sales from January 2022 to December 2023.

🎯 Deliverable: Create two Tableau worksheets: one with continuous month dates showing a line chart of sales trends, and one with discrete month dates showing a bar chart comparing sales by month and year.

Sample Data

Order Date	Sales Amount	Region
2022-01-15	500	North
2022-02-10	700	South
2022-03-05	600	East
2022-04-20	800	West
2022-05-18	750	North
2023-01-12	650	South
2023-02-25	720	East
2023-03-15	680	West
2023-04-10	900	North
2023-05-22	850	South

1

Step 1: Connect your sales data to Tableau and open a new worksheet.

No formula needed.

Expected Result

Data is loaded and ready for analysis.

2

Step 2: Create a line chart using continuous dates to show sales trends over time.

Drag 'Order Date' to Columns shelf, right-click it, select 'Month' and choose 'Continuous' (green pill). Drag 'Sales Amount' to Rows shelf and set aggregation to SUM.

Expected Result

A smooth line chart showing total sales for each month from Jan 2022 to May 2023.

3

Step 3: Create a bar chart using discrete dates to compare sales by month and year distinctly.

Drag 'Order Date' to Columns shelf, right-click it, select 'Month' and choose 'Discrete' (blue pill). Drag 'Sales Amount' to Rows shelf with SUM aggregation. Drag 'Order Date' again to Color on Marks card and set it to 'Year' discrete to color bars by year.

Expected Result

A bar chart with separate bars for each month and year, clearly showing sales comparison.

4

Step 4: Add titles and labels to both charts for clarity.

Use 'Show Title' option and add axis labels: 'Month' for X-axis and 'Total Sales' for Y-axis.

Expected Result

Both charts have clear titles and axis labels for easy understanding.

5

Step 5: Create a dashboard to display both charts side by side for comparison.

Open a new dashboard, drag both worksheets onto it, arrange horizontally, and add a dashboard title 'Continuous vs Discrete Dates Sales Analysis'.

Expected Result

Dashboard shows both charts side by side for easy comparison.

Final Result

Dashboard: Continuous vs Discrete Dates Sales Analysis

+-----------------------------+  +-----------------------------+
| Continuous Dates Line Chart |  | Discrete Dates Bar Chart     |
|                             |  |                             |
|  Sales                      |  |  Sales                      |
|  900 +                      |  |  900 +  ■  ■                |
|      |                      |  |      |  ■  ■                |
|  700 +      /\              |  |  700 +  ■  ■  ■             |
|      |     /  \             |  |      |  ■  ■  ■             |
|  500 +----/----\----        |  |  500 +  ■  ■  ■  ■          |
|      |                      |  |      |  ■  ■  ■  ■          |
|      +---------------------+  |      +---------------------+
|       Jan Feb Mar Apr May    |  |       Jan Feb Mar Apr May    |
+-----------------------------+  +-----------------------------+

✓Continuous dates line chart shows smooth sales trends over time, useful for spotting overall patterns.

✓Discrete dates bar chart clearly separates sales by month and year, making it easy to compare specific months across years.

✓Sales generally increased from 2022 to 2023, with peaks in April and May 2023.

Bonus Challenge

Create a calculated field to show year-over-year sales growth by month using discrete dates.

Show Hint

Use Tableau's LOOKUP() function to compare sales of the same month in the previous year.