Data analysis expressions
OwnerHoward J. Dickerman, Marius Dumitru +4inventors
InventorsHoward J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
Life of this patent
Estimating the term…
Abstract
Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
Claims20
A method executing on one or more computing devices, the method causing the one or more computing devices to:
- receive a data analysis expression associated with a first column of a first table, wherein the data analysis expression creates a relationship between a second column of a second table from a first data structure and a third column of a third table from a second data structure, wherein the second column and the third column are related from the data analysis expression;
- determine the relationship between the second table and the third table using the data analysis expression;
- and
- calculating a value of the data analysis expression associated with a cell in a particular row of the first column using both first data retrieved from the particular row of the second table and second data retrieved from the third table based on a filter context associated with the particular row;
- and
- outputting the calculated value at the cell in the first table.
A computer-readable hardware storage medium storing instructions, that when executed by a computing device, cause the computing device to:
- receive a data analysis expression associated with a column of a first table, wherein the data analysis expression creates a relationship between a second column of the first table and a third column of a second table;
- determine the relationship between the first table and the second table using the data analysis expression;
- calculating a value of the data analysis expression associated with a spreadsheet cell in the first column and in a particular row using both first data in the particular row of the second column and second data retrieved from the third column of the second table, wherein the second column and the third column are related from the data analysis expression, wherein the first data and the second data are selected using a filter context associated with the particular row;
- and
- outputting the value at the spreadsheet cell in the first table.
A method performed by a computing device comprising:
- receive a data analysis expression associated with a first cell in a first column of a first table, wherein the data analysis expression references a second column of the first table and a third column of a second table, wherein the first table and the second table are related by the data analysis expression;
- determine the relationship between the first table and the second table using the data analysis expression;
- calculating a value of the data analysis expression associated with the first cell and in a particular row using both first data in the particular row of the second column and second data retrieved from the third column of the second table, wherein the second column and the third column are related from the data analysis expression, wherein the first data and the second data are selected using a filter context associated with the particular row;
- and
- outputting the value at the first cell in the first table.
Dependencies are inferred from the claim text.