Hi, So let me explain the problem, i have an input dataset that looks like this
Date | ID |
Sales |
7/10/2015 | 5544 | 1.2 |
8/10/2015 | 5544 | 1.4 |
9/10/2015 | 5544 | 5.4 |
7/10/2015 | 5545 | 5.4 |
8/10/2015 | 5545 | 6.3 |
9/10/2015 | 5545 | 9.2 |
7/10/2015 | 5546 | 8.7 |
8/10/2015 | 5546 | 7.5 |
9/10/2015 | 5546 | 3.4 |
Now , I have created a workflow which uses the filter tool that selects the sales value for ID=5544 and does time series analysis on the sales using ETS and ARIMA and then uses TS Compare to generate a table showing the output of TS Compare which I am exporting to a csv file
I have tried to create a macro to automate this process such that I do not have to manually use the filter tool to select ID=5544 and the macro automatically selects all the ID's and repeats the process for each of them and gives me different outputs but I am not able to get the desired result.
Can someone help me here to get the desired result
Solved! Go to Solution.
I do this sort of thing all the time - it's very useful.
First, you create a batch macro that filters and outputs for each ID. Then you take that batch macro and use it in a module. The module you use it in has a list of your IDs that you feed to that macro.
See attached batch macro and module.
Thank you so much , it really saved me a lot of time!!
You're welcome!