Predicting the future dates from the past data

[Pravallika20]

Hi all,

I am having the data set of 3 years data in a column. I want to predict the next dates in the same column. can someone please suggest how to do this?

[jacob_kahn]

Hey @Pravallika20 

It might be helpful if you'd please share an example table of what your data input looks like.

Thanks,

Jacob

[Pravallika20]

SUBMIT_DATE	LAST_RESOLVED_DATE	MTTR_MINS	DESCRIPTION
11/5/2016 15:52	11/9/2016 6:44	5220	System: CPU Utilization is 99.03% busy - User: 60.14% System
5/26/2017 16:16	5/31/2017 18:54	7380	System: CPU Utilization is 99.59% busy - User: 99.24% System
9/27/2016 21:08	10/2/2016 3:39	6180	System: CPU Utilization is 99.97% busy - User: 3.10% System
9/29/2016 18:24	10/2/2016 14:46	4080	System: CPU Utilization is 99.80% busy - User: 98.92% System
9/22/2016 19:31	9/25/2016 15:29	4080	System: CPU Utilization is 99.90% busy - User: 98.89% System

[echuong1]

I suggest using your submit and resolved days to calculate the number of days to resolution. From there, you can use the predictive tools (brown) to predict the days to resolution. Once you have that, you can use the datetimeadd() function to calculate the predicted resolved date. 

Your dataset has very little information that can contribute to the prediction. You'll get a strong model if you're able to add additional detail.