Alteryx Designer Desktop Discussions

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

TS forecasting of Revenue per Customer per Period

labid003
5 - Atom

Hi everyone,

 

I'm looking into having forecasting revenues per customer per period. I have a table constructed of 3 columns as input, the columns are : Customer (string), period(date) , amount (float). After the input block I added a select block to change the period format to be Date and after the select block, I added ETS block with the following configuration options : 

 

alteryx.png

 

and then I added a TS Forecast block with the following options:


alteryx.png

 

I get a non readable output. Please check the screenshot I added.

 

Any help please on this matter would be highly appreciated. I would also be open to any other model or block i can use to get the forecasted data i need.

 

Thank you

2 REPLIES 2
aatalai
14 - Magnetar

Have you got any missing time periods? You can use the TS filler tool to check

aatalai
14 - Magnetar

Also if you want to do it per customer (one model per customer) - look at the TS factory tools https://community.alteryx.com/t5/Interactive-Lessons/Selecting-and-Scaling-Models/ta-p/610381

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels