Your starting point
Prerequisites: Use the ideas and vocabulary from lesson 51; revisit its worked examples if needed.
Definition: A filter is a predicate that includes or excludes records from a view. Exact matching, text containment and numerical comparisons are different operations. Filter scope describes which tables, summaries and charts respond to the selected condition.
Choose the operator deliberately
Searching for text that contains “North” can match labels beyond the exact category North. A numerical greater-than condition is different from text sorting or substring matching. State whether boundaries are inclusive or exclusive. The academy’s greater-than filter excludes values equal to the threshold and ignores missing or nonnumeric values for that comparison.
Show the selected population
Display original and filtered row counts and include the condition in the analysis notes. If a dashboard has several panels, readers need to know whether the filter affects all of them. The academy uses the current filtered table for statistics, grouped summaries and charts, while cleaning acts on the full working table. This distinction prevents a view selection from being mistaken for deletion.
Check bias and reproducibility
A filter can be useful for a focused question yet misleading when generalized. Excluding incomplete or low-performing cases can improve a summary without improving the process. Save the filter settings with the report and clear them before starting a different question. Test a known matching row, a boundary row and a nonmatching row to verify the rule.
Two worked examples
A numerical threshold
Durations are 5, 10 and 15 minutes. A greater-than-10 filter retains only 15, while a greater-than-or-equal-to-10 rule would retain 10 and 15. If the interface offers only strict greater-than, do not describe its result as “ten or more.” Match the wording to the implemented rule.
Text matching
Labels are North, North-East and South. Contains “North” retains two categories; exact equals “North” retains one. Both operations can be useful, but a chart title should describe which was used. A partial search should not silently become an exact geographic definition.
Where this becomes useful
A project manager reviews open tasks in one team. The view supports follow-up on those tasks, but its totals should not be presented as the workload or performance of the entire organization.
Make an attempt
Open Table Explorer with Customer support. Test exact channel matching and a numerical minutes threshold. Record the retained row count and inspect a value exactly at the boundary. Compare the filtered chart with the full table before writing a scoped finding.
Misconception check
Claim: Filtering a view is the same as deleting records from the source.
Inspect the correction
A view selection can be changed or cleared. Destructive cleaning is a separate operation and should be documented separately.
Independent application
Create a filter specification with field, operator, value and boundary rule. Test matching, boundary, missing and nonmatching records, then export the settings and write a finding that explicitly describes the selected population.
Completion records practice and self-review. It is not certification of statistical competence.
