I have number of iterations of the below....where each one uses a different X & Y column. In 2 of these iterations the results are totally wrong and JMP selects a subset that is obviously wrong (lots of X < 40 and lots of Y that equal 1)
//select X to get a list of items for this phase that need escalation dt <<Clear Select; dt <<Select Where( :X > 40 & :Y==0 ); dt <lt;Subset(output table name("X subset"));
turns out that this is addressed in question 5.6 of Jumping into Jmp
I am attempting to select some rows, and then create a subset data table. When no rows are selected, all the rows are included in the subset data table. How can I create a subset only if there were rows selected?
Get the number of rows selected using the Get Selected Rows command, and then verify the result is greater than 0 before creating the subset as shown in the following code:
I take a different approach. Instead of creating a subset each time I want to plot a different search, I simply exclude data that didn't meet the search criteria. Next I create a plot from the original dataset