# US 2016/0253308 A1 · Analysis view for pivot table interfacing

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2016/0253308 A1
- Document ID: US20160253308A1
- Status: Published application
- Kind: A1
- Application number: 14/634,594
- Filed: 2015-02-27
- Published: 2016-09-01
- Earliest claimed: 2015-02-27
- Assignees: Microsoft Technology Licensing, LLC
- Applicants: Microsoft Technology Licensing, LLC
- Inventors: Mathew Olinger; Michael G. Davenport
- Web page: https://patentgrep.com/patent/US20160253308A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 3/04817: using icons (graphical or visual programming using iconic symbols G06F8/34)
- G06F 3/0482: Interaction with lists of selectable items, e.g. menus
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Various methods, systems and storage devices are used for creating and utilizing an analysis view for pivot table interfacing. The analysis view can be created with a visualization that reflects data summarized in the pivot table automatically in response to detecting user input directed at a particular data field (i.e., cell) of the pivot table and without requiring any additional user input, such as user input required to navigate a chart wizard or any other graphics interface. The visualization includes at least one selectable and transient object that is configured for being selected and dragged out of the analysis view window and which persists even after the analysis view window is closed, unless it is first dragged outside of the boundaries of the analysis view window and without requiring additional user input for separately closing and/or removing the transient object.

## Claims

### Claim 1

A computing system comprising:
at least one processor; and
at least one storage device having stored computer-executable instructions which, when executed by the at least one processor, implement a method comprising:
accessing a document containing a plurality of populated data fields;
detecting user input directed at a particular data field of the plurality of populated data fields;
determining that the particular data field comprises an aggregate value representing data from a plurality of separate data fields; and
upon determining that the particular data field comprises the aggregate value, automatically generating a visualization that graphically reflects content from the plurality of separate data fields.

### Claim 2 (depends on 1)

The computing system of claim 1, wherein the document comprises a pivot table containing the plurality of populated data fields, each of the plurality of populated data fields in the pivot table comprising a separate cell, such that the user input is directed at a particular cell of the pivot table.

### Claim 3 (depends on 1)

The computing system of claim 1, wherein the method further includes rendering the visualization in an analysis view window automatically in response to detecting that the user input is a predetermined gesture associated with the rendering of the visualization, the visualization decomposing and graphically representing at least some of the content from the plurality of separate data fields that are associated with the aggregate value.

### Claim 4 (depends on 3)

The computing system of claim 3, wherein the gesture comprises hovering a cursor over the particular data field.

### Claim 5 (depends on 3)

The computing system of claim 3, wherein the gesture comprises a double click of a cursor positioned over the particular data field.

### Claim 6 (depends on 3)

The computing system of claim 3, wherein the gesture comprises a selection of a visualization icon or menu option that is automatically presented in response to detecting a cursor positioned over the particular data field.

### Claim 7 (depends on 3)

The computing system of claim 3, wherein the method further includes automatically determining which particular type of visualization should be used, from a plurality of different types of possible visualizations, and without requiring user input defining the particular type of visualization to use.

### Claim 8 (depends on 7)

The computing system of claim 7, wherein the determining which particular type of visualization to use is based on a detected context of the data contained in the plurality of separate data fields.

### Claim 9 (depends on 7)

The computing system of claim 7, wherein the determining which particular type of visualization to use is based on a detected quantity of the plurality of separate data fields.

### Claim 10 (depends on 7)

The computing system of claim 7, wherein the determining which particular type of visualization to use is based on a detected user profile.

### Claim 11 (depends on 7)

The computing system of claim 7, wherein the particular type of visualization is a decomposition chart.

### Claim 12 (depends on 7)

The computing system of claim 7, wherein the particular type of visualization is a comparison chart.

### Claim 13 (depends on 3)

The computing system of claim 3, wherein the method further includes displaying the visualization with a plurality of selectable objects which are operable, when selected, to change the content that is visualized.

### Claim 14 (depends on 3)

The computing system of claim 3, wherein the method further includes displaying the visualization with a plurality of selectable objects which are operable, when selected, to change a dimension or granularity of data decomposition and visualization associated with the content.

### Claim 15 (depends on 1)

The computing system of claim 1, wherein the visualization is initially presented in an analysis view window, and wherein the visualization includes at least one selectable and transient object that is configured for being selected and dragged out of the analysis view window and which persists even after the analysis view window is closed.

### Claim 16

A computer implemented method comprising:
detecting user input directed at a particular cell of a pivot table, the particular cell containing a value representing a plurality of separate data elements; and
automatically in response to detecting the user input, performing the following:
identifying the separate data elements; and
generating a visualization that graphically represents the separate data elements with a plurality of corresponding display elements without requiring any additional user input.

### Claim 17 (depends on 16)

The method of claim 16, wherein the visualization comprises at least one visualization type selected from a grouping including a decomposition chart, a comparison chart, a pie chart, a trend line or a scatter plot.

### Claim 18 (depends on 17)

The method of claim 17, wherein the method further includes detecting a context associated with the separate data elements and selecting the at least one visualization type based on the context.

### Claim 19

A computer program product comprising at least one storage device having stored computer-executable instructions which, when executed by at least one processor of a computing system, implement a method comprising:
detecting user input directed at a particular cell of a pivot table, the particular cell containing a value representing a plurality of separate data elements; and
automatically in response to detecting the user input, performing the following:
identifying the separate data elements; and
generating a visualization that graphically represents the separate data elements with a plurality of corresponding display elements without requiring any additional user input.

### Claim 20 (depends on 19)

The computer program product of claim 19, wherein the method further includes detecting a context associated with the data and determining which of a plurality of different visualization types should be used for generating the visualization.
