Methods and systems for visual data manipulation

Patent metadata

Field	Value
Publication number	US-11222039-B2
Application number	US-201715487159-A
Country	US
Kind code	B2
Filing date	Apr 13, 2017
Priority date	Apr 14, 2016
Publication date	Jan 11, 2022
Grant date	Jan 11, 2022

Abstract

A system for visual modification of data. The system comprising, an interface layer for displaying data and for receiving one or more visual inputs for modifying data; a data layer for storing data; and an analysis engine layer for connecting the interface layer and the data layer, wherein the analysis engine layer is configured to receive the one or more visual inputs from the graphical interface for modifying the graphical representation; modify the underlying data based on the visual inputs; modify a derived data based on the modified underlying data; and transfer the modified derived data to the interface layer for display.

First claim

The invention claimed is:

1. A method for visual modification of data, the method comprising:
simultaneously displaying a graphical interface and a grid interface, wherein the graphical interface comprises a graphical representation of an underlying data, wherein the graphical representation of the underlying data includes a first chart comprising one or more editable metrics and a second chart comprising one or more values derived from the one or more editable metrics, and wherein the grid interface comprises a tabular representation of the underlying data, wherein the graphical representation of the underlying data includes an original bar, wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar;
receiving one or more visual inputs to the graphical interface for modifying the graphical representation of the underlying data, wherein the one or more received visual inputs modifies at least one of the one or more editable metrics;
in response to the one or more received visual inputs, modifying the underlying data, wherein modifying the underlying data comprises:
changing a corresponding value associated with the at least one of the one or more editable metrics from an original metric value to a modified metric value; and
updating a value of the one or more values derived from the one or more editable metrics from an original derived value to a modified derived value, wherein the original derived value is based at least in part on the original metric value, and wherein the modified derived value is based at least in part on the modified metric value;

displaying, in the graphical interface, an updated first chart and an updated second chart, wherein the updated second chart comprises the original derived value, the modified derived value, and a difference between the modified derived value and the original derived value; and
displaying in the grid interface an updated tabular representation comprising at least one of the modified metric value and the modified derived value.

2. A system for visual modification of data, comprising:
a graphical interface configured to:
simultaneously display a graphical interface and a grid interface, wherein the graphical interface comprises a graphical representation of an underlying data, wherein the graphical representation of the underlying data includes a first chart comprising one or more editable metrics and a second chart comprising one or more values derived from the one or more editable metrics, and wherein the grid interface comprises a tabular representation of the underlying data, wherein the graphical representation of the underlying data includes an original bar, wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar;
receive one or more visual inputs for modifying the graphical representation of the underlying data, wherein the one or more received visual inputs are configured to modify at least one of the one or more editable metrics;

and
a processor configured to:
in response to the one or more received visual inputs, modify the underlying data, wherein to modify the underlying data, the processor is configured to:
change a corresponding value associated with the at least one of the one or more at least one of the editable metrics from an original metric value to a modified metric value; and
update a value of the one or more values derived from the one or more editable metrics from an original derived value to a modified derived value, wherein the original derived value is based at least in part on the original metric value, and wherein the modified derived value is based at least in part on the modified metric value;

display, in the graphical interface, an updated first chart and an updated second chart, wherein the updated second chart comprises the original derived value, the modified derived value, and a difference between the modified derived value and the original derived value; and
display in the grid interface an updated tabular representation comprising at least one of the modified metric value and the modified derived value.

3. A non-transitory computer readable medium storing computer instructions that, when executed by a computer, performs a method for visual modification of data, the method comprising:
simultaneously displaying a graphical interface and a grid interface, wherein the graphical interface comprises a graphical representation of an underlying data, wherein the graphical representation of the underlying data includes a first chart comprising one or more editable metrics and a second chart comprising one or more values derived from the one or more editable metrics, and wherein the grid interface comprises a tabular representation of the underlying data, wherein the graphical representation of the underlying data includes an original bar, wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar;
receiving one or more visual inputs to the graphical interface for modifying the graphical representation of the underlying data, wherein the one or more received visual inputs modifies at least one of the one or more editable metrics;
in response to the one or more received visual inputs, modifying the underlying data, wherein modifying the underlying data comprises:
changing a corresponding value associated with the at least one of the one or more editable metrics from an original metric value to a modified metric value; and
updating a value of the one or more values derived from the one or more editable metrics from an original derived value to a modified derived value, wherein the original derived value is based at least in part on the original metric value, and wherein the modified derived value is based at least in part on the modified metric value;

displaying, in the graphical interface, an updated first chart and an updated second chart, wherein the updated second chart comprises the original derived value, the modified derived value, and a difference between the modified derived value and the original derived value; and
displaying in the grid interface an updated tabular representation comprising at least one of the modified metric value and the modified derived value.

4. The method of claim 1 , wherein a graph chart interface displays one or more of the first chart and the second chart.

5. The method of claim 1 , wherein a bar chart interface displays the original bar or the modified bar.

6. The system of claim 2 , wherein a graph chart interface displays one or more of the first chart and the second chart.

7. The method of claim 2 , wherein the graphical representation of the underlying data includes an original bar.

8. The method of claim 7 , wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar.

9. The method of claim 8 , wherein a bar chart interface displays the original bar or the modified bar.

10. The non-transitory computer readable medium storing computer instructions of claim 3 , wherein a graph chart interfac

Assignees

• Workday Inc

Inventors

• Lee Darren
• Botee Huned
• Cohen Ilan
• Gopalakrishnan Mythili
• Long Peter
• Berston Tim
• Smith Adam

Classifications

• G06T11/26

  Drawing of charts or graphs · CPC title

• G06F16/26 Primary

  Visual data mining; Browsing structured data · CPC title

• G06Q10/06

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06F8/34

  Graphical or visual programming · CPC title

• G06F3/0484

  for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range · CPC title