Advanced Filter Values

By default, filters compare a column against static values you type in. But you can also compare against other columns or connect to dashboard-level filter variables.

Value input types

Each filter condition supports three value types, selectable via buttons next to the value field:

Type	Icon	Description
Static	Data type icon (text, number, calendar, toggle)	Enter values directly
Filter Variable	Funnel icon	Connect to a filter variable
Column	Grid icon	Compare against another column

Static values

Static values are the default. You type or select the comparison value directly.

Value autocomplete

For String and Boolean columns, the input provides autocomplete based on actual values in your data. Start typing to see matches, or click the dropdown to browse.

Multiple value selection

Some operators allow selecting multiple values:

String: Equals, Not Equal, Contains, Does Not Contain, Starts With, Ends With
Number: Equals, Not Equal

When you select multiple values:

“Equals” includes rows matching ANY selected value
“Not Equal” excludes rows matching ANY selected value

Date and time values

Date columns have specialized inputs depending on the operator and time mode. See Date Filtering for details.

Null handling

Use Is Blank and Is Not Blank operators for null/empty values. These operators don’t need a value input.

Column comparison

Column comparison lets you compare values between two columns in the same row. Useful for finding records where column relationships matter.

How to use

Click the Column button (grid icon) in the value input area
Select the column to compare against
The filter compares each row’s value in the left column against the corresponding value in the right column

Data type requirements

You can only compare compatible data types:

Source column	Can compare to
String	String only
Number (int, float)	Number only
Date	Date, Datetime
Datetime	Date, Datetime
Boolean	Boolean only

Incompatible columns are disabled in the picker.

Column offset

When comparing columns, you can optionally apply an offset:

For Number columns:

Enter a numeric offset added to the comparison column’s value
Example: Compare revenue to cost + 100

For Date/Datetime columns:

Enter a time offset using days, hours, and minutes
Example: Compare due_date to created_date + 7 days

Use cases

Find overdue items:

Column: due_date
Operator: Before
Compare to: current_date (if available) or use date filtering with “now”

Find profitable sales:

Column: revenue
Operator: Greater Than
Compare to: cost

Find records where fields match:

Column: shipping_address
Operator: Equals
Compare to: billing_address

Find records where fields differ:

Column: assigned_to
Operator: Not Equal
Compare to: created_by

Filter Variables

Filter Variables let dashboard-level filtering connect to multiple widgets. When someone changes a filter variable, all connected widget filters update automatically.

How it works

Create a filter variable in your dashboard (see Filter Variables)
In a widget’s filter, click the Filter Variable button (funnel icon)
Select the filter variable to connect
The filter’s value is now controlled by the dashboard filter variable

Benefits

Consistent filtering: Multiple widgets filter by the same criteria
User interactivity: Viewers can change filters without editing widgets
Dynamic dashboards: Create flexible, reusable layouts

Compatibility

Filter variables must match the column being filtered:

String filter variable → string column filters
Date filter variable → date/datetime column filters
And so on

For complete docs, see Filter Variables.

Best practices

Use filter variables for user-facing dashboards: Let viewers filter without edit access
Use column comparison for business rules: “Revenue greater than cost” is clearer than calculating margins separately
Match data types carefully: Mismatched types prevent filter creation or produce unexpected results
Consider performance: Column comparisons are evaluated row-by-row and may be slower on very large datasets
Document complex filters: When using multiple advanced features together, add widget descriptions explaining the filter logic