Key time column for time series algorithm

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,