Continuous vs discrete dates in Tableau - Formula Comparison Trace

Sample Data

Daily sales data for five consecutive days in January 2024.

Cell	Value
A1	Date
B1	Sales
A2	2024-01-01
B2	100
A3	2024-01-02
B3	150
A4	2024-01-03
B4	120
A5	2024-01-04
B5	130
A6	2024-01-05
B6	170

Formula Trace

SUM([Sales]) by Continuous Date vs Discrete Date

Step 1: SUM([Sales]) for each date treating Date as continuous

Step 2: SUM([Sales]) for each date treating Date as discrete

Step 3: Visual difference: Continuous date axis vs Discrete date axis

Cell Reference Map

    A       B
1 | Date  | Sales |
2 | 1/1   | 100   |
3 | 1/2   | 150   |
4 | 1/3   | 120   |
5 | 1/4   | 130   |
6 | 1/5   | 170   |

Arrows: Date column feeds into the date axis (continuous or discrete), Sales column feeds into SUM aggregation.

Date and Sales columns are used. Date is the axis field, Sales is the measure summed.

Result

Continuous Date (Line Chart):
Date -> 1/1 --- 1/2 --- 1/3 --- 1/4 --- 1/5
Sales-> 100 --- 150 --- 120 --- 130 --- 170

Discrete Date (Bar Chart):
| 100 | 150 | 120 | 130 | 170 |
 1/1   1/2   1/3   1/4   1/5

Continuous dates show a smooth line connecting sales over time. Discrete dates show separate bars for each date.

Sheet Trace Quiz - 3 Questions

What does Tableau do when you use a continuous date on the axis?

A Shows dates as a smooth timeline with connected points

B Shows dates as separate categories with gaps

C Ignores the date and sums all sales

D Sorts dates alphabetically

Key Result

Continuous dates create a timeline axis; discrete dates create categorical groups.