I am using a relational database. This is interesting, this is pretty standard and pretty much every BI tool I have seen out there supports this functionality. Any idea wether there are any plans for Tableau to support this?
Another option to consider:
Have three worksheets, one with Year, one with Month and one with Day. Have all three on a dashboard, inside a vertical container, and then use Filter Actions with "Exclude" to make the months appear when a year is selected, and the days appear when a month is selected.
Yes. If you then put those three in a horizontal container, and hide all the titles, the worksheets that are blank get hidden until you filter
I'd like to propose another option!
Create a list parameter with each of the views you want to be able to select, then create a calculated field along the following lines:
if [parameter]='year' then Month([DateField])
elseif [parameter]='month' then Day([DateField]) end
If you use this field as your x axis, you should be able to control the chart as per your original requirement.