Hi, you could probably do this by setting up your own custom date hierarchy, instead of using the built-in date hierarchy. Then you could use some sort of calculated field to determine what's available in the hierarchy depending on certain conditions. I've never done this, I'm just throwing out an idea.
2 of 2 people found this helpful
I think Shawn's approach will work great! One thing that might help this approach is Tableau's ability to create custom dates from an existing date field. You can create the various parts and arrange them in your own hierarchy.
Simply right click the date field, select "Create Custom Date", then tell it to use the date part you want. Repeat for each level of your custom hierarchy and then build the hierarchy. If you need custom logic it may get slightly more complex.
Your idea worked out for me very well. Initially I was not successful. Then I realized that I got to do little more customization like converting the interval field from Continuous to Discrete to suit my need. Thanks for your great suggestion.
While Shawn gave me the idea, you gave me the procedure. Without your screenshot and clear description, I could have not done this. Many thanks for your support.