Script, Query Builder: filter original data by pVals<=0.05?

aliegner1 — Fri, 09 Jun 2023 19:48:26 GMT

So I think I've over scripted this, and now stuck a bit where I can't figure out how to make this generic.

So I've got 3 sequential Query scripts that are getting longer and longer to ultimately subset the original dataset by chartID's with pVal <0.05.

is there a better way? by the time I get to Query#3 (joining), I have to save the Query#2 dt locally rather than run from memory and the script includes the specific list of ChartID's rather than a generic variable.

ow = Oneway(
Y( :MEAN ),
X( :CHAMBER ),
By(:ChartID),
All Pairs( 1 )
//and then all the normal chart formatting and stuff
)

//create the pVal dt

dt1 = Report( ow[1] )["Means Comparisons", "Comparisons for all pairs using Tukey-Kramer HSD","Ordered Differences Report"][Table Box( 1 )] << Make Combined Data Table;

dt1 << set name( "pValue PairWise by Channel Tukey")


query#1 --> dt1 where pVal <=0.05

Query#2 --> count distinct ChartID of query#1

Query#3 --> join dataset w/ Query#2 by ChartID


close all

replot the charts with the smaller subset of data.

Re: Script, Query Builder: filter original data by pVals<=0.05?

Byron_JMP — Wed, 11 Aug 2021 22:27:28 GMT

did you mean to add a different script to your question?

topic Re: Script, Query Builder: filter original data by pVals<=0.05? in Discussions

Script, Query Builder: filter original data by pVals<=0.05?

Re: Script, Query Builder: filter original data by pVals<=0.05?