KNOWLEDGE BASE

Keeping The [Exact Date] Field Discrete


Published: 02 Mar 2021
Last Modified Date: 26 Oct 2022

Question

When you change a discrete Date field to [Exact Date], it will become a Continuous field.
How can I keep the date field discrete when changing the type to [Exact Date]?

User-added image
 

Environment

  • Tableau Desktop

Answer

As a workaround, instead of changing a discrete date field (Year, Day, etc.) to [Exact Date], add a discrete [Exact Date] to the view.

Drag the Date field to [Rows] / [Columns] while right-clicking.
In the pop-up window, choose [Order Date (Discrete)] to add a discrete Date field to the view.
User-added image

 
Did this article resolve the issue?