Cell Entry Filter Icons for Data Filtering Accuracy
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional data filtering processes are time-consuming and prone to user input errors, especially for users who frequently filter data, due to the need for manual input of filter criteria, which can lead to inefficiency and incorrect conclusions.
Innovation Solution
A method that allows users to apply filters by selecting filter icons within cells, eliminating the need for manual input and reducing the risk of errors, by automatically populating filter dialog entries with cell entries and applying filters with a single user action.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional filtering process is used where user manually inputs filter criteria, then filtering function can be applied, but it is time consuming and susceptible to user input errors
Solution Approach 1:
The system pre-loads filter options and criteria into a dialog box before the user needs to filter. When the user selects a column for filtering, the filter dialog automatically appears with pre-populated criteria based on the cell data, eliminating the need for users to manually type or search for filter options. This preliminary preparation of filter criteria resolves the contradiction by making filtering both faster (reducing time loss) and more accurate (improving reliability through auto-completion).
Solution Approach 2:
The filtering system serves itself by automatically generating and populating filter criteria based on the selected column's data. Instead of requiring the user to manually input filter terms, the system extracts relevant filter options from the cell entries and presents them automatically. This self-service mechanism eliminates manual input errors (improving reliability) while reducing the time required to apply filters.
2Measurement precision
If user manually inputs filter criteria with spelling and capitalization requirements, then accurate filtering can be achieved, but user frustration increases due to input errors
Solution Approach 1:
The system copies the actual cell entries from the selected column and uses them as the basis for filter criteria. Instead of requiring users to type filter terms from scratch, the system presents copies of existing data values as selectable options. This ensures that the spelling and capitalization match the source data exactly (maintaining measurement precision) while making filtering much easier and less frustrating for users.
Solution Approach 2:
The filter dialog automatically extracts and populates filter criteria from the selected column's cell entries, serving itself rather than relying on manual user input. This self-service approach ensures that the filter criteria accurately reflect the actual data values (maintaining precision) while eliminating the need for users to worry about spelling or capitalization errors (improving ease of operation).
Data Source
AI summary
A method for data filtering includes displaying on a display device a cell set including data of a common data type, and displaying a first filter icon within a first cell of the cell set and a second filter icon within a second cell of the cell set. The first cell includes a first cell entry and the second cell includes a second cell entry. The first filter icon filters based on the first cell entry and the second filter icon filters based on the second cell entry. The method further includes applying a filter to the cell set in response to selection of the first filter icon by a user, the filter being based on the first cell entry.