Granted Patent B1

US 9,009,171 · App. 14/268,964 · Granted Apr 14, 2015

Abstract

Claims (66)

1. An electronic device comprising:

one or more computer-readable storage media configured to store instructions; and

one or more processors configured to execute the instructions to cause the electronic device to:

provide a table having data values arranged in rows and columns;

provide a first filter location indicator at a location that is visually associated with a first column, wherein the location of the provided first filter location indicator is visually associated with the first column based on the provided first filter location indicator being closer in proximity to the first column than to another column in the table;

provide a first interface based on a selection of the provided first filter location indicator, wherein the first interface is at a location that is visually associated with the first column;

acquire a first filter input entered into the first interface;

filter the table based on the acquired first filter input;

provide the filtered table for displaying; and

provide an applied filter indicator at a location that is visually associated with the first column, the applied filter indicator comprising at least the first filter input.

2. The electronic device of claim 1 , wherein the filter location indicator, the first interface, and the applied filter indicator are provided inside or substantially adjacent to a header of the first column.

3. The electronic device of claim 1 , wherein the first filter input comprises a string of characters, and the filtering of the table comprises determining in the first column data values comprising the string of characters and removing from the table one or more rows that do not comprise the determined data values in the first column.

4. The electronic device of claim 1 , wherein the one or more processors are further configured to execute the instructions to cause the electronic device to:

provide a second interface, wherein the second interface's location is visually associated with the first column;

acquire a second filter input entered into the second interface;

further filter the table based on the acquired second filter input; and

update the applied filter indicator to comprise the first and the second filter inputs.

5. The electronic device of claim 4 , wherein the first interface and the second interface are Graphical User Interface (GUI) widgets of different types.

6. The electronic device of claim 1 , wherein the first filter input comprises a range of values, and the filtering of the table comprises determining in the first column data values corresponding to the range of values and removing from the table one or more rows that do not comprise the determined data values in the first column.

7. The electronic device of claim 6 , wherein the one or more processors are further configured to execute the instructions to cause the electronic device to:

provide a chart representing distribution of data values in the first column, the chart comprising one or more user-adjustable handles defining the range of values.

8. The electronic device of claim 1 , wherein the one or more processors are further configured to execute the instructions to cause the electronic device to:

provide a second filter location indicator whose location is visually associated with a second column;

provide a second interface based on a selection of the second filter location indicator, wherein the second interface's location is visually associated with the second column;

acquire a second filter input entered into the second interface; and

filter the table based on the acquired first and second filter inputs.

9. A method for active column filtering, the method being performed by one or more processors and comprising:

providing a table having data values arranged in rows and columns;

providing a first filter location indicator at a location that is visually associated with a first column, wherein the provided first filter location indicator is visually associated with the first column based on the provided first filter location indicator being closer in proximity to the first column than to another column in the table;

providing a first interface based on a selection of the provided first filter location indicator, wherein the first interface is at a location that is visually associated with the first column;

acquiring a first filter input entered into the first interface;

filtering the table based on the acquired first filter input;

providing the filtered table for displaying; and

providing an applied filter indicator at a location that is visually associated with the first column, the applied filter indicator comprising at least the first filter input.

10. The method of claim 9 , wherein the filter location indicator, the first interface, and the applied filter indicator are provided inside or substantially adjacent to a header of the first column.

11. The method of claim 9 , wherein the first filter input comprises a string of characters, and the filtering step comprises determining in the first column data values comprising the string of characters and removing from the table one or more rows that do not comprise the determined data values in the first column.

12. The method of claim 9 , further comprising:

providing a second interface, wherein the second interface's location is visually associated with the first column;

acquiring a second filter input entered into the second interface;

further filtering the table based on the acquired second filter input; and

updating the applied filter indicator to comprise the first and the second filter inputs.

13. The method of claim 12 , wherein the first interface and the second interface are Graphical User Interface (GUI) widgets of different types.

14. The method of claim 9 , wherein the first filter input comprises a range of values, and the process of filtering comprises determining in the first column data values corresponding to the range of values and removing from the table one or more rows that do not comprise the determined data values in the first column.

15. The method of claim 14 , further comprising:

providing a chart representing distribution of data values in the first column, the chart comprising one or more user-adjustable handles defining the range of values.

16. The method of claim 9 , further comprising:

providing a second filter location indicator whose location is visually associated with a second column;

providing a second interface based on a selection of the second filter location indicator, wherein the second interface's location is visually associated with the second column;

acquiring a second filter input entered into the second interface; and

filtering the table based on the acquired first and second filter inputs.

17. A non-transitory computer-readable medium storing a set of instructions that are executable by one or more electronic devices, each having one or more processors, to cause the one or more electronic devices to perform a method, the method comprising:

providing a table having data values arranged in rows and columns;

providing a first filter location indicator at a location that is visually associated with a first column, wherein the provided first filter location indicator is visually associated with the first column based on the provided first location indicator being closer in proximity to the first column than to another column in the table;

providing a first interface based on a selection of the provided first filter location indicator, wherein the first interface is at a location that is visually associated with the first column;

acquiring a first filter input entered into the first interface;

filtering the table based on the acquired first filter input;

providing the filtered table for displaying; and

providing an applied filter indicator at a location that is visually associated with the first column, the applied filter indicator comprising at least the first filter input.

18. The non-transitory computer-readable medium of claim 17 , wherein the filter location indicator, the first interface, and the applied filter indicator are provided inside or substantially adjacent to a header of the first column.

19. The non-transitory computer-readable medium of claim 17 , further comprising instructions executable by the one or more electronic devices to cause the one or more electronic devices to perform:

providing a second interface, wherein the second interface's location is visually associated with the first column;

acquiring a second filter input entered into the second interface;

further filtering the table based on the acquired second filter input; and

updating the applied filter indicator to comprise the first and the second filter inputs.

20. The non-transitory computer-readable medium of claim 17 , wherein the first filter input comprises a range of values, and the filtering of the table comprises determining in the first column data values corresponding to the range of values and removing from the table one or more rows that do not comprise the determined data values in the first column, the non-transitory computer-readable medium further comprising instructions executable by the one or more electronic devices to cause the one or more electronic devices to perform:

providing a chart representing distribution of data values in the first column, the chart comprising one or more user-adjustable handles defining the range of values.

Assignments (8)