Forum Discussion
Auto date/time vs manually created hierarchies
- 6 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.
- GeraldGEmerick6 months ago
Memorable Member
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.
- Anonymous5 months agoNot applicable
Hi NiklasBergh ,
Thank you GeraldGEmerick for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.- Anonymous5 months agoNot applicable
Hi NiklasBergh ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.