Subset by formula

[Splerin]

Why it is not possible to subset directly fromt he menu table>Subset> subset by formula

This way you need first to create a new column with the formula in there and the criterias for subsetting and then subset by the created column.

[Jeff_Perkinson]

I'm afraid I don't know what you mean, "Subset by Formula". Can you clarify?

[Splerin]

Hi Jeff_Perkinson

In the menu Tables>Subset  you can do "subset by a column", which is pretty much the same like "split by"

In Minitab you have the posibility to subset by formula, like in SQL, where  column1 > 2 and column3<6 and genre=male and year>2016.

The only ways i know at the moment is to create a column with if then else formula in it or use the "JMP query Builder" for simple use Filters or create a new column under Available Columns" with the specific formula.

you could save 8-10 mouse clicks when there was an option in subset by formula...

hope my point is now cleare...

[XanGregg]

In the Subset dialog, turn on Subset By.

Then right-click on a column name and choose Formula.

That will bring up the formula editor so you can enter a custom expression.

When you OK the subset dialog you will get a subset for each formula result value, usually 0 or 1 if your formula is a false or true expression.

[Splerin]

Perfekt, many thanks for showing this hidden future ;-)...

So this Idea can be closed or maybe do a select option on the mask and not hidden by right mouse click...

[Jeff_Perkinson]

Closing as already offered and explained above.