2 of 2 people found this helpful
This is the default, drilling down Month, results in Day of the date field. One possibility for adding Week would be to create a string parameter that names each date part. Then, create a calculated field to replace Week/Month.
case [Date Parameter]
when 'Month' then datename('month', [Month])
when 'Week' then datename('week', [Month])
Thank you for your answers. I have just created Year, Month and week hierarchy as you showed in the picture however Tableau 8.0 does not allow me to do the Quarters. I use Quarter () function but it does not recognize it. How did you do the quarter part?
Another question i have is that, for my original DATE, i defined fiscal year starts from April; however the Created Fields start from January. Do you know what is causing this?
It works perfectly. Thanks a lot Ville.
What version of Tableau are you using?
I am using Tableau 8.0
Do you have any solution for this problem?
Thanks in advance.
I have had some joy creating custom FY calculations using this syntax:
IF DATEPART('month',[Reporting Period]) <7 THEN [Reporting Period]
ELSE DATEADD('month',6,[Reporting Period])
Then use that with a string conversion
"FY " + str(datepart('year',[Reporting Period FinYear]))
I'm hoping tableau will make the Date Heirarchy a bit more flexible in future releases so that custom date trickery is no longer required.
I have to go to all of this effort just to avoid Quarter being in my drilldown/up.