Predicting the future dates from the past data

Question

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?

echuong1 · Answer

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.

Pravallika20 · Answer

SUBMIT_DATELAST_RESOLVED_DATEMTTR_MINSDESCRIPTION11/5/2016 15:5211/9/2016 6:445220System: CPU Utilization is 99.03% busy - User: 60.14% System5/26/2017 16:165/31/2017 18:547380System: CPU Utilization is 99.59% busy - User: 99.24% System9/27/2016 21:0810/2/2016 3:396180System: CPU Utilization is 99.97% busy - User: 3.10% System9/29/2016 18:2410/2/2016 14:464080System: CPU Utilization is 99.80% busy - User: 98.92% System9/22/2016 19:319/25/2016 15:294080System: CPU Utilization is 99.90% busy - User: 98.89% System

jacob_kahn · Answer

Hey @Pravallika20

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

Thanks,

Jacob