Linear Regression forecasting for 12 months for multiple groups

[SecretChimpanzee]

Hi,

I am trying to produce a 12 month forecast using linear regression for multiple groups - see sample of file data below.

I need to forecast "Occupancy" for the next 12 months based on the Ratio value. Hoping someone can help me with this. 

Month	Group	Ratio	Occupancy
1/09/18	A	1.1	0.97
1/10/18	B	0.8	0.85
1/11/18	C	0.9	0.87
1/12/18	D	1.2	0.98
1/1/18	E	0.7
1/2/18	F	1.0
1/3/18	G	1.3

[jdunkerley79 · Accepted solution]

Do you mean just perform a linear regression between Ratio and Occupancy?

If so:

Attached a simple sample doing this.

If you need to forecast ratio first this would take a little more work.

[SecretChimpanzee]

thanks for your reply. I can't open your example as I have an older version of alteryx. I tried your workflow but keep getting an error...

[SecretChimpanzee]

Never mind, turns out I had omitted the ! from one of the filter formulas! Works great, thanks so much