Filtered Data

The Filtered Data tab opens when you double-click an element in a graph or cross tabulation to view its detailed data. It displays the rows corresponding to the element you double-clicked, and lets you add filters or save the data as a derived dataset.

When It Opens

The Filtered Data tab does not exist by default. It is created by these actions:

Double-click a data point or bar in Graph Builder
Double-click a chart element (histogram bar, category bar, pair plot point, time series point, etc.) in the Statistics tab
Double-click a cell in Crosstab
Choose Open as Filtered Data from the Selected Rows tab's menu button (⋮) (only available when a selection expression exists)

Each action automatically sets the appropriate filter condition. For example, double-clicking a histogram bar shows only the rows within that bar's range. Double-clicking a Crosstab cell shows the rows matching both the row category and column category of that cell.

Filtered Data tab opened by double-clicking a Crosstab cell

What It Shows

A filter expression input field is at the top of the tab. You can enter additional conditions to further narrow down the data copied when the tab was opened. Changes to the source data are not reflected in this tab. The syntax is the same as Data Table filters.

When an additional filter is applied, the filtered row count is displayed. For example, if the original data has 44 rows and the additional filter narrows it to 30, "Showing 30 of 44 rows (filtered)" is shown.

A Save as Dataset button is to the right of the input field.

The table supports clicking column headers to select columns and clicking rows to select rows.

Actions

Adding a filter expression -- Enter a condition in the filter input field to further narrow the data. Click the X button at the right edge of the input field to remove the additional filter. When you save with an additional filter, the original filter condition and the additional filter are combined using AND. For example, if the original condition is x >= 10 AND x < 20 and the additional filter is y = 'A' OR y = 'B', the saved derived dataset contains rows that satisfy both x >= 10 AND x < 20 and y = 'A' OR y = 'B'.

Save as Dataset -- Saves the displayed data as a derived dataset. Clicking the button opens a dialog where you enter a dataset name and save. The derived dataset references the source data by filter expression. If you reload the dataset, the filter expression is re-evaluated to return matching rows. The Filtered Data tab shows a snapshot taken when the tab was opened and does not change, while a derived dataset saved by Save as Dataset re-evaluates its filter expression when the source data is updated.

Workflow Example: Extract Data from a Histogram Range

Double-click a bar in a Statistics tab histogram
A Filtered Data tab opens showing the rows within that bar's range
Optionally enter additional conditions in the filter input field
Click Save as Dataset, enter a dataset name in the dialog, and save

Differences from Selected Rows

The Filtered Data tab is created by double-clicking and does not depend on the current row selection state. Data remains even after clearing row selection. However, closing the tab discards the data, so save any data you need using Save as Dataset. When saved, the derived dataset references rows by filter expression, so it returns matching rows even after the source data is updated.

The Selected Rows tab reflects the current selection state in real time. Clearing the selection returns it to "No Rows Selected". When saved, the derived dataset references rows by index.

	Selected Rows	Filtered Data
What it shows	Currently selected rows	Rows matching a specific condition
When selection is cleared	Returns to "No Rows Selected"	Tab and data remain
Additional filtering	Not available	Enter a filter expression for further narrowing
Save as Dataset method	References by row index	References by filter expression
When source data is updated	Returns rows at the same row numbers	Re-evaluates the filter expression to return matching rows

A Selected Rows derived dataset references source data by row index. If rows are added to or reordered in the source data, the same row numbers may point to different data.