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.

Practice

1. In Tableau, what color pill represents a continuous date field on the Columns or Rows shelf?

easy

A. Green pill

B. Blue pill

C. Red pill

D. Yellow pill

Solution

1. Step 1: Understand Tableau date pill colors

   Tableau uses green pills for continuous fields and blue pills for discrete fields.

2. Step 2: Identify continuous date pill color

   Continuous dates appear as green pills to show smooth timelines.

3. Final Answer:

   Green pill -> Option A

4. Quick Check:

   Continuous date = Green pill [OK]

Hint: Continuous dates always show as green pills in Tableau [OK]

Common Mistakes:

• Confusing continuous with discrete pill colors
• Thinking blue pills represent continuous dates
• Assuming color depends on data type, not continuous/discrete

2. Which of the following is the correct way to convert a date field to discrete in Tableau?

easy

A. Right-click the date field and select 'Convert to Continuous'

B. Right-click the date field and select 'Convert to Discrete'

C. Drag the date field to Filters shelf

D. Double-click the date field to create a continuous axis

Solution

1. Step 1: Locate conversion options for date fields

   In Tableau, right-clicking a date field shows options to convert between continuous and discrete.

2. Step 2: Select the correct conversion for discrete

   Choosing 'Convert to Discrete' changes the pill color to blue and treats dates as categories.

3. Final Answer:

   Right-click the date field and select 'Convert to Discrete' -> Option B

4. Quick Check:

   Convert to Discrete = Right-click the date field and select 'Convert to Discrete' [OK]

Hint: Right-click date field to toggle continuous/discrete [OK]

Common Mistakes:

• Selecting 'Convert to Continuous' instead of discrete
• Dragging to Filters shelf does not change continuous/discrete
• Double-clicking creates continuous axis by default

3. Given a line chart with a continuous date on Columns and Sales on Rows, what happens if you change the date to discrete?

medium

A. The chart shows a smooth timeline with connected points.

B. The chart becomes empty because discrete dates are invalid.

C. The chart breaks into separate bars for each date value.

D. The chart shows a scatter plot with random points.

Solution

1. Step 1: Understand continuous date behavior in line charts

   Continuous dates create a smooth timeline with connected points forming a line.

2. Step 2: Understand discrete date behavior in line charts

   Discrete dates treat each date as a separate category, breaking the line into separate bars or marks.

3. Final Answer:

   The chart breaks into separate bars for each date value. -> Option C

4. Quick Check:

   Discrete date = separate categories [OK]

Hint: Discrete dates split timeline into separate categories [OK]

Common Mistakes:

• Expecting a smooth line with discrete dates
• Thinking discrete dates create scatter plots
• Assuming discrete dates cause errors or empty charts

4. You created a line chart with a continuous date but the axis shows unexpected gaps. What is the most likely cause?

medium

A. The date field is actually discrete, not continuous.

B. The date field is formatted as text.

C. The Sales measure is aggregated incorrectly.

D. There are missing dates in the data causing gaps.

Solution

1. Step 1: Check date field type

   Continuous dates create smooth axes; if gaps appear, the field is likely continuous, not discrete.

2. Step 2: Identify cause of gaps

   Missing dates in the data cause breaks in continuous timelines, showing gaps on the axis.

3. Final Answer:

   There are missing dates in the data causing gaps. -> Option D

4. Quick Check:

   Missing dates cause gaps in continuous axis [OK]

Hint: Gaps in continuous axis usually mean missing dates [OK]

Common Mistakes:

• Assuming date field is discrete when it's continuous
• Thinking text formatting causes axis gaps
• Blaming measure aggregation for axis gaps

5. You want to compare sales performance by month as distinct groups and also see the overall sales trend over time. How should you use continuous and discrete dates in your Tableau dashboard?

hard

A. Use discrete month for the bar chart and continuous month for the line chart.

B. Use continuous month for both charts to keep consistency.

C. Use discrete month for both charts to show clear categories.

D. Use continuous month for the bar chart and discrete month for the line chart.

Solution

1. Step 1: Understand visualization goals

   Comparing sales by month as distinct groups fits discrete dates (blue pills) for clear categories.

2. Step 2: Understand trend visualization

   Showing overall sales trend over time fits continuous dates (green pills) for smooth timelines.

3. Step 3: Apply correct date types per chart

   Use discrete month for bar chart to compare groups, continuous month for line chart to show trend.

4. Final Answer:

   Use discrete month for the bar chart and continuous month for the line chart. -> Option A

5. Quick Check:

   Discrete for groups, continuous for trends [OK]

Hint: Discrete = groups, Continuous = trends in Tableau dates [OK]

Common Mistakes:

• Using continuous dates for group comparisons
• Using discrete dates for trend lines
• Applying same date type to all charts regardless of purpose