Skip to content
Probably logo |Docs

Filtering & Sorting

Use filtering and sorting features to explore your data efficiently. Apply basic filters, sort columns, and organize information for analysis.

Basic Filtering System

Section titled “Basic Filtering System”

Filter Controls

Section titled “Filter Controls”

Available filter options:

  • Column Filters: Apply filters to individual columns
  • Active Filters: View and remove applied filters
  • Null Values: Toggle to show/hide missing data
  • Filter Combinations: Use multiple filters together

Available Filter Operations

Section titled “Available Filter Operations”

Text Filtering

Status equals "active"
Description contains "urgent"
Category in ("A", "B", "C")
Name not equal to "test"

Numeric Filtering

Revenue > 10000
Age < 65
Amount between 100 and 1000
Count not equal to 0

Date Filtering

Created after 2024-01-01
Updated before 2024-12-31
Date between specific ranges

Combined Conditions

Status = "premium" AND
Revenue > 50000 AND
Region in ("North", "West")

Filter Interface

Section titled “Filter Interface”

Filter Builder

Column Selection: Click any column header to add filters

Operator Choice: Choose from type-appropriate operators

Value Input: Smart suggestions based on column data

Multiple Conditions: Combine filters with AND/OR logic

Sorting and Organization

Section titled “Sorting and Organization”

Multi-Column Sorting

Section titled “Multi-Column Sorting”
  • Primary Sort: Click column header
  • Secondary Sort: Shift+click additional columns
  • Sort Indicators: Visual arrows show sort direction
  • Mixed Types: Intelligent sorting across data types

Column Management

Section titled “Column Management”
  • Hide Columns: Right-click header → Hide
  • Reorder Columns: Drag headers to rearrange
  • Resize Columns: Drag column borders
  • Auto-Size: Double-click border for optimal width

Sorting Features

Section titled “Sorting Features”

Column Sorting

Section titled “Column Sorting”
  • Single Column: Click column header to sort
  • Sort Direction: Toggle between ascending and descending
  • Sort Indicators: Visual arrows show sort direction
  • Data Type Aware: Proper sorting for numbers, dates, and text

Column Management

Section titled “Column Management”

Column Operations

Section titled “Column Operations”
  • Hide/Show Columns: Toggle column visibility
  • Reorder Columns: Drag and drop to rearrange
  • Resize Columns: Adjust column widths
  • Column Selection: Select entire columns for operations

Search Features

Section titled “Search Features”
Section titled “Column Search”
  • Find Columns: Search for column names by typing
  • Quick Navigation: Quickly locate specific variables
  • Filter Lists: Search within column selection dropdowns

Performance Features

Section titled “Performance Features”

Optimized Display

Section titled “Optimized Display”
  • Virtual Scrolling: Efficient rendering of large datasets
  • Pagination: Load data in manageable chunks
  • Responsive Interface: Smooth interaction with large datasets

What’s Next?

Section titled “What’s Next?”

Data Transformation

Learn how to use PXL expressions for powerful data transformations and calculations.

Data Transformation

Selection Operations

Discover how to select data ranges and perform bulk operations efficiently.

Selection & Operations