Hi, all experts here,
Thank you very much for your kind attention.
I am confused on key time column selection. e.g, I want to predict monthly sales amount, then what column in date dimension should I choose to be the key time column? Is it calendar_date (the key of date dimension) column or calendar_month?
Thanks a lot for your kind advices and help and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Key Time is the column that sorts your data in a series and the granularity for the column should be the same as your data. Since in your example you're predicting Monthly Sales, the Key Time should be the calendar_month.
However, the data type for key time is required to be sortable, i.e. long, double or datetime.
|||Hi, Shuvro,
Thanks a lot for your kind advices.
With best regards,
Yours sincerely,
