Skip to content
Kubit Guide home
Kubit Guide home

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:

  1. Field — the dimension or measure to filter on (e.g., countrymodel_namestatus_code).

  2. Operator — how to compare the field's value (e.g., Equal, Contains, Greater Than).

  3. Value(s) — the target value(s) to match against.

Filter Operators

Operator

Description

Example

Equal

Exact match

country = "US"

Not Equal

Excludes exact match

status ≠ "test"

Contains

Substring match

name contains "checkout"

Not Contains

Excludes substring

name not contains "internal"

Starts With

Prefix match

url starts with "/api"

Ends With

Suffix match

email ends with "@company.com"

Greater Than

Numeric comparison

duration > 5000

Less Than

Numeric comparison

response_time < 200

Greater or Equal

Numeric comparison

retry_count >= 3

Less or Equal

Numeric comparison

error_count <= 1

Between

Range (inclusive)

age between 18 and 65

Exists

Field is present (not null)

error_message exists

Is Empty

Field is null or empty

referrer is empty

Matches

Regex pattern match

path matches "^/api/v[0-9]+"

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.