Hello,
I want to generate data something like below
Inventory Id Month Inventory Category Quantity Sold
12345 Jan-18 Household 500
32145 Jan-18 Stationary 600
65789 Jan-18 Personal Care 700
Similarly, I want for all months till Dec-2021
Inventory Id : Random No between 1000, 9999
Month - Month - Year
Inventory Category - 3 categories mentioned above
Quantity Sold : Random no between 100 to 1000
I am new to alteryx.
Please help me out.
~Thank You
Rhitik Krishnani
Hello,
Can you help me on the last thing please, it will really kind.
How to apply ETS and ARIMA and compare the 2.
I know the basics but I am anble to configure.
I have to forecast qty needed in 2021 for all 3 categories of ineventory
I am getting this error when I am running the flow
I have solved the problem
Thank you
Please asssist me with the forecasting thing
Here's the basics of how you would forecast using the two models and compare the models starting from @binuacs workflow
Crosstab the data, to get the 3 type into individual columns. Feed the data into the two tools selecting the field you want to forecast. I used Household for both, but in this case it doesn't matter since the 3 types have exactly the same amounts. Union the two O(Object model) outputs and feed them into the L input of the TS compare tool. Feed your data in the R input and run the workflow. The I output gives you an interactive graph of the results.
In this case, the two models can't do much with your input since there's only one year and it's random. There's no trend and no seasonality so the output for both tools is a flat forecast.
When investigating new tools, it's always helpful to look at sample workflows that ship with Alteryx. For the TSCompare tool look in Help->Sample Workflows->Learn one tool at a time->Time Series->ETS ARIMA TSCOMPARE TSForecast. This workflow uses a multi-year data set that has both trends and seasonality so the output show the forecast differences between the two models
Dan
Dan
My sincere thank to you
You have helped me lot to get what I wanted to achieve.
Just one thing more to add on in the use case.
I also have to add the manufacturing date which should be before the inventory date.
Expiry date which can be random dates after manufacturing in MY Format.
I have to subtract and get the months of expiry as well.
Then I have to forecast it.
I hope you have understood.
You can also give your inputs to make the use-case as best as possible.
I will be really grateful.
~Rhitik Krishnani
I am attaching the flow which I modified.
Please update in this flow which includes Manufacturing date, expiry date to get the expiry months
The forecast the Units Sold and modify the use case to make it more relevant.
My sincere Thanks @danilang