

On the Rows shelf, right-click YEAR(Quarter Date) again and select Discrete. On the Rows shelf, right-click YEAR(Quarter Date) and select Exact Date. This is because Tableau rolls date data up to the highest level of detail. The visualisation updates with year values. Just like your other fields, you can use it in one or more visualisations.įrom the Data pane, under Dimensions, drag Quarter Date to the Rows shelf and place it to the right of MONTH(Order Date). The new date calculated field appears under Dimensions in the Data pane. In the calculation editor that opens, do the following: Select Analysis > Create Calculated Field. On the Rows shelf, click the plus icon ( +) on the QUARTER(Order Date) field to drill down to MONTH(Order Date). QUARTER(Order Date) is added to the Rows shelf and the view updates.

On the Rows shelf, click the plus icon ( +) on the YEAR(Order Date) field. In Tableau Desktop, connect to the Sample-Superstore saved data source, which comes with Tableau.įrom the Data pane, under Dimensions, drag Order Date to the Rows shelf. Create a date calculationįollow the steps below to learn how to create a date calculation. It also demonstrates how to create a date calculation using an example. This article introduces date functions and their uses in Tableau.
