KNOWLEDGE BASE

Unable to Drill Up Date Hierarchy


Published: 30 Apr 2013
Last Modified Date: 21 Apr 2017

Issue

After drilling down on a date hierarchy in a view on a dashboard, it might not be possible to drill back up from the axis.

Environment

  • Tableau Desktop
  • Continuous date field

Resolution

Option 1

Upgrade to Tableau Desktop 10.1. For more information about upgrading Tableau Desktop, see this article in the Online Help. For more information about drilling up on a continuous field, see the animated example in What's new in Tableau 10.1.

Please note that drilling up is not available from the pill in the Rows/Columns but from the axis itself.
User-added image
 

Option 2 

For older versions, replace the continuous date field with a discrete date field:
  • Right-click the date field again and select a date from the first set of options:
User-added image
Note: Selecting Discrete or Continuous options on this menu will only affect how the date is displayed, not the type of date that it is.

Cause

Before Tableau Desktop 10.1, it was not possible to drill up on continuous date fields. 

Additional Information

For Tableau Server, you can test the feature by joining the Tableau 10.3 Beta; more information can be found at Tableau Pre-Release Programs.
Did this article resolve the issue?