The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Finding trends and predicting sales figures
Learner III
Hello everyone! 
I couldn't find solution for my problem, so i decided to register here and ask you 
I have a table with sales and time, like this:
I triend linear regression, after setting date as ID and sales as label, I have no other attributes... How can I handle this?
How can I predict sales in next months? Of course this dataset is very simple, just to understand the tool, later I would like to apply this to non-linear issues.
Thanks for your help!
I couldn't find solution for my problem, so i decided to register here and ask you I have a table with sales and time, like this:
| date | sales |
| 2011/01 | 500 |
| 2011/02 | 600 |
| 2011/03 | 700 |
| 2011/04 | 800 |
| 2011/05 | 900 |
How can I predict sales in next months? Of course this dataset is very simple, just to understand the tool, later I would like to apply this to non-linear issues.
Thanks for your help!
0
Answers
It may be possible that the underlying Java will have problems with dates as regular attribute. In that case, use the Set Role operator to create an id (a running idx), set the role of id to regular and in this case the date column back to id.
Then you can use the linear regression to get the job done.
Best regards,
Marius