How to Compare Two Date Ranges from the Same Data Set in One View in Tableau Desktop

In this silent video, you’ll learn how to compare two date ranges from the same data set on one graph in Tableau Desktop.

- - - - - - - - - - - - - -

1. Create a calculated field for the first date range. The example below uses the year 2018:
date(IF year([Order Date])=2018
THEN [Order Date]
END)
2. Create a calculated field for the second date range. The example below uses the year 2019:
date(IF year([Order Date])=2019
THEN [Order Date]
END)
3. Place both calculated fields on the Columns shelf, selecting Continuous, Exact Date.
4. Right-click the second date range and select Dual Axis.
5. Drag Sales to Rows.
6. Drag Order Date to Color on the Marks card for All.

- - - - - - - - - - - - - -