Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Date Prediction using Alteryx

susukavi
7 - Meteor

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.

1 REPLY 1
AngelosPachis
16 - Nebula

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%20Ser...

 

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

 

Cheers,

 

Angelos

 

Labels
Top Solution Authors