Forum Discussion
Auto date/time vs manually created hierarchies
- 5 months ago
NiklasBergh Well, if by selectively you mean that you could not use the auto date/time date hierarchies in some instances, yes. You would just create your own year, quarter and day columns and use those versus the date column and it's hierarchy. I am not aware of a way to make a manual hierarchy behave like what you are describing with the auto date/time intelligence hierarchy in regards to the continuous axis.
Hi GeraldGEmerick, you are correct; I simplified away Quarter there.
As for the Date 'parent' to the hiearchy, whilst I agree with you that it seems to be primarily aimed as a selection helper (and also keeps my field list cleaner) in my testing it seems like it is not only that.
Let me elaborate.
See this screenshot when using auto date/time:
Looks as intended and so on, as you can see I use two of the parts of the date in the line chart to present year/month date and the widget perfectly fines allows me to selecte between Continuous or Categorical; all good.
If I however manually create the hierachy on the side of the date without auto date/time's involvement, and defines the table as a calendar table (with Date as the field) the widget does not _understand_ that the hierachy data is to be considered Continuous; whenever using my hiearchy I cannot select Continous (the entire dropdown disappears), but if I use the date field underlying the hiearchy instead then I can use Continuous.
I (so far, absent better explanations) attribute this difference in behavior to the fact that when the date is 'above' the hiearchy then the widget likely _understands_ that the hieachy data is actually possible to consider Continuous, even though I use only the underlying hiearchy fields with it.
And hence the specific question.. whether I can selectively use auto date/time where I choose to rather than for everything in the file, or if I can alternately get the auto date/time-equivalent tree structure.
NiklasBergh Well, if by selectively you mean that you could not use the auto date/time date hierarchies in some instances, yes. You would just create your own year, quarter and day columns and use those versus the date column and it's hierarchy. I am not aware of a way to make a manual hierarchy behave like what you are describing with the auto date/time intelligence hierarchy in regards to the continuous axis.