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?
Solved! Go to Solution.
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:
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!
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.
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:
On the other hand, the Image Tool can't handle this output from the Association tool, it can only interpret Binary Data.
Thank you @martinding for amazing support.