The Filtered Data Tab

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. Each action adds a new tab, so multiple Filtered Data tabs can be open at the same time:

• 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
• Right-click a histogram or Date Distribution chart in the Statistics tab, or a graph in Graph Builder, and choose Open as Filtered Data
• Choose Open as Filtered Data from the Selected Rows tab's menu button (⋮)

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. The right-click Open as Filtered Data opens the tab with the current selection expression rather than the condition of a single element. Open as Filtered Data appears in the menu only when a selection expression exists.

One exception: when a Graph Builder graph that draws a derived dataset declares its underlying data with Select & drill down on, double-clicking an element opens a Contributing rows tab showing the underlying rows instead of a Filtered Data tab.

What It Shows

This tab displays the rows matching the filter condition. When the source data changes, such as by cell edits or a reload with Reload Dataset, the tab reapplies the filter condition to the current data and updates the display. If a column referenced by the filter expression has been removed from the source data, the tab reports an error and keeps the previous display. Closing the tab discards the data, so save any data you want to keep using Save as Dataset.

A filter expression input field is at the top of the tab. You can enter additional conditions to further narrow down the snapshot. The syntax is the same as Data Table filters.

When an additional filter reduces the row count, 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'. The combined condition is equivalent to (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. When the source data is updated, such as by cell edits or a reload with Reload Dataset, the filter expression is re-evaluated to return matching rows. The saved derived dataset persists after the tab is closed, appears in the dataset list in Project Overview, and can be selected from the dataset dropdown in other tabs.

Workflow Example: Extract Data from a Histogram Range

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

Differences from Selected Rows

A Filtered Data tab is created by double-clicking, does not depend on the current row selection state, and its data remains even after clearing the selection. For a comparison with the Selected Rows tab, which reflects the current selection state in real time, see How Row Selection Works.

See also

• Selected Rows -- Tab showing currently selected rows
• How Row Selection Works -- How to select rows in each tab and how selection state is shared
• Datasets -- Details on derived datasets
• Data Table -- Filter expression syntax

Also available as a Markdown file.