System for providing dynamic linked panels in user interface

Patent metadata

Field	Value
Publication number	US-10324609-B2
Application number	US-201615250678-A
Country	US
Kind code	B2
Filing date	Aug 29, 2016
Priority date	Jul 21, 2016
Publication date	Jun 18, 2019
Grant date	Jun 18, 2019

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.

First claim

What is claimed is:

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 displayed in the first panel 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, and
the variable of the first panel is configured for use in a query associated with a second panel of the plurality of panels, and

receive a first user input assigning the value to the variable of the first panel;
in response to receiving the first user input, generate a visual representation of second 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 the second data from the database;
based at least in part on the query of the second panel using the variable of the first panel, determine that the second panel has a downstream dependency on the first panel;
display, in the second display portion, 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 dependency relationships among respective pairs of the plurality of panels;
receive a second user input selecting the first panel in the first display portion; and
in response to receiving the second user 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 graphical visualization, nodes satisfying the filter criteria; and
filter out from the graphical visualization a node that does not satisfy the filter criteria;

receive an edit to the query of the first panel;
execute the edited query of the first panel;
identify panels that have downstream dependencies on the first panel, wherein the panels that have downstream dependencies on the first panel include the second panel;
execute queries of the panels that have the downstream dependencies on the first panel; and
display the second display portion simultaneously with a third display portion, the third display portion including:
a comparison of first timing information associated with executing the query of the first panel before receiving the edit and updated first timing information associated with executing the edited query of the first panel; and
a comparison of second timing information associated with executing the query of the second panel before receiving the edit and updated second timing information associated with executing the query of the second panel after receiving the edit.

2. 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.

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

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

5. 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.

6. 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 of the node in the second display portion, the node being associated with the first panel, visually indicate the first panel in the first display portion.

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

8. The computer system of claim 1 , wherein the relationships among the plurality of panels are stored as information, and, in response to receiving the edit to the first panel, the information is referenced to identify the panels that have downstream dependencies on the first panel.

9. 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 receiving the edit to the first panel, update the graphical visualization included in the second display portion to modify at least one edge connected to the node associated with the first panel.

10. The computer system of claim 1 , wherein the first 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.

11. 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.

12. 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 that does not satisfy the filter criteria from the second display portion.

13. 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:
update the first timing information based on executing the query of the first panel after receiving the edit;
update the second timing information based on executing the queries of the panels that have downstream dependencies on the first panel;
display a comparison of the first timing information before and after updating the first timing information; and
display a comparison of the second timing information before and after updating the second timing information.

14. The computer system of claim 13 , 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 executing the edited query of the first panel, update the visual representation of data displayed in the first panel according to display settings for the first panel; and
in response to executing the queries of the panels that have downstream dependencies on the first panel, update visual representations of the panels that have the downstream dependencies on the first panel; and

Assignees

• Palantir Technologies Inc

Inventors

• Sanches Jacob
• Chen Noah
• Fernandez Calvin
• Yu Stephanie
• Li Sixin
• Cameron Geoff

Classifications

• G06F3/04847 Primary

  Interaction techniques to control parameter settings, e.g. interaction with sliders or dials · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F8/38 Primary

  for implementing user interfaces · CPC title

• G06F9/44505

  Configuring for program initiating, e.g. using registry, configuration files · CPC title

• G06F2203/04803

  Split screen, i.e. subdividing the display area or the window area into separate subareas · CPC title