330319_en-US

liliconcom

Interactively and simultaneously selecting model terms and plotting figures in Dashboard

I have been trying to figure out a way with Dashboard to have a data filter in which, not only can I interactively change what is plotted, but also interactively select terms in the statistical model that parallels the data in the GraphBuilder plot. This quickly becomes messy if you have a lot of interaction effects, but I feel like it should be possible. In the attached table, I somewhat got it to work (see Dashboard scripts.) for standard least squares and stepwise regression (not for mixed model or gen-reg). I don't supposed there is a way to actually select model terms in the MODEL OUTPUT (not the data filter) to change the GraphBuilder plots? I am almost certain this is not possible, especially since both Fit Y by X and Fit Model create their own plots (which I don't like as much as the GB ones, else I'd use those!). You CAN select groupings of samples in the model output to highlight points in the GraphBuilder plot, which is useful but not exactly what I want. For instance, say I identify in stepwise regression that "temperature x transplant" is the best predictor; I could then highlight those terms in the model output, and the GraphBuilder plot would update. Were I to highlight temperature x transplant in the data filter, the stepwise regression model would then crash (though the GB plot would potentially update appropriately). Is there a way to interactively link the statistical output and the GB plot to where the statistical tests described by the model are reflected in the plot?

AnalyticsGraphicsRe: Interactively and simultaneously selecting model terms and plotting figures in Dashboard

Hi Anderson,

I think I understand what you are trying to do and it makes sense from a point of view of helping someone to interpret the model output. However, I think that will be very difficult without a lot of scripting.

I think that the solution would involve extracting the effect importance statistics (e.g. logworth) from the model report to a data table - that bit is not too difficult to script. Then plotting that as a graph builder plot - again, not too difficult.

Then that data table would somehow need to link to the original data table so that selections from the effect importance statistic plot could be used to filter plots of the original data. This is the bit that I am not sure about.

By the way, I couldn't find the Dashboard scripts on your attached table.

Regards, Phil.

Re: Interactively and simultaneously selecting model terms and plotting figures in Dashboard

I have added a Model Dashboard script to the attached version of the data table.

 

 

I think that what you would like is to be able to select a model effect in the Effect Summary in the model report on the right and then have the graph builder plot on the left update to only show the plot for the response vs that effect. E.g. click on "treatment" and the plot on the left will update to only show the plot of "treatment" vs "response variable ..."

 

Is that right?

 

Regards,

Phil

Re: Interactively and simultaneously selecting model terms and plotting figures in Dashboard

Phil, what you describe is indeed what I want to do! I checked out the file you provided, though, and the Dashboard script is simply the Graph Builder one. Would it be possible for you to attach the script that shows the Dashboard corresponding to the one you've posted on this page. 

 

So, to confirm, in this example, if you click on "treatment" in the "Effect summary" the bottom two plots in Graphbuilder would disappear, right? That is my goal.

 

Out of curiosity, how do you get the model output window and GB to talk to one another (i.e., to be virtually linked)? Thanks so much for your help. I had literally given this post a <5% chance of being solvable!

Re: Interactively and simultaneously selecting model terms and plotting figures in Dashboard

You can do this by using a 'set row change function()'. See the third script in the attached for details. Also, 'Help > Scripting Guide' and 'Help Scripting Index'. Of course interaction effects are not shown.