Count N

[#1]

Hello All,

I am fairly new to JMP. I would like a question on a data I am working on. For some reason I need to convert the date column to Char/Nomina(as attached). I need to plot the X and Y and at X-axis being my date column while at the Y-axis I have 2 continuous parameters. My question is how to create a script where I can filter the date count if it is more/less than a certain number. For example, in this case the if the date count is less than 6, then I will exclude 20171108. Something like that. I understood that I can also use summary statistics N to do it with graph builder but I wanna do it with jsl.

[#2 · Accepted solution]

Try this with your source data table opened.

Names Default to Here(1);

dt = current data table();

dt << clear select();

dtsum = dt << Summary(Group(:date), N);
//by default the sumary table is linked to the source table

dtsum << select where(:N < 6);

close(dtsum,Nosave); //no longer needed, and the rows are selected in the source

dt << exclude(1);

[#3]

Thanks a lot, gzmorgan0. It works!