Answer

1. Download and Install R. Click here to find the file and instructions on downloading R.
2. Download and Install Rserve.You will need to install an Rserve for Tableau to connect to in order to utilize the new script functions. In the R console, enter the following commands:
   install.packages("Rserve")
   library(Rserve)
   Rserve()
3. Connect Tableau to the R Server. Once Rserve is installed, open Tableau Desktop and follow the steps below or watch this video on how to integrate R and Tableau.
   1. Go to the Help menu and select "Manage R Connection".
   2. Enter a server name of "Localhost" (or "127.0.0.1") and a port of "6311".
   3. Click on the “Test Connection” button to make sure everything runs smoothly. You should see a successful message. Click OK to close

1. Create a calculated field like following for the Intercept:                                                                                                                                                                                                      SCRIPT_REAL("a<-.arg1;b<-.arg2;c<-.arg3; reg<- lm(a~b+c); reg$coeff[[1]]", Sum([Profit]),Sum([Quantity]),Sum([Discount])) 
2. Create a calculated field like following for the Slope of first input factor i.e for Quantity in this example                                                                                                                                 SCRIPT_REAL("a<-.arg1;b<-.arg2;c<-.arg3; reg<- lm(a~b+c); reg$coeff[[2]]", Sum([Profit]),Sum([Quantity]),Sum([Discount]))
3. Create a calculated field like following for the Slope of second input factor i.e for Discount in this example                                                                                                                SCRIPT_REAL("a<-.arg1;b<-.arg2;c<-.arg3; reg<- lm(a~b+c); reg$coeff[[3]]", Sum([Profit]),Sum([Quantity]),Sum([Discount]))