Select Actors with Multiple Criteria

Makhala

My data has multiple observations from the same Actor.  I want to find Actors that satisfy criteria based on multiple columns - but would satisfy different criteria in different observations of the same Actor.

 

Example:

 

I want to find Actors that satisfy:
Size < 250

AND

For Competition A : Score 1 > 10 AND Score 2 > 10

AND

For Competition B : Score 1 > 10 AND Score 2 > 40

AND

For Competition C : Score 3 > 50

 

So for the above table it should tell me Actor B.

Thanks!

Mark_Bailey

Select Rows > Data Filter. Select each column used in the criterion and add them one at a time to the filter. You can then set the desired level for each of these variables. The Data Filter affects the row states in the current data table.

 

See Help > JMP Documentation Library > Using JMP guide for details and examples.