Linear Regression for Multiple Customers

[edwardv]

Hi all, 

I need to run a linear regression for the turn around time when delivering stock to our customers. We have thousands of customers and I don't want to import one customers data at a time. 

Each customer will have its on linear regression equation to determine the turn around time based on my independent variables. 

To simplify the data for the purpose of this question, I have 3 columns. 

1. Customer name

2. Number of units delivered (Independent Variable)

3. Turn around time at customer (Dependent Variable)

How can I use the Linear Regression tool to get a Linear Regression equation for each of my customers? 

Thanks,

[afv2688]

Hello @edwardv ,

To be honest I have never tried this before on a predictive model but have you considered using a batch macro?:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

Regards

[edwardv]

Thanks for the feedback, I will have a look at it and see if it can provide a solution. But I feel there should be a simple way, it is quite easy to do in Excel, but I need to build a scalable model in Alteryx that can handle large amounts of data easily.