A filter request can sound clear until you ask what “and” means. Suppose you want observations from the garden and observations made on Tuesday. Do you mean Tuesday observations in the garden, or every garden observation plus every Tuesday observation?
Build four test rows
Imagine these records: garden on Tuesday, garden on Friday, balcony on Tuesday, and balcony on Friday. Requiring both garden and Tuesday keeps only the first row. Accepting either garden or Tuesday keeps the first three rows.
The first row belongs to both groups, but it should appear only once in the filtered result. This is an illustrative table, not data from a completed study. Its small size makes the logic visible before software enters the picture.
Write the rule in a complete sentence
Before applying a real filter, state whether every condition must hold or whether one is enough. If the interface provides an AND or OR setting, match it to that sentence. Inspect a few included and excluded rows afterwards.
Record the original row count, filtered count, and exact rule. A filtered table answers a narrower question than the source dataset. Keeping the rule with the result prevents a later reader from mistaking your selected subset for all the observations that were originally available.