KNOWLEDGE BASE

How to filter out null date-time type data in continuous axes


Published: 07 Oct 2022
Last Modified Date: 11 Oct 2022

Question

How to filter out null date-time type data in continuous axes.
Before
User-added image 

After
User-added image
 

Environment

  • Tableau Desktop
  • Text Files

Answer

1. Copy and drag the date-time type field into the column shelf.
2. Change the first field to discontinuous [day] type.
3. Change the second field to continuous [exact date time] type.
The axes' range will be changed automatically to drop the null value of each day.
User-added image
Did this article resolve the issue?