Local Data Filter

Local Data Filters limit the scope of the filter to the output of the platform that you are in. For example, say that you have data on the profits of 30 different computer and pharmaceutical companies. You want to examine profits by company type. You can run a distribution, then use the Local Data Filter to narrow the results in the Distribution platform to the type of company.

Select Help > Sample Data Library and open Companies.jmp.

Select Analyze > Distribution.

Select Profits ($M) and click Y, Columns.

Click OK.

From the Distributions red triangle menu, select Local Data Filter.

Click Type and click Add.

In the Type box, click Pharmaceutical to see only their profits, then click Computer to see only their profits.

Figure 8.4 Local Data Filter Showing Pharmaceutical Profits

Local Filtering

When you use a Local Data Filter, it only filters in the platform, not in the data table (as the Data Filter does). For example, if you exclude rows in a Local Data Filter, these rows are not excluded in the data table. And, if you have row states in your data table, they are not impacted by the Local Data Filter.

Saving a Filter

You can script and therefore save a Local Data Filter, so that you can access your filter settings again quickly. To save a filter, from the red triangle next to Local Data Filter, select one of the Save Script options.

Counting Excluded Rows

The counts for each level of a variable (including excluded rows) are shown in the Local Data Filter by default. To omit the excluded rows from the count, deselect Count Excluded Rows in the Local Data Filter red triangle menu.

Figure 8.5 shows the difference between counting and omitting excluded rows. When the excluded rows are counted, the Local Data Filter shows 20 rows that contain the value “Computer”. When the excluded rows are omitted, only 16 rows contain “Computer”.

Figure 8.5 Counting (Left) and Omitting (Right) Excluded Rows

Note: The counts are not shown when Display Options is set to Blocks Display (as shown in Figure 8.4).

For details about more advanced scripting with Local Data Filters, see Define the Context of a Data Filter in the Scripting Guide.

Using By-Groups and Subset Reports

If your analysis uses by-groups or combines together reports using linked subsets of the same table, a local data filter on the parent table can be shared between all the different by-groups and subset reports.

Using Local Data Filters in Dashboards and Applications

You can incorporate Local Data Filters into dashboards or applications:

•

For an example using dashboards, see Example of Creating a JMP Query Dashboard and Add-In in Extend JMP.

•

For an example using applications, see Filtering Data in Separate Reports Using a Local Data Filter in the Scripting Guide.