Linear regression for multiple objects in one column.

[nidah5]

The data has customer level data. and  want to check the linear regression of each customer revenue to their complaints. The linear regression column is where want to calculate regression for each customer. a single model for all

CUSTOMER	REVENUE	COMPLAINTS	LINEAR REGRESSION
ACSC	299286797.978887	51720
ABB	6873611.03112946	1229
AVT	231346386.654158	10892

[joshuaburkhow]

Hi @nidah5 

Do you have a specific question? 

[grazitti_sapna]

Hi @nidah5 

Please find the attached workflow and screenshot for your reference.

[nidah5]

i have used CUSTOMER column and complaint column as predictor variable(indipendent) and REVENUE as target(dependent). is it a correct way to look at it?

and with the results below what exactly can we infer?

[nidah5]

@grazitti_sapna can you please share the screen shot of workflow.

[nidah5]

@grazitti_sapna that's how workflow looks at my end. what about macro?

[grazitti_sapna]

Hi @nidah5 , the tool used is a model comparison tool. Please refer to the screenshot.

I guess you have not installed the predictive tools from alteryx that is why you are not able to see it. I suggest you to download it and then try the workflow.

Thanks.

[nidah5]

which alteryx version are you using?

[grazitti_sapna]

Hi @nidah5 , I am using 2020.3 version but you can download predictive tools for your version as well.

Thanks.

[nidah5]

yes, i have that already

i still can't see the comparitive one

is there any other way?