KNOWLEDGE BASE

Disabling Drill Down of Date Fields


Published: 26 Sep 2013
Last Modified Date: 23 Nov 2017

Question

How to disable drilling down on date fields.

Environment

  • Tableau Server
  • Tableau Desktop

Answer

The following instructions can be reviewed in the attached workbook.
  1. Select AnalysisCreate calculated field....
  2. In the Formula text box, type the formula similar to the one below, and then click OK.
    DATEPART('year', [<date-field>])
  3. Drag the calculated field into the view, replacing the original date field.

Additional Information

DATEPART returns the date as an integer. For months or days of the week, use DATENAME instead of DATEPART. For example:
DATENAME('month', [<date-field>])
Or:
DATENAME('weekday', [<date-field>])
Did this article resolve the issue?