Skip to main content

Filter data with groups, AND, and OR logic

Combine filter conditions into groups with AND/OR logic to answer complex questions across millions of rows.

Written by Stateable

Stateable's filter system uses groups so you can combine several conditions into one view: inside a group, conditions are joined with OR. Between groups, you choose AND or OR. That's enough to answer almost any question your team can put into words.

Add your first filter

  1. Open the Data tab. If the left sidebar isn't showing Filters, click the funnel icon.

  2. Pick a field from the list (e.g. Carrier). The values for that field appear.

  3. Check the values you want. As soon as you check at least one, a pill for the group appears in the bar above the grid, and the grid refreshes.

Every box you check in a group is joined with OR. Checking "State Farm" and "Allstate" inside the Carrier group means rows where Carrier is State Farm OR Allstate.

Add a second group

  1. Pick a different field (e.g. Policy Number). A new group appears.

  2. Between the two pills, a connector shows AND. Click it to toggle to OR.

By default, groups are joined with AND — a row has to match all of them. That's how people usually think: "carrier is X and policy is Y".

Rearrange groups

Drag any pill in the bar to put the groups in a different order. The order doesn't change your results — it's just to make the view easier to read.

Clear filters

  • Click the × on a pill to remove that group.

  • Click Clear above the grid to remove every filter at once.

Sharing a view

Your filters are saved right in the page's web address (the URL), so you can copy that address and send it to a teammate to share the exact view. They'll open the link and land on the same filtered grid you're looking at.

Tips

  • Start typing in any filter panel to jump straight to the value you want. Handy when a field has hundreds of values.

  • For date fields, you can pick a ready-made range like "last 30 days" instead of typing exact start and end dates.

  • Stateable remembers your last filter setup. Close the app and come back, and your view is right where you left it.

Troubleshooting

  • I don't see an AND/OR connector between groups. A single-group view doesn't show a connector. Add a second group; the connector appears between them.

  • My filter pill won't drag. You have to grab the pill by its title, not by its values. Click and hold near the AND/OR connector, then drag.

Get help

Still need a hand? Start a conversation from the Support button in the app, or email [email protected]. We reply within one business day for most tickets.

Related articles

Last reviewed: 2026-05-27

Did this answer your question?