Forum Discussion
koorosh
Post Partisan
Post PartisanDate Hierarchy
Hi Experts, Why I can't create date hierarchy in the following date table ? https://drive.google.com/file/d/18Vu30OqxLGZzbcJ9K37ME4yBbvpzGq7t/view?usp=sharing
I understand the confusion now. You would think you would be able to do it like that.
See below video. Also, if you need to reorder the items in the hierarchy, it can be done from the model tab.
I hope this helps.
kooroshPost Partisan
Post PartisanNo, you used Time intelligence Auto date. I want without this option.
ALLUREAN
Solution Sage
Solution SageDownload the file again. I can create hierarchy by selected columns.
- koorosh
Hello and thanks, please check the video and let me know why I can't. Even when mark it as date table.
https://drive.google.com/file/d/1lvRu9fGj6ChFq5tisG95kkMSaNyrb87F/view?usp=sharing
- koorosh
Thanks,
A question, please. The summarization for each column of DimDate table (Year, Month, Quarter, Day) should be "sum" or "Don't summarize"?