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: WeekArticleQuantity1Article 152Article 183Article 1114Article 1145Article 1176Article 1207Article 1238Article 1269Article 12910Article 13211Article 13512Article 13813Article 14114Article 14415Article 14716Article 15017Article 15318Article 15619Article 15920Article 16221Article 16522Article 16823Article 17124Article 17425Article 17726Article 18027Article 18328Article 18629Article 18930Article 19231Article 19532Article 19833Article 110134Article 110435Article 110736Article 111037Article 111338Article 111639Article 111940Article 112241Article 112542Article 112843Article 113144Article 113445Article 113746Article 114047Article 114348Article 114649Article 114950Article 115251Article 115552Article 11581Article 21582Article 21553Article 21524Article 21495Article 21466Article 21437Article 21408Article 21379Article 213410Article 213111Article 212812Article 212513Article 212214Article 211915Article 211616Article 211317Article 211018Article 210719Article 210420Article 210121Article 29822Article 29523Article 29224Article 28925Article 28626Article 28327Article 28028Article 27729Article 27430Article 27131Article 26832Article 26533Article 26234Article 25935Article 25636Article 25337Article 25038Article 24739Article 24440Article 24141Article 23842Article 23543Article 23244Article 22945Article 22646Article 22347Article 22048Article 21749Article 21450Article 21151Article 2852Article 25 Target Output: Articleabr²Article 1321Article 231611 Do you know if there is a quick way to do this without having to go through lengthy calculations? Thanks!

Linear regression

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!

Common Use Cases

Data Investigation

Demographic Analysis

Behavior Analysis

Accepted answers

jdunkerley79

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

LinearRegression.yxzp

JoBen

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 .

Help1.yxzp

All comments

jdunkerley79

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

LinearRegression.yxzp

JoBen

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 .

Help1.yxzp

rcauquil

Thank you so much @jdunkerley79

You just saved me a lot of hours! works perfectly

rcauquil

Hey @JoBen - works great!

vivaisun11

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. 🙂