Transfer/Export Statistical Plots from Alteryx to Tableau

[qais1975]

Dear All,

I am running an Alteryx workflow in which I did a regression model and would like to export the basic diagnostic plots from Alteryx to Tableau as I am building a dashboard in Tableau. 

Is there a way to export such information from Alteryx to Tableau?

[martinding]

Hi @qais1975,

You can export the plots as "images" by attaching a Render Tool to the Report Anchor of the Regression Tool.

But you can't easily export the data used to create these reports. There are a couple of approaches you could take:

1. You could right click on the Regression Tool and select Open Macro to check out the R code and workflow that creates these reports, but they are not easy to navigate. 

2. Some of the diagnostic plots can be quite easily calculated by hand:

1. Residual vs. Fitted is just Residual (Actual - Predicted) plotted against your Predicted Values. You can get the Predicted Values by using the Score Tool to make predictions on your training set, and get residuals by subtracting the Predictions from your Actual values.
2. QQ plot: https://www.statology.org/q-q-plot-excel/

In the case where you need the coefficients, there's actually a Model Coefficient macro: https://help.alteryx.com/20223/designer/model-coefficients-tool

Hope that helps!

[qais1975]

Thank you @martinding.

I tried this with the Regression record ancher and got the detailed. However, I tried to use it with the Association Analysis to get the correlation matrix with scatter plota but did not work. May I ask you to help in how to get such plot from such tool such as assocoation analysis or the field summary analysis tools? 

Also, I saw there is an image tool with Alteryx but I did not see how to use it with the Render tool. Have you use it before?

Thank you so much for this help.  

[martinding · Accepted solution]

Hi @qais1975,

If you are talking about the interactive part (I anchor) then you might want to take the following approach, the end result will be an HTML file:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Export-the-Interactive-View-...

On the other hand, the Image Tool can't handle this output from the Association tool, it can only interpret Binary Data.

[qais1975]

Thank you @martinding for amazing support.