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 histogram bar in the Statistics tab
- Double-click a histogram bar in the Hypothesis Test diagnostics panel
- Double-click a cell in Crosstab
- 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.
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 displayed data. The syntax is the same SQL-like expressions used by 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 Clear to remove the additional filter.
Save as Dataset -- Saves the displayed data as a derived dataset. If you entered an additional filter, your input is appended to the original filter condition with AND. Within the additional filter input, you can freely combine conditions using AND and OR. The derived dataset references the source data by filter expression. If you reload the dataset from a CSV file, the filter expression is re-evaluated to return matching rows.
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 to save as a derived dataset for further analysis
Differences from Selected Rows
The Filtered Data tab is an independent tab created by double-clicking. Data remains even after clearing row selection. 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 |
See also
- Selected Rows -- Tab showing currently selected rows
- Row Selection -- How to select rows in each tab and how selection state is shared
- Datasets -- Details on derived datasets
- Data Table -- Filter expression syntax