MULTI-CONDITION FILTERING OF AN INTERACTIVE SUMMARY TABLE

• US 20100228752A1
• Filed: 02/25/2009
• Published: 09/09/2010
• Est. Priority Date: 02/25/2009
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Li, Zixiang, Folting, Allan, Grabar, Anatoly V.
• Application Number:
  US12/392,111
• Publication Number:
  US 20100228752A1
• Time in Patent Office: Days
• US Class Current: 707/758
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Technologies are described herein for allowing a user of an interactive summary table to specify multi-condition data filters to modify the data displayed in the summary table. A user interface is displayed to the user that allows the user to specify a multi-condition data filter. The specification of the multi-condition data filter includes a set of filter conditions connected by logical operators. One or more filter expressions are parsed from the specification of the multi-condition data filter based on the filter conditions and the logical operators, and the filter expressions are applied to the summary data from which the summary table is displayed.

Claims

1. A computer-implemented method for providing multi-condition filtering of summary data displayed in a summary table on a display device connected to a computer, the method comprising:

displaying on the display device a user interface allowing a user of the computer to specify a multi-condition data filter;

receiving from the user interface a specification for the multi-condition data filter comprising a plurality of filter conditions connected by logical operators;

parsing one or more filter expressions from the specification based on the plurality of filter conditions and the logical operators;

applying the one or more filter expressions to the summary data; and

displaying the filtered summary data in the summary table on the display device.

2. The computer-implemented method of claim 1, wherein the user interface comprises a means for adding filter conditions to the plurality of filter conditions and deleting filter conditions from the plurality of filter conditions.

3. The computer-implemented method of claim 2, wherein the user interface further comprises a means for selecting the logical operators connecting adjacent filter conditions in the plurality of filter conditions.

4. The computer-implemented method of claim 2, wherein the user interface further comprises a means for ordering the plurality of filter conditions in a specific order.

5. The computer-implemented method of claim 4, wherein the specification of the multi-condition data filter further comprises the specific order of the plurality of filter conditions and wherein the one or more filter expressions are further based on the specific order of the plurality of filter conditions.

6. The computer-implemented method of claim 2, wherein the user interface further comprises a means for grouping a subset of the plurality of filter conditions into one or more groupings of filter conditions.

7. The computer-implemented method of claim 6, wherein the specification of the multi-condition data filter further comprises the one or more groupings of filter conditions and wherein the one or more filter expressions are further based on the one or more groupings of filter conditions.

8. The computer-implemented method of claim 6, wherein the user interface further comprises a means for showing the one or more grouping of filter conditions in conjunction with a display of the plurality of filter conditions.

9. The computer-implemented method of claim 1, further comprising:

receiving from the user interface specifications for a plurality of multi-condition data filters;

receiving from the user interface an order of application of the plurality of multi-condition data filters; and

applying the one or more filter expressions in an order based at least in part on the order of application of the plurality of multi-condition data filters.

10. The computer-implemented method of claim 9, further comprising recalculating aggregate totals within the summary data between each successive application of the one or more filter expressions.

11. The computer-implemented method of claim 1, wherein the method is performed by a spreadsheet program operating on the computer.

12. A computer-readable medium having computer executable instructions stored thereon that, when executed by a computer, cause the computer to:

receive summary data;

receive a specification for a multi-condition data filter, the specification comprising a plurality of filter conditions connected by logical operators;

parse one or more filter expressions from the specification based on the plurality of filter conditions and the logical operators;

apply the one or more filter expressions to the summary data; and

pass the filtered summary data to a display module for display of a summary table on a display device connected to the computer.

13. The computer-readable medium of claim 12, wherein the specification of the multi-condition data filter further comprises a specified order of the plurality of filter conditions and wherein the one or more filter expressions is further based on the specified order of the plurality of filter conditions.

14. The computer-readable medium of claim 12, wherein the specification of the multi-condition data filter further comprises one or more groupings of filter conditions and wherein the one or more filter expressions is further based on the one or more groupings of filter conditions.

15. The computer-readable medium of claim 12, having additional computer executable instructions stored thereon that, when executed by the computer, further cause the computer to:

receive specifications for a plurality of multi-condition data filters;

receive an order of application of the plurality of multi-condition data filters;

parse one or more filter expressions from the specifications;

upon parsing the one or more filter expressions from the specifications, determine an order of application of the one or more filter expressions based at least in part on the order of application of the plurality of multi-condition data filters; and

apply the one or more filter expressions to the summary data in the determined order of application.

16. The computer-readable medium of claim 15, wherein aggregate totals within the summary data are recalculated between each successive application of the one or more filter expressions.

17. The computer-readable medium of claim 12, wherein the computer executable instructions are included in a spreadsheet program.

18. A system for providing multi-condition data filtering of summary data displayed in a summary table, the system comprising:

a computer;

a display device operably connected to the computer;

a first user interface that allows a user to specify a multi-condition data filter comprising a plurality of filter conditions connected by logical operators;

a summary table data access module operative to access source data from a data source (108) and transform the source data into summary data;

a summary table UI module operative to;

display the first user interface on the display device,

receive a specification of a multi-condition data filter from the first user interface, and

display the filtered summary data on the display device in a summary table; and

a summary table data filter module operative to;

parse one or more filter expressions from the specification of the multi-condition data filter based on the plurality of filter conditions and the logical operators,

determine an order of application of the one or more filter expressions, and

apply the one or more filter expressions to the summary data in the determined order of application.

19. The system of claim 18, further comprising a second user interface that allows a user to specify an order of application of a plurality of multi-condition data filters, wherein the summary table UI module is further operative to display the second user interface on the display device and receive the order of application of the plurality of multi-condition data filters, and wherein determining the order of application of the one or more filter expressions further comprises determining the order of application of the one or more filter expressions based at least in part on the order of application of the plurality of multi-condition data filters.

20. The system of claim 18, wherein the summary table data access module, the summary table data filter module, and the summary table UI module are components of a spreadsheet program.