Apply Filters
You can filter data using natural language conditions:- Filter by value: “Show transactions from California”
- Filter by number: “Show orders over 1000”
- Filter by date: “Show customers who joined in 2024”
Filter Types
| Filter Type | Description | Examples |
|---|---|---|
| Comparisons and Ranges | Filter by numeric comparisons and value ranges | • “Orders between 100 and 500” • “Customers with more than 5 purchases” • Greater than / less than • Between two values • At least / at most |
| Text Patterns | Filter text fields by patterns | • Contains • Starts with • Ends with |
| Time-Based | Filter by dates and time ranges, expressed naturally or explicitly | • “Last month” • “This year” • “Between January and March 2024” • “Last 30 days” Zark automatically interprets relative time ranges. |
| Missing Data | Filter based on missing or empty values. Useful for validating data quality or identifying gaps. | • “Show records where email is missing” • “Exclude rows with empty regions” • “Count customers with and without phone numbers” |
| Exclude/Negation | Filter out specific values. Helps identify exceptions, gaps, and outliers. | • “Orders not from California” • “Customers who haven’t purchased this year” • “Tickets not resolved” |