Date Prediction using Alteryx

Question

Hi All,

Need your suggestion/help for below criteria.

Tickets are raised on daily basis and some of them are missing the target date(sla).Based on SLA missed tickets,needs to predict/forecast future dates where we can expect sla miss.

KIndly suggest which tools cane be used to achieve this.

Sample data:

Ticket no submit date sla status

123          01/01/2021 missed

234          01/03/2021 notmissed

345          01/11/2021  missed

P.s:Having data for last 3 years.

AngelosPachis · Answer

Hi @susukavi ,

Out of the top of my head, you can work with the time-series tool to create a forecast. Before you use the time series tool, you have to bring your data in the correct format, so you have to decide a date granularity (daily/weekly/monthly) that you want to aggregate your data on.

Assuming you select weekly, you can go on and for a table having a date column and then the number of tickets failed that week and based on those values you probably can create a forecast.

Which model you are going to use depends on whether there is seasonality in your data if I recall correctly and of course which returns you the least error.

If you don't have any prior experience using those tools, then a very good resource to begin with is the interactive lessons

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Time%20Series%20Forecasting

I guess @Pravallika20 question is similar so you are together in this, so I hope it helps both.

Cheers,

Angelos