SYSTEM FOR PROVIDING DYNAMIC LINKED PANELS IN USER INTERFACE

• US 20180024731A1
• Filed: 08/29/2016
• Published: 01/25/2018
• Est. Priority Date: 07/21/2016
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Sanches, Jacob, Chen, Noah, Fernandez, Calvin, Yu, Stephanie, Li, Sixin, Cameron, Geoff
• Granted Patent: US 10,324,609 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 2203/04803 Split screen, i.e. subdividing the display area or the window area into separate subareas
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 8/38 for implementing user interfaces
• CPC Class Codes: G06F 9/44505 Configuring for program initiating, e.g. using registry, configuration files

Abstract

A system is configured to provide a dashboard creation system. Panels associated with queries for retrieving information from a database are shown in a user interface. Various other user interfaces show query code, panel display settings, function code, dependencies, etc. The dependencies can be extracted and used to provide autocomplete and partial refreshing. A timing table shows execution times. Panel outputs and code updates can be shown and compared.

Claims

1. A computer system comprising:

one or more hardware computer processors configured to execute code in order to cause the system to;

generate user interface data configured to be rendered as a user interface, the user interface simultaneously including at least a first display portion and a second display portion, wherein;

the first display portion includes a plurality of panels comprising a first panel configured to generate a visual representation of data according to display settings for the first panel,

the data is retrievable from a database according to a query associated the first panel,

the first panel is associated with code configured to use the data to assign a value to a variable of the first panel,

the variable of the first panel is configured for use in a query associated with a second panel of the plurality of panels, and

the second display portion includes a graphical visualization of relationships among the plurality of panels, the graphical visualization including nodes and edges, at least some of the nodes representing respective ones of the plurality of panels, at least some of the edges representing relationships among respective pairs of the plurality of panels;

receive a first input indicating a relationship between the first panel of the plurality of panels and the second panel of the plurality of panels, wherein the relationship is indicated by associating the variable of the first panel with the query of the second panel;

in response to the first input, update a visual representation of data displayed in the second panel by executing the query of the second panel using the value of the variable of the first panel to retrieve updated data from the database;

receive a second input selecting the first panel in the first display portion; and

in response to the second input, visually indicate, in the second display portion, a node associated with the first panel;

receive a selection of a filter criteria indicating downstream or neighboring dependencies;

wherein the second display portion is further configured to, in response to the selection of the filter criteria;

display, in the visual representation, nodes satisfying the filter criteria; and

filter out from the visual representation a node that does not satisfy the filter criteria.

3. The computer system of claim 1, wherein the user interface further comprises:

a third portion including a list of queries and the coding of a query in the list of queries;

a fourth portion including a list of variables and values of variables in the list of variables; and

a fifth portion including a list of functions and the coding of a function in the list of functions.

4. The computer system of claim 1, wherein the graphical visualization further includes indications of relationships among the plurality of panels, queries, variables, and functions.

5. The computer system of claim 4, wherein nodes are represented as icons that are color coded with different colors for queries, variables, functions, and panels.

7. The computer system of claim 1, wherein the filter criteria is selected from a menu indicating for selection at least:

upstream dependencies;

downstream dependencies; and

neighboring dependencies.

9. The computer system of claim 1, wherein the one or more hardware computer processors are further configured to execute the code in order to cause the system to:

in response to a selection, made in the second display portion, of a node associated with the first panel, visually indicate the first panel in the first display portion.

10. The computer system of claim 1, wherein the graphical visualization comprises a force directed graph.

11. The computer system of claim 1, wherein the relationships among the plurality of panels is stored as information, and, in response to the first panel receiving a change, the information is referenced to identify panels dependent on the first panel.

12. The computer system of claim 1, wherein the one or more hardware computer processors are configured to execute code in order to cause the system to, in response to the first input, update the graphical visualization included in the second display portion to include an edge connecting a first node representing the first panel to a second node representing the second panel.

13. The computer system of claim 1, wherein the user interface includes a third display portion displaying timing information associated with individual panels of the plurality of panels.

14. The computer system of claim 13, wherein the timing information comprises:

a first execution time indicating an amount of time until the query associated the first panel is executed;

a second retrieval time indicating an amount of time until the data from the database is retrieved; and

a third variable time indicating an amount of time until the variable is assigned the value.

15. The computer system of claim 1, wherein the selection of the filter criteria indicates downstream dependencies, and wherein the nodes satisfying the filter criteria is a chain of nodes including a second node separated from the node associated with the first panel by a minimum of two edges.

16. The computer system of claim 1, wherein the second display portion is further configured to, in response to the selection of the filter criteria, filter out from the visual representation a node that does not satisfy the filter criteria by removing the visual representation of the node from the second display portion.

2. (canceled)

6. (canceled)

8. (canceled)