Re: data filters, new option: "none" - Status changed to: AcknowledgedHi @hogi, thank you for your suggestion! We have captured your request and will take it under consideration.
Re: data filters, new option: "not" - Status changed to: InvestigatingRe: data filters, new option: "not"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:
Re: data filters, new option: "not"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)
Re: data filters, new option: "not" - Status changed to: We like it! (in the queue)Re: data filters, new option: "not"
Re: data filters, new option: "not"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
Re: data filters, new option: "not"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
Re: data filters, new option: "not"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.
Re: data filters, new option: "not"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.
Re: data filters, new option: "not"Oh, it seems that Inverse doesn't solve the problem that the entries are removed from the source script if they are not inside the current data table.
(the issue from the referenced discussion was not stated clearly in my previous post - so I added "persistent")
I just tried the steps in
https://community.jmp.com/t5/Discussions/Data-filter-how-to-specify-the-limits/m-p/643556/highlight/true#M84017
with your code with Jmp 17.1 - and after saving the script,
Where( :name == {"CHRIS", "DAVID", "KATIE2", "ANOTHER NAME", "SOMEONE ELSE"} ),was gone.
Re: data filters, new option: "not"You're quite right, @hogi! I didn't dig deep enough into the question to give a useful answer here. I can't think of a way to accomplish this with the existing tools, so it's good you got this on the wish list.
data filters, new option: "not"â 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/m-p/556062#M77004
Unfortunately, for standard columns, there is no "none":
https://community.jmp.com/t5/Discussions/advanced-data-filter-arithmetic-just-available-if-the-column-is/m-p/556682
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 
Advanced Statistical ModelingAutomation and ScriptingData Blending and CleanupData Exploration and VisualizationSharing and Communicating ResultsRe: data filters, new option: "not"yes, it will be sooo useful!
I hope it will be implemented in one of the future releases of JMP ...
