Filters and Date Range
This guide covers Filters and Date Range — shared configuration available across all Kubit report types. It includes filter operators, filter logic, date range presets, and time units.
Filters
Filters narrow your data to only the events that match specific conditions. Apply filters at the report level to restrict which events are included in the analysis.
Filter Structure
Each filter condition consists of three parts:
Field — the dimension or measure to filter on (e.g.,
country,model_name,status_code).Operator — how to compare the field's value (e.g., Equal, Contains, Greater Than).
Value(s) — the target value(s) to match against.
Filter Operators
Operator | Description | Example |
|---|---|---|
Equal | Exact match |
|
Not Equal | Excludes exact match |
|
Contains | Substring match |
|
Not Contains | Excludes substring |
|
Starts With | Prefix match |
|
Ends With | Suffix match |
|
Greater Than | Numeric comparison |
|
Less Than | Numeric comparison |
|
Greater or Equal | Numeric comparison |
|
Less or Equal | Numeric comparison |
|
Between | Range (inclusive) |
|
Exists | Field is present (not null) |
|
Is Empty | Field is null or empty |
|
Matches | Regex pattern match |
|
Combining Filters (AND / OR Logic)
Multiple filter conditions can be combined using logical operators:
AND — all conditions must be true. Use when you want to narrow results further with each condition.
OR — any condition can be true. Use when you want to include events matching any of several criteria.
Conditions connected by AND are evaluated together — an event must satisfy every condition to be included. Conditions connected by OR broaden the result set — an event needs to satisfy at least one.
Case Sensitive Filters
In Kubit we default to text filters being Case Sensitive, meaning if you filter to subscription_type = 'Premium' then the underlying data must have the capital 'P'. If you have instances where the cases are mixed within a column you can disable case sensitivity by clicking the "Aa" button.
If it's blue then it's enabled and grey is disabled.
Filter Against Other Fields
Occasionally it's not a specific value you want to filter by but rather if the value of Column A = the value of Column B. In Kubit you're able to do this by clicking the "V" button and selecting the column you want to compare in the filter logic.
Filter Groups
Both Event Filter and Global Filter support up to three Filter Groups which are connected with a logic operator AND/OR. You can think of each Filter Group as a parenthesis.
Dashboard-Level Filters
Dashboards support their own filter layer that applies across all reports on the dashboard, overriding each report's individual settings.
Dashboard filters include an Any option (not available in report-level filters), allowing you to reset a filter dimension without removing it. Filters configured on a dashboard are saved with the dashboard and reapplied automatically when the dashboard is reopened.
Date Range
The date range defines the time window for your report. All events outside this window are excluded from the analysis.
Relative Presets
Relative date ranges adjust automatically based on the current date.
Preset | Description |
|---|---|
Last N Days | The most recent N complete days (e.g., Last 7 Days, Last 14 Days, Last 30 Days) |
Last N Weeks | The most recent N complete weeks |
Last N Months | The most recent N complete months |
Since | All data from a specific date through today |
Start Of | From the start of the current day, week, month, quarter, or year through today |
Absolute Date Range
Select a fixed start date and end date for a specific, non-moving time window. Useful for analyzing a defined period (e.g., a feature launch window or a specific incident).
Time Granularity
Time granularity controls how data points are aggregated along the time axis.
Time Unit | Description |
|---|---|
Hour | One data point per hour |
Day | One data point per day |
Week | One data point per week |
Month | One data point per month |
Quarter | One data point per quarter |
Year | One data point per year |
Four Week | One data point per 4-week period |
All Time | Single data point aggregating the entire date range |
Time Granularity Constraints by Report Type
Report Type | Allowed Time Granularities |
|---|---|
Query | All time units |
Funnel (Conversion) | Day, Week, Month, Quarter, Year, All Time |
Funnel (Frequency) | All Time only |
Funnel (Time to Convert) | All Time only |
Flow | All Time only |
Retention | Day, Week, Month (determines return period intervals) |
Data Table | All time units |
Significance | All Time only |
Include Missing Dates
When enabled (default), the report fills in zero-value data points for dates with no matching events. When disabled, dates with no data are skipped entirely.
Constraint | Details |
|---|---|
Compare dependency | Compare is not available when Include Missing Dates is disabled. |