Hello All,
I am new to the Alteryx Community and hope to get some useful tips from you ;)
What I am trying to do is analyse consumption data of different articles accros time
I would like to calculate in alteryx y = ax + b for each article and use it as data for further analysis
Input:
Week | Article | Quantity |
1 | Article 1 | 5 |
2 | Article 1 | 8 |
3 | Article 1 | 11 |
4 | Article 1 | 14 |
5 | Article 1 | 17 |
6 | Article 1 | 20 |
7 | Article 1 | 23 |
8 | Article 1 | 26 |
9 | Article 1 | 29 |
10 | Article 1 | 32 |
11 | Article 1 | 35 |
12 | Article 1 | 38 |
13 | Article 1 | 41 |
14 | Article 1 | 44 |
15 | Article 1 | 47 |
16 | Article 1 | 50 |
17 | Article 1 | 53 |
18 | Article 1 | 56 |
19 | Article 1 | 59 |
20 | Article 1 | 62 |
21 | Article 1 | 65 |
22 | Article 1 | 68 |
23 | Article 1 | 71 |
24 | Article 1 | 74 |
25 | Article 1 | 77 |
26 | Article 1 | 80 |
27 | Article 1 | 83 |
28 | Article 1 | 86 |
29 | Article 1 | 89 |
30 | Article 1 | 92 |
31 | Article 1 | 95 |
32 | Article 1 | 98 |
33 | Article 1 | 101 |
34 | Article 1 | 104 |
35 | Article 1 | 107 |
36 | Article 1 | 110 |
37 | Article 1 | 113 |
38 | Article 1 | 116 |
39 | Article 1 | 119 |
40 | Article 1 | 122 |
41 | Article 1 | 125 |
42 | Article 1 | 128 |
43 | Article 1 | 131 |
44 | Article 1 | 134 |
45 | Article 1 | 137 |
46 | Article 1 | 140 |
47 | Article 1 | 143 |
48 | Article 1 | 146 |
49 | Article 1 | 149 |
50 | Article 1 | 152 |
51 | Article 1 | 155 |
52 | Article 1 | 158 |
1 | Article 2 | 158 |
2 | Article 2 | 155 |
3 | Article 2 | 152 |
4 | Article 2 | 149 |
5 | Article 2 | 146 |
6 | Article 2 | 143 |
7 | Article 2 | 140 |
8 | Article 2 | 137 |
9 | Article 2 | 134 |
10 | Article 2 | 131 |
11 | Article 2 | 128 |
12 | Article 2 | 125 |
13 | Article 2 | 122 |
14 | Article 2 | 119 |
15 | Article 2 | 116 |
16 | Article 2 | 113 |
17 | Article 2 | 110 |
18 | Article 2 | 107 |
19 | Article 2 | 104 |
20 | Article 2 | 101 |
21 | Article 2 | 98 |
22 | Article 2 | 95 |
23 | Article 2 | 92 |
24 | Article 2 | 89 |
25 | Article 2 | 86 |
26 | Article 2 | 83 |
27 | Article 2 | 80 |
28 | Article 2 | 77 |
29 | Article 2 | 74 |
30 | Article 2 | 71 |
31 | Article 2 | 68 |
32 | Article 2 | 65 |
33 | Article 2 | 62 |
34 | Article 2 | 59 |
35 | Article 2 | 56 |
36 | Article 2 | 53 |
37 | Article 2 | 50 |
38 | Article 2 | 47 |
39 | Article 2 | 44 |
40 | Article 2 | 41 |
41 | Article 2 | 38 |
42 | Article 2 | 35 |
43 | Article 2 | 32 |
44 | Article 2 | 29 |
45 | Article 2 | 26 |
46 | Article 2 | 23 |
47 | Article 2 | 20 |
48 | Article 2 | 17 |
49 | Article 2 | 14 |
50 | Article 2 | 11 |
51 | Article 2 | 8 |
52 | Article 2 | 5 |
Target Output:
Article | a | b | r² |
Article 1 | 3 | 2 | 1 |
Article 2 | 3 | 161 | 1 |
Do you know if there is a quick way to do this without having to go through lengthy calculations?
Thanks!
Solved! Go to Solution.
You could use the predictive tools but think you would need to batch macro it to make it run group by group.
I attach a macro implementing Linear Regression using Summarize Tool and Formula Tool (Slope and Intercept are easy enough, RSq is a bit horrific)
Nice thing is it is blisteringly fast as all native core Alteryx tools
Hey @rcauquil, I see that @jdunkerley79 already provided something similar, but here is a macro with some R script that does these computations. Hope this helps :).
Thank you so much @jdunkerley79
You just saved me a lot of hours! works perfectly
Hey @JoBen - works great!
Hey there,
I'm on Alteryx v11.7 and in need of this worfklow. The one that you attached requires a newer version.
Can you please explain how you went about doing this? Thank you. 🙂