data filters, new option: "not"

[hogi]

☑ cool new feature
☐ could help many users!

☐ removes a „bug“

☐ nice to have

☐ nobody needs it

#myTop10_2022

If a column is set to "multiple response", there are cool options available in the data filter menu:

These allow the user to get much more power out of the data filter. Most of them rely on the fact that there are "multiple responses" in the column - and the user can select which combination he wants.

There is also an option "none". It has the same effect as the "inverse" - but the difference is that "inverse" just inverts the current selection, but "none" is a setting which is applied in the background.

With "none" fancy Data filters are possible along the idea: THIS, but not THAT:

https://community.jmp.com/t5/Discussions/Conditional-Data-Filter-for-modeling-type-Multiple-Response...

Unfortunately, for standard columns, there is no "none":

https://community.jmp.com/t5/Discussions/advanced-data-filter-arithmetic-just-available-if-the-colum...

Every Jmp user who worked with the cool functionalities of multiple response columns (esp. the availability of "not") feels an incredible lack of functionality when working with standard columns.

my wish:

Add "not" also for standard data filters.

more wishes submitted by  

[Sarah-Sylvestre]

Hi @hogi, thank you for your suggestion! We have captured your request and will take it under consideration.

[hogi]

this is one of the very low-hanging fruits

A similar functionality exists already for columns with modeling type multiple response.

On the other hand, it would enable a full-spectrum of Data filters 

instead of just having black & white:

[hogi]

Another application for "not".
A data filter to remove specific entries for a dynamically growing data set.

e.g.: remove "label=missing" from the plot

option A: not(label=missing) --> will be correct @ t=0 and for the rest of your life.

option B: select "label = missing", then invert the selection and save the filter @ t=0,
--> this selection is OK @ t=0, but just as long as no data is added.
All new rows will be excluded from the plot (because the labels were not included @ t=0)

[hogi]

Another great benefit of the new "not" option for data filters:

Sometimes the user wants to exclude some data points, e.g. don't show Chris and David.
Without the possibility of "not" the footer of the plot is quite long, but doesn't show this information:


With the new feature this issue will be fixed

[hogi]

At the moment, entries which are not in the data table can not be (persistently?)  listed in the data filter (they are automatically removed):
https://community.jmp.com/t5/Discussions/Data-filter-how-to-specify-the-limits/m-p/643630

NB: The new option "not" will be most useful if the list of excluded items can be defined independent of the content of the current data table.

i.e. specify entries which should be automatically removed from the plot - even if they are not listed in the current version of the data table.

[julian]

Hi @hogi,

Is "Inverse" what you're looking for? That is a negation for the selection, so selecting Chris and David becomes "Not Chris nor David." 

As for providing a list of excluded items that can be defined independent of the table, you can do that in the jsl for the where clause and the local data filter will simply ignore the levels it can't find:

Graph Builder(
	Size( 422, 424 ),
	Show Control Panel( 0 ),
	Variables( X( :height ), Y( :weight ) ),
	Elements( Points( X, Y, Legend( 14 ) ), Smoother( X, Y, Legend( 15 ) ) ),
	Local Data Filter(
		Inverse( 1 ),
		Add Filter(
			columns( :name ),
			Where( :name == {"CHRIS", "DAVID", "KATIE2", "ANOTHER NAME", "SOMEONE ELSE"} ),
			Display( :name, N Items( 15 ), Find( Set Text( "" ) ) )
		)
	)
);

I hope this helps!

@julian 

[hogi]

Hi @julian, you are right, for the example with Chris and David, your suggestion is a perfect solution.
edit: unfortunately not, see below.

But inverting the full Data Filter is not always what the user wants.

If other columns are used as additional filters, "inverse" would also invert those selections.