<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
JMP’s Data Filters allow us to interactively select and filter complex subsets of data.
Data filters can be added to our entire data table globally or locally to each platform. However, sometimes you may not know where and when to filter
Graphic Illustrate Global vs Local Filters
I’ll demonstrate both types of filters with the San Francisco Crime sample data available in JMP. My goal is to isolate the specific police district of Tenderloin in that San Francisco Bay area and explore that data further.
The Data Filter, or global filter, applies a filter for the entire data table. I can access that with a data table open, from Rows then Data Filter. Here I’ll choose what I want to filter, Police District, then select Tenderloin.
Notice that the Tenderloin rows are selected or filtered in our data table. We can exclude all other data to keep out of any further calculations.
To do this, I’ll navigate to Rows, Row Selection then Invert Row Selection.
Then back to Rows again then Hide and Exclude the non-Tenderloin districts. When we launch a platform only the Tenderloin data will be calculated.
What if we wanted to filter our data in individual JMP platforms uniquely, like Graph Builder.
That’s when we use a Local Data filter.
I’ll first reset my Data Table to include all the data. I’m just turning off Hide and Exclude.
There’s a saved script we can launch from the table menu that launches a pre-built Graph Builder report we can use to cover local data filters. I’ll select the red triangle of 3rd script down and select run script.
Here in Graph Builder we’re looking at all of San Francisco Police Districts.
Let’s add a Local Filter under the red triangle from Script then Local Data Filter.
I’ll choose Police District, select Add, then select and filter to Tenderloin.
There we go. We can save this Graph Builder Report with the local data filter attached back to our data table under red triangle then Script then Save Script to Data Table.
You can now access that in the tables menu as a launch able script, from it’s drop down menu select Run Script.
Go ahead and try out both types of JMP Data Filters now.
Thanks for watching and enjoy using JMP.
