cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

conditional data filter + invert selection: bug?

When a data filter is configured to be conditional, selections in one filter affect the values which are displayed in other filters:

 

hogi_0-1671606777786.png

 

 

When the user opens the red triangle menu and clicks on clear selection, the filter is reset and the other filters are adjusted accordingly.

 

Surprising

When the user opens the red triangle menu and clicks on invert selection, the selection is just inverted, but none of the other filters is updated.
Is this behavior just on my system?

 

Not just because of this behavior ...
I added a wish to invert data filters - I mean: not invert the selection, but the action of the filter:

instead of including the selected items, the selected items will be excluded.
https://community.jmp.com/t5/JMP-Wish-List/data-filters-new-option-quot-not-quot/idc-p/582424 

I admit, it's not comparable with the switch from black & white TV to color TV - but it will be fun to have this option

 

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

Current Data Table() << Data Filter(
	Location( {751, 160} ),
	Conditional,
	Mode( Select( 0 ), Include( 1 ) ),
	Add Filter(
		columns( :sex, :age, :name ),
		Where( :sex == "F" ),
		Where( :age == 16 ),
		Display( :age, N Items( 6 ) ),
		Display( :name, N Items( 15 ), "List Display", Find( Set Text( "" ) ) )
	)
);

// now go to "age"(red triangle menu) and invert the selection
8 REPLIES 8
jthi
Super User

Re: conditional data filter + invert selection: bug?

Seems like a bug so I would report it to support@jmp.com. Change does happen in the table but won't update the filters latter filters

-Jarmo
hogi
Level XII

Re: conditional data filter + invert selection: bug?

OK, I sent an email.

assigned case number: TS-00031359

@Audrey_Shull 

hogi
Level XII

Re: conditional data filter + invert selection: bug?

A simple workaround for this bug could be:
Change the modeling type to Multiple Response and use "match none".


Unfortunately, Jmp says that Multiple Response columns cannot be conditional.

Couldn't they? I wish they could ...

data filters: more flexible use of the conditional flag 

 

hogi_2-1671627058108.png

 

hogi_1-1671626877094.png

hogi
Level XII

Re: conditional data filter + invert selection: bug?

@Audrey_Shull : Still a bug in V17.1, right?

Re: conditional data filter + invert selection: bug?

Hi @hogi, yes i can confirm this bug is still present in 17.1. It has been sent to Development and is under review. I cannot make a prediction about the timing for a fix. 

Using the Inverse button will correctly invert the selected rows (or the excluded rows, or hidden rows, depending on what Mode you have selected at the top). However that does not update the filter view itself.

hogi
Level XII

Re: conditional data filter + invert selection: bug?

Ok, understood. 

 

Is there a public list of such known but not jet fixed bugs?
More dangerous are those where a data set, JSL code or graph is affected - and where the error is so subtle that it could go unnoticed, like 

Col Cumulative Sum by group increases counter if first row is missing or empty 

Graph Builder: reverse scale - bug? 

Manual axe labels are mixed up when plotting multiple columns 

Update & Concatenate: source script collision 

Re: conditional data filter + invert selection: bug?

@hogi There is no public list I can point you to, but Tech Support (and others) do a great job referring the issues to Development when submitted and items are prioritized based on their severity. 

 

I was able to get an update on the issue here in this thread, about the Data Filter bug - it will be fixed for JMP 18 and very likely in the JMP 17.2 maintenance also. 

hogi
Level XII

Re: conditional data filter + invert selection: bug?

with Jmp 17.2 it was fixed - partially.

 

There is til an issue if there are selection further down the tree.
In the video, the plot should change from LESLIE to all the other girls in the class , but actually after inverting the selection it shows NO entries

first time that NO entries selected (for age) in a Data Filter means: no age selected -> no data points

-> plot entries come back if some entries in age get selected ...