# US 2019/0171748 A1 · Query-based time-series data display and processing system

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

- Number: US 2019/0171748 A1
- Document ID: US20190171748A1
- Status: Published application
- Kind: A1
- Application number: 15/997,177
- Filed: 2018-06-04
- Published: 2019-06-06
- Earliest claimed: 2017-12-04
- Assignees: Palantir Technologies Inc.
- Applicants: Palantir Technologies Inc.
- Inventors: Benjamin Duffield
- Web page: https://patentgrep.com/patent/US20190171748A1

## CPC

- G06F 16/248: Presentation of query results
- G06F 9/451: Execution arrangements for user interfaces
- G06F 16/245: Query processing
- G06F 16/26: Visual data mining; Browsing structured data
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Various systems and methods are described herein for an improved spreadsheet application that allows a user to generate, manipulate, and replicate data visualizations (e.g., sparklines, graphs, charts, etc.) using functions without importing data into cells of the application. For example, data is stored in one or more remote or local data stores accessible to the improved spreadsheet application. A user enters a function into a cell of the improved spreadsheet application. The improved spreadsheet application generates a query using the function, the query identifying a portion of a dataset to retrieve from the data store(s). The improved spreadsheet application then transmits the query to the data store(s) and retrieves the requested data. A renderer of the improved spreadsheet application then renders a sparkline using the retrieved data. The improved spreadsheet application displays the rendered sparkline in the cell in which the function was entered, or at another designated location.

## Claims

### Claim 1

A system comprising:
a renderer;
at least one processor; and
a storage device configured to store computer-executable instructions, the computer-executable instructions, when executed by the at least one processor, cause the system to at least:
generate user interface data that, when rendered by a user device, causes the user device to display a user interface, wherein the user interface depicts a first data cell;
receive an indication that a first function is entered in the first data cell;
generate a first query using the first function;
retrieve a plurality of data using the first query;
render a data visualization using the plurality of data; and
update the user interface data such that the user interface displays the rendered data visualization in the first data cell, while storing the first query as a value of the first data cell.

### Claim 2 (depends on 1)

The system of claim 1, wherein the computer-executable instructions are associated with a first application, wherein the storage device is further configured with second computer-executable instructions associated with a second application, the second computer-executable instructions, when executed by the at least one processor, cause the system to at least:
obtain the first query from the first application;
render a second data visualization using the first query; and
generate second user interface data that, when rendered by the user device, causes the user device to display a second user interface, wherein the second user interface includes the rendered second data visualization.

### Claim 3 (depends on 2)

The system of claim 2, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
obtain an indication from the second application that the rendered second data visualization is modified;
generate a modified version of the first query using the first function and the obtained indication;
retrieve a modified plurality of data using the modified version of the first query;
rendered a modified data visualization using the modified plurality of data; and
update the user interface data such that the user interface displays the rendered modified data visualization in the first data cell.

### Claim 4 (depends on 1)

The system of claim 1, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
receive an indication that a second function is entered in a second data cell, wherein the second function references the first function;
generate a second query using the first function and the second function;
retrieve a second plurality of data using the second query;
render a second data visualization using the second plurality of data; and
update the user interface data such that the user interface displays the rendered second data visualization in the second data cell.

### Claim 5 (depends on 4)

The system of claim 4, wherein the second function references a conditional formatting display operation, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least render the second data visualization according to the conditional formatting display operation in response to a determination that a condition associated with the conditional formatting display operation occurred.

### Claim 6 (depends on 4)

The system of claim 4, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
receive an indication that a third function is entered in a third data cell, wherein the third function references the first function, the second function, and a first condition;
generate a third query using the first function, the second function, and the third function;
retrieve a first value using the third query; and
generate a notification in response to a determination that the first value satisfies the first condition.

### Claim 7 (depends on 1)

The system of claim 1, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
cache the rendered data visualization; and
retrieve the rendered data visualization from cache in response to reception of a re-paint operation.

### Claim 8 (depends on 1)

The system of claim 1, wherein a first timestamp is stored in a second data cell, wherein the first function references the second data cell, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
generate the query using the first function and the first timestamp;
receive an indication that the second data cell is updated to store a second timestamp;
generate a second query using the first function and the second timestamp;
retrieve a second plurality of data using the second query;
render a second data visualization using the second plurality of data; and
update the user interface data such that the user interface displays the rendered second data visualization in the first data cell, while storing the second query as the value of the first data cell.

### Claim 9 (depends on 1)

The system of claim 1, wherein the first query identifies a number of available cell pixels, and wherein the plurality of data comprises, for each available cell pixel, a minimum value and a maximum value, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least render the data visualization by, for each available cell pixel, drawing a line from the respective minimum value to the respective maximum value.

### Claim 10 (depends on 1)

The system of claim 1, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
receive an indication that the first function is pulled to a second data cell, wherein the first function includes a parameter dependent on the location in which the first function is entered; and
enter a second function in the second data cell, wherein the second function comprises the first function with the parameter modified to reflect the location in which the second function is entered.

### Claim 11 (depends on 1)

The system of claim 1, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
receive an indication that the first data cell is resized;
generate a modified query using the first function and a representation of a size of the resized first data cell;
retrieve a second plurality of data using the modified query;
render a second data visualization using the second plurality of data; and
update the user interface data such that the user interface displays the rendered second data visualization in the first data cell.

### Claim 12 (depends on 11)

The system of claim 11, wherein the representation of the size of the resized first data cell comprises at least one of a number of available cell pixels in the resized first data cell or a time duration of a single pixel in the resized first data cell.

### Claim 13 (depends on 1)

The system of claim 1, wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:
receive an indication that the first data cell is selected;
update the user interface data such that the user interface displays a window of a first size;
generate a modified query using the first function and a representation of a size of the window;
retrieve a second plurality of data using the modified query;
render a second data visualization using the second plurality of data; and
update the user interface data such that the user interface displays the rendered second data visualization in the window.

### Claim 14 (depends on 1)

The system of claim 1, wherein the first function comprises a display operation, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least render the data visualization using the plurality of data and the display operation.

### Claim 15 (depends on 1)

The system of claim 1, wherein the rendered data visualization comprises one of a line graph, a bar graph, a pie graph, a sparkline, an X-Y scatterplot, or a chart.

### Claim 16

A computer-implemented method comprising:
generating user interface data that, when rendered by a computing device, causes the computing device to display a user interface, wherein the user interface depicts a first data cell;
receiving an indication that a first function is entered in the first data cell;
generating a first query using the first function;
retrieving a portion of a dataset using the first query;
rendering a data visualization using the retrieved portion of the dataset; and
updating the user interface data such that the user interface displays the rendered data visualization in the first data cell, while storing the first query as a value of the first data cell,
wherein the method is performed using one or more processors.

### Claim 17

One or more non-transitory, computer-readable storage media storing computer-executable instructions, which if performed by one or more processors, cause the one or more processors to at least:
generate user interface data that, when executed, causes a display of a user interface, wherein the user interface depicts a first data cell;
receive an indication that a first function is entered in the first data cell;
generate a first query using the first function;
retrieve a portion of a dataset using the first query;
render a data visualization using the retrieved portion of the dataset; and
update the user interface data such that the user interface displays the rendered data visualization in the first data cell, wherein the first query is stored in the first data cell.
