Add Maple
← All help articles

Use filter types

Use this reference whenever you need to choose the right filter for a column. Every filter here removes respondent rows from your dataset before any charts, tables, or exports run. The table lists the label you see in the filter menu, the supported column types, and a quick example so you can apply it with confidence.

Filter label Column types What it does Example
is equal to Numeric Keeps rows where the numeric value matches exactly. Show only respondents with Score = 5.
is not equal to Numeric Removes rows where the value matches exactly. Exclude Age = 18 respondents.
is between Numeric, Date Keeps rows within the start (inclusive) and before the end (exclusive) of a range. On dates, the filter automatically matches the granularity of the inputs. Limit to Satisfaction between 6 and 8, or Date between 2024-01-01 and 2024-03-01.
is greater than or equal to Numeric Keeps rows with values ≥ the number you enter. Include scores of 4 or higher.
is greater than Numeric Keeps rows with values strictly greater than the number you enter. Focus on Spend > 500.
is less than or equal to Numeric Keeps rows with values ≤ the number you enter. Review respondents with NPS ≤ 0.
is less than Numeric Keeps rows with values strictly less than the number you enter. Highlight orders with Quantity < 5.
is Categorical (single-select) Keeps rows where the category matches the selection. View only Country = Canada.
is not Categorical (single-select) Removes rows where the category matches the selection. Exclude Plan = Free.
has more than Categorical (single-select) Keeps rows belonging to categories whose total count is above the threshold; selections that fall below the threshold are filtered out everywhere. Drop countries with fewer than 50 responses.
contains Text, Unique ID Finds rows where the cell contains the phrase (case-insensitive). Wrap the phrase in quotes to match whole words only. Find feedback mentioning "delay".
doesn't contain Text, Unique ID Removes rows containing the phrase. Quoted phrases enforce whole-word matching. Remove comments that say "spam".
includes any Categorical (multi-select) Keeps rows that contain at least one of the selected options. Keep respondents who chose either Email or SMS.
includes all Categorical (multi-select) Keeps rows that contain every selected option. Find respondents who selected both iOS and Android.
doesn't include Categorical (multi-select) Removes rows that contain any of the selected options. Exclude anyone who picked Other.
count is Categorical (multi-select) Matches rows where the number of selected options equals the number you enter. Find respondents who chose exactly 2 features.
count is greater than Categorical (multi-select) Matches rows where the number of selected options is greater than the number you enter. Find respondents who selected 3+ channels.
count is greater than or equal to Categorical (multi-select) Matches rows where the number of selected options is ≥ the number you enter. Include anyone who picked at least 4 interests.
count is less than Categorical (multi-select) Matches rows where the number of selected options is less than the number you enter. Focus on respondents who chose fewer than 2 partners.
count is less than or equal to Categorical (multi-select) Matches rows where the number of selected options is ≤ the number you enter. Capture respondents who chose at most 1 add-on.

Date range tips

  • When you enter start and end timestamps less than a week apart, AddMaple honors the exact time. Wider ranges automatically compare on whole dates so you do not see partial-day mismatches.
  • Filtering a date column from a chart uses the same is between logic. Click a bar to pre-fill the range, then adjust the start or end if needed.

Text matching tips

  • Text filters ignore case by default (contains matches Delay, delay, or Delayed).
  • Wrap the value in quotation marks to require a whole-word match. For example, "VIP" matches VIP customer but not VIPER.
  • Use doesn't contain to keep everything except the phrase you specify—great for removing spammy tags or out-of-scope topics.

Multi-select guidance

  • has more than applies to single-select columns; for multi-select questions use the count operators (count is, count is greater than, etc.) to control how many selections a row must have.
  • Combine includes all with a count operator to require specific answers plus additional selections. Example: add includes all → Enterprise and count is greater than or equal to → 3 to focus on complex enterprise customers.

Combine filters with AND/OR

  • The first filter always uses and logic. Switch later filters to or when you want to match either condition.
  • Grouping happens automatically: AddMaple joins all and filters together, while or filters within the same column group create broader matches.

Related guides