Using JMP > JMP Reports > Red Triangle Options in JMP Reports > Local Data Filters in Reports
Publication date: 03/23/2021

Local Data Filters in Reports

Local Data Filters limit the scope of the filter to the output of the platform that you are in. For example, suppose 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 and then use the Local Data Filter to narrow the results in the Distribution platform to the type of company.

1. Select Help > Sample Data Library and open

2. Select Analyze > Distribution.

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

4. Click OK.

5. Click the Distributions red triangle and select Local Data Filter.

6. Click Type and click Add Image shown here.

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

Figure 9.4 Local Data Filter Showing Pharmaceutical Profits 

Local Data Filter Showing Pharmaceutical Profits

Note: The red triangle menu next to a variable contains options such as inverting the selection and displaying the values in a list of check boxes. See Red Triangle Options for Variables in Data Filters for more information.

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, click the red triangle next to Local Data Filter and 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, click the Local Data Filter red triangle and deselect Count Excluded Rows.

Figure 9.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”. Also, there are nine “big” values. When the excluded rows are omitted, only 16 rows contain “Computer”.

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

Counting (Left) and Omitting (Right) Excluded Rows

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

For more information about 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.

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

Zoom In on Time Series Data

After you filter time series data, you can zoom in closer on the Local Data Filter histogram to see smaller time increments. Suppose that one year of data are selected on the histogram. To view smaller increments of time within that year, select Zoom to Selection from the red triangle menu next to the variable. Select Reset Zoom from the Local Data Filter red triangle menu to reset the histogram.

Want more information? Have questions? Get answers in the JMP User Community (