Back to results
US 9,959,267 B2Granted
Filtering user interface for a data summary table
AssigneeMicrosoft Technology Licensing, LLC
InventorsAllan Folting, Thibaut Vial, Robert Hawking
Life of this patent
Estimating the term…
Abstract
A graphical user interface for creating a data summary table includes a data summary table including a plurality of fields, and a filtering pane programmed to apply filters to items in the fields of the data summary table, the filtering pane including a field selector control, wherein the field selector control is programmed to allow for selection of a field of the fields in the data summary table to define filtering for the field.
Claims20
A method for improving efficiency of a computer device when creating a filtered data summary table, comprising:
- creating, by the computing device, a graphical user interface of an application for summarizing data, the graphical user interface comprising:
- a data summary table, wherein the data summary table is initially blank;
- and
- a task pane separate from the data summary table, the task pane including a row zone, a column zone and a value zone;
- receiving a selection of a first non-numeric field from a list of fields;
- receiving a selection of a first filter option available to the first non-numeric field;
- generating a first filtered value based on the first filter option;
- receiving a selection of the first non-numeric field for inclusion in the column zone;
- in response to receiving the selection of the first non-numeric field for inclusion in the column zone:
- displaying the first filtered value as a column label in the data summary table;
- and
- generating a first set of filtered numeric values from a numeric field based on the first filtered value prior to displaying data from the numeric data in the data summary table;
- receiving a selection of the numeric field for inclusion in the value zone;
- and
- in response to receiving the selection of the numeric field for inclusion in the value zone, displaying a summary of the first set of filtered numeric values below the column label in the data summary table.
12 more elements
A computer readable storage device storing computer readable instructions for improving efficiency of a computing device when providing a filtered data summary table, which when executed by a processor unit is operative to perform steps comprising:
- creating a graphical user interface of an application for summarizing data, the graphical user interface comprising:
- a data summary table, wherein the data summary table is initially blank;
- and
- a task pane separate from the data summary table, the task pane including a row zone, a column zone and a value zone;
- receiving a selection of a first non-numeric field from a list of fields;
- receiving a selection of a first filter option available to the first non-numeric field;
- generating a first filtered value based on the first filter option;
- receiving an indication that the first non-numeric field is associated with the row zone;
- in response to the association of the first non-numeric field with the row zone:
- displaying the first filtered value as a row label in the data summary table;
- and
- generating, prior to displaying numeric data from a numeric field in the data summary table, a first set of filtered numeric values from the numeric field based on the first filtered value;
- receiving a selection of the numeric field for inclusion in the value zone;
- and
- in response to receiving the selection of the numeric field for inclusion in the value zone, displaying a summary of the first set of filtered numeric values adjacent to the row label in the data summary table.
12 more elements
A computer system with improved efficiency when providing a filtered data summary table, comprising:
- a processor unit;
- and
- a computer-readable storage device storing instructions that, when executed by the processor unit, cause the processor unit to perform operations to:
- create a graphical user interface of an application for summarizing data, the graphical user interface comprising:
- a data summary table, wherein the data summary table is initially blank;
- and
- a task pane separate from the data summary table, the task pane including a row zone, a column zone and a value zone;
- receive a selection of a first non-numeric field from a list of fields;
- receive a selection of a first filter option available to the first non-numeric field;
- generate a first set of filtered values based on the first filter option;
- receive an indication that the first non-numeric field is placed within the row zone;
- in response to receiving the indication that the first non-numeric field is placed within the row zone, display the first set of filtered values as first row labels in the data summary table;
- receive a selection of a second non-numeric field from the list of fields;
- receive a selection of a second filter option available to the second non-numeric field;
- generate a second set of filtered values based on the second filter option;
- receive an indication that the second non-numeric field is placed within the column zone;
- in response to the indication that the second non-numeric field is placed within the column zone, display the second set of filtered values as first column labels in the data summary table;
- after generating and displaying the first and second sets of filtered values:
- generate a first set of filtered numeric values from a numeric field based on the first and second sets of filtered values;
- receive a selection of the numeric field for inclusion in the value zone;
- and
- in response to receiving the selection of the numeric field for inclusion in the value zone, display a summary of the first set of filtered numeric values at an intersection of the first row labels and the first column labels in the data summary table.
19 more elements
Dependencies are inferred from the claim text.